ifs23 Posted May 26, 2008 Posted May 26, 2008 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.
usernamenone Posted May 27, 2008 Posted May 27, 2008 Did you sign up for a usps account and then have them set you to production??????????
ifs23 Posted May 27, 2008 Author Posted May 27, 2008 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?
usernamenone Posted May 27, 2008 Posted May 27, 2008 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.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.