Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Usps International Shipping Issue


amitxox

Recommended Posts

Has this problem been resolved. With the international customers getting this message.

 

An error occured with the USPS shipping calculations.

If you prefer to use USPS as your shipping method, please contact the store owner.

 

If so please do let me know what needs to be done to resolve this. I have some international customers that are getting this message since the USPS rate update.

 

Thanks

 

Amit

Link to comment
Share on other sites

i went through and followed the directions to a tee, multiple times even, went ahead and removed the usps shipping module and reinstalled the usps methods files clean as you like, installed the module and still i get the error with international shipping.

 

is there something missing? has anyone else figured out the magic combination to make this work?

 

colby

Link to comment
Share on other sites

okay, i got it. it was a little tricky, and it might have to do with the order of my actions. but get the 2.8d usps method files. make the changes in the most recent Updates file by kbucher.

 

Before you upload these files, REMOVE the USPS module in the oscommerce admin.

 

upload the changed files. INSTALL the usps module, thn go and make the SQL updates withing kbuchers notes.

 

i went straight to the production server and had it working.

 

good times.

Link to comment
Share on other sites

i did not install my oscommerce cart so may be a naive question but where and how do i make the sql changes. please do let me know.

 

thanks

 

 

okay, i got it. it was a little tricky, and it might have to do with the order of my actions. but get the 2.8d usps method files. make the changes in the most recent Updates file by kbucher.

 

Before you upload these files, REMOVE the USPS module in the oscommerce admin.

 

upload the changed files. INSTALL the usps module, thn go and make the SQL updates withing kbuchers notes.

 

i went straight to the production server and had it working.

 

good times.

Link to comment
Share on other sites

i did not install my oscommerce cart so may be a naive question but where and how do i make the sql changes. please do let me know.

 

thanks

 

you're probably going to have to use phpmyadmin, if you don't know what or where that is, you should ask your host to help a bit. it's easier than learning it, although this is an easy enough introduction.

Link to comment
Share on other sites

okay, i got it. it was a little tricky, and it might have to do with the order of my actions. but get the 2.8d usps method files. make the changes in the most recent Updates file by kbucher.

 

Before you upload these files, REMOVE the USPS module in the oscommerce admin.

 

upload the changed files. INSTALL the usps module, thn go and make the SQL updates withing kbuchers notes.

 

i went straight to the production server and had it working.

 

good times.

 

I have been running an OSC site for two years with no problems...until the rate change.

 

So, I do the install:

 

"USPS Methods_2.8d"

"USPS Methods Update for Postal Rates & Services Changes 5.14.07"

 

 

It was pretty simple and straight forward both adding the contribution and doing the SQL changes but now I get this for international addresses but not domestic addresses.

 

-2147219080 - Missing value for Country.

 

I realize that this is typically because the improper country is selected in the admin -->config...but I have United States selected and my zip code is entered.

 

 

Any ideas on how to get this fixed for my international orders?

 

This is a live site, so any help would be greatly appreciated.

 

Sincerely,

Mark

Link to comment
Share on other sites

Ok...I decided to re-install the "USPS Methods_2.8d" & "USPS Methods Update for Postal Rates & Services Changes 5.14.07"

 

1.) Turn off ("remove") the USPS shipping module in your admin first (be sure to save all your USPS server login / password info first)

 

2.) Install "USPS Methods_2.8d" per the instructions

 

http://www.oscommerce.com/community/contri...ch,usps+methods

 

3.) Install "USPS Methods Update for Postal Rates & Services Changes 5.14.07" per the instructions

 

4.) In PHPAdmin, run the SQL queries.

 

5.) In OSC Admin, re-install the USPS shipping module and edit the info for you server login/password and make sure you're on the "production" server.

 

Works like a charm now. I believe the the error is caused by an improper installation during the editing of the USPS.php file. Instead of replacing code, comment out the old code by placing a /* before and a */ after the old code. Then paste in the new code.

 

Here's my tip - go slow...some the code that needs to be replaced in the USPS.php file looks the same in 5 places but read CAREFULLY and make sure you are replacing the EXACT same code. Not sure if this was my problem but it's working now, so I am pretty sure that's what occurred.

 

Either that or I ran the first SQL query and didn't run BOTH SQL queries

 

Good luck!

 

~Mark

Link to comment
Share on other sites

Guys,

 

One more question.

 

In phpmyadmin do I need to execute both these queries and do I just copy and paste it in the Run SQL query/queries on server localhost: window. Please do let me know.

 

Thanks

 

Amit

 

Execute this SQL update:

 

