Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Database and USPS module Problems


ifs23

Recommended Posts

Posted

Hello,

 

I have a quick question. I have been trying to get a shipping module to work for my first osCommerce store, precisely the usps module 4.1.2. I have read all kinds of posts that offer fixes to get this module to work. However, nothing has worked so far.

 

Several posts suggest to apply the following SQL updates:

 

---------------------

UPDATE configuration

SET configuration_value = UPPER(configuration_value),

set_function='tep_cfg_select_multioption(array(''GLOBAL EXPRESS'', ''GLOBAL EXPRESS NON-DOC RECT'', ''GLOBAL EXPRESS NON-DOC NON-RECT'', ''EXPRESS MAIL INT'', ''EXPRESS MAIL INT FLAT RATE ENV'', ''PRIORITY MAIL INT'', ''PRIORITY MAIL INT FLAT RATE ENV'', ''PRIORITY MAIL INT FLAT RATE BOX'', ''FIRST-CLASS MAIL INT''), '

WHERE configuration_key='MODULE_SHIPPING_USPS_TYPES_INTL';

 

UPDATE configuration

SET configuration_value = UPPER(configuration_value),

set_function='tep_cfg_select_multioption(array(''EXPRESS'', ''PRIORITY'', ''FIRST CLASS'', ''PARCEL'', ''BPM'', ''LIBRARY'', ''MEDIA''), '

WHERE configuration_key='MODULE_SHIPPING_USPS_TYPES'

-----------------------

 

I tried to do these SQL updates, but I took a look at my database and there is no configuration_key that equals 'MODULE_SHIPPING_USPS_TYPES' in the configuration table. Am I missing something? What do I need to do to get this to work?

 

Any help would be greatly appreciated, since I have a client that expects his store to be done soon. Thanks.

Posted
Did you sign up for a usps account and then have them set you to production??????????

 

 

Yes, I did all that. Signed up for an usps account and got activated too. Is there anything else I need to do?

Posted

Change your tax zone to your state and make sure all your configuration MY Store info is correct. Under Shipping/Packaging make sure your zip code is there.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...