Usps International Shipping Calculatioin Does Not Work

[hirokun]

USPS International shipping calculation suddenly stopped working. If the shipping address is in the US, USPS calculation works just fine and be able to check out, but if the shipping address is out side of the US such as "United Kingdom", "Japan" , then the error message: "An error occured with the USPS shipping calculations. If you prefer to use USPS as your shipping method, please contact the store owner." displays.

 

It was working just fine till a few days ago. Did USPS change something? What do we need to do for the international shippng to function again?

Can anyone help??

 

hk

[hirokun]

My current international array shows:

 

$this->intl_types = array(

'Express' => 'Global Express Mail (EMS)',

'Priority Lg' => 'Global Priority Mail - Flat-rate Envelope (Large)',

'Priority Sm' => 'Global Priority Mail - Flat-rate Envelope (Small)',

'Priority Var' => 'Global Priority Mail - Variable Weight (Single)',

'Airmail Letter' => 'Airmail Letter Post',

'Airmail Parcel' => 'Airmail Parcel Post',

'Surface Letter' => 'Economy (Surface) Letter Post',

'Surface Post' => 'Economy (Surface) Parcel Post');

 

$this->countries = $this->country_list();

}

 

I wonder if these options have been changed with the latest rate change with USPS...

Does anyone know???

 

HK

[Guest]

My current international array shows:

 

$this->intl_types = array(

'Express' => 'Global Express Mail (EMS)',

'Priority Lg' => 'Global Priority Mail - Flat-rate Envelope (Large)',

'Priority Sm' => 'Global Priority Mail - Flat-rate Envelope (Small)',

'Priority Var' => 'Global Priority Mail - Variable Weight (Single)',

'Airmail Letter' => 'Airmail Letter Post',

'Airmail Parcel' => 'Airmail Parcel Post',

'Surface Letter' => 'Economy (Surface) Letter Post',

'Surface Post' => 'Economy (Surface) Parcel Post');

 

$this->countries = $this->country_list();

}

 

I wonder if these options have been changed with the latest rate change with USPS...

Does anyone know???

 

HK

 

I'm seeing the exact same thing. With all the recent rate changes, they either made changes the International Rate Calculator API that don't work with the old module, or they just broke it. From past experience, my guess is they just broke it. :(

 

I emailed them about it and am waiting for a reply, but if anyone knows anything else please post. I have several international customers that were trying to make purchases and could not because of this.

 

J.B.

[Guest]

Check out http://www.oscommerce.com/forums/index.php?showtopic=263145 for the answer.

[Danbob]

Thanks for the info, but it sure didn't work here. I ended up breaking all USPS shipping options. I reverted the database back to the backup, re-installed USPS_Methods, and at least got back to the point where we can take domestic US orders again, with an error message for international customers that I customized to say they should call or email for an international shipping quote. (sighhhhhh.)

I have a heavily customized store, so all major changes like this can be difficult. Would have been nice is the USPS had notified us ahead of time---I'm actually on hold with them right now to make sure they have all our most recent contact info.

Dan

 

 

Check out http://www.oscommerce.com/forums/index.php?showtopic=263145 for the answer.

[Guest]

I performed the update 2 days ago. After making the file changes detailed in the update, you have to update the database with these 2 alterations:

 

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

 

and

 

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_id` =196 LIMIT 1 ;

 

If you haven't applied both of those updates then you won't see the International options in the USPS module, especially if you don't extend the VARCHAR to (555) in the first update - because there aren't enough characters then to show all of the options. If you are using a mySQL version below 5.0.3, you can change the data type to TEXT instead of VARCHAR(555).

 

Also check out this thread, starting around post 136:

http://www.oscommerce.com/forums/index.php?sho...6950&st=120