ALTER TABLE `configuration` CHANGE `set_function` `set_function` VARCHAR( 555 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL;

 

Execute this SQL update if you already have the module installed and are updating:

 

UPDATE `configuration` SET `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' LIMIT 1 ;

 

 

Ok...I decided to re-install the "USPS Methods_2.8d" & "USPS Methods Update for Postal Rates & Services Changes 5.14.07"

 

1.) Turn off ("remove") the USPS shipping module in your admin first (be sure to save all your USPS server login / password info first)

 

2.) Install "USPS Methods_2.8d" per the instructions

 

http://www.oscommerce.com/community/contri...ch,usps+methods

 

3.) Install "USPS Methods Update for Postal Rates & Services Changes 5.14.07" per the instructions

 

4.) In PHPAdmin, run the SQL queries.

 

5.) In OSC Admin, re-install the USPS shipping module and edit the info for you server login/password and make sure you're on the "production" server.

 

Works like a charm now. I believe the the error is caused by an improper installation during the editing of the USPS.php file. Instead of replacing code, comment out the old code by placing a /* before and a */ after the old code. Then paste in the new code.

 

Here's my tip - go slow...some the code that needs to be replaced in the USPS.php file looks the same in 5 places but read CAREFULLY and make sure you are replacing the EXACT same code. Not sure if this was my problem but it's working now, so I am pretty sure that's what occurred.

 

Either that or I ran the first SQL query and didn't run BOTH SQL queries

 

Good luck!

 

~Mark

Link to comment
Share on other sites

I have tried to follow the installation procedures many times, and each time I get the same error when I go to edit the usps in the admin where everything shows up except the list of checkboxes for international options:

 

Parse error: syntax error, unexpected T_GLOBAL, expecting ')' in /home/hsphere/local/home/esilk/thepicturemug.com/admin/modules.php(216) : eval()'d code on line 1

 

Also, when I tried to run the sql command:

ALTER TABLE `configuration` CHANGE `set_function` `set_function` VARCHAR( 555 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL;

I got an sql error:

#1074 - Too big column length for column 'set_function' (max = 255). Use BLOB instead

 

I tried changing it from 555 to 255, but then got the error:

#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'COLLATE latin1_swedish_ci NULL DEFAULT NULL' at line 1

 

Before I do the USPS51407RateServiceChangeUpdates.zip, the parse error does not show, but of course I get the usps error when trying to checkout from the store.

 

The parse error also does not appear if the only things I DON'T do are changing the "tep_db_query("insert into..." statement in the /catalog/modules/shipping/usps.php file AND don't run the sql queries.

 

It seems so straightforward but I'm very confused since I've repeated the steps so many times and still no go.

 

Any ideas where I'm going wrong with this?

 

Thanks!

Link to comment
Share on other sites

OK...Nevermind. I found the problem is that my server is running MySQL v4.0.26

 

I changed the first MySQL command to:

 

ALTER TABLE `configuration` CHANGE `set_function` `set_function` TEXT

 

instead of:

 

ALTER TABLE `configuration` CHANGE `set_function` `set_function` VARCHAR( 555 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL;

 

and everything worked fine.

 

I'm going to see if I can update the USPSMethods_2.8d Updates for May 14 Rates & Service Changes (minor correction) contribution with the requirements for servers with MySQL below version 5.0.3

 

cheers!

Link to comment
Share on other sites

I am running version MySQL client version: 4.1.10 so I guess change so basically change `set_function` VARCHAR( 555 ) to `set_function` TEXT. Any length of characters needs to be specified ?

 

 

 

OK...Nevermind. I found the problem is that my server is running MySQL v4.0.26

 

I changed the first MySQL command to:

 

ALTER TABLE `configuration` CHANGE `set_function` `set_function` TEXT

 

instead of:

 

ALTER TABLE `configuration` CHANGE `set_function` `set_function` VARCHAR( 555 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL;

 

and everything worked fine.

 

I'm going to see if I can update the USPSMethods_2.8d Updates for May 14 Rates & Service Changes (minor correction) contribution with the requirements for servers with MySQL below version 5.0.3

 

cheers!

Link to comment
Share on other sites

  • 2 weeks later...

Problem solved. Follow the steps above and you should be all set. Thanks guys !

 

I am running version MySQL client version: 4.1.10 so I guess change so basically change `set_function` VARCHAR( 555 ) to `set_function` TEXT. Any length of characters needs to be specified ?
Link to comment
Share on other sites

I've just done this mod and upgrade but now I get an error saying:

Parse error: parse error, unexpected T_STRING, expecting ')' in /home/content/s/c/o/scootercentral/html/shop/admin/modules.php(216) : eval()'d code on line 1

 

I've taken the modules.php file directly from the original 2.8d mod.

 

I also don't have any international options to choose from.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...