[ic] USPS International Shiping rates/zones

[Dorothy Puma]

Hi All,

I know in the past, many people have been looking for the zone and rate 
files for USPS International rates. I have successfully created zone 
files for USPS Global Express Mail, USPS Global Priority Mail and Global 
Air Parcel Post.  These zone files are based on the 2 digit country 
codes.  I have also modified the country.txt file to correspond to the 
USPS country table.  Along with the appropriate rate files for each of 
these methods.  Although Air Parcel Post allows up to 70lbs, I only went 
up to 44lbs for my needs.

Here's my shipping.asc file (please note the geo is looking for country 
and the str_length changes the default 3 to a 2:

[snip]
EMS	USPS Global Express Mail - 3 to 5 days	weight	0	0	e Nothing to 
ship!		{'ui_ship_type' => "UPSI",'table' => "ems_rates",'zone' => 
"123",'at_least' => "16.85",'adder' => "3.00",'str_length' => "2",'geo' 
=> "country",}
EMS	USPS Global Express Mail - 3 to 5 days	weight	0	70	u	 
{''ui_ship_type' => "UPSI",'table' => "ems_rates",'zone' => 
"123",'adder' => "3",'PriceDivide' => "1",'geo' => 
"country",'str_length' => "2",}
EMS	USPS Global Express Mail - 3 to 5 days	weight	0	71	e Too heavy 
for USPS		{''ui_ship_type' => "UPSI",'table' => "ems_rates",'zone' => 
"123",'adder' => "3",'PriceDivide' => "1",'geo' => 
"country",'str_length' => "2",}
GPM	USPS Global Priority Mail - 4 to 6 days	weight	0	0	e Nothing to 
ship!		{'ui_ship_type' => "UPSI",'table' => "gpm_rates",'zone' => 
"234",'at_least' => "11.00",'adder' => "3.00",'str_length' => "2",'geo' 
=> "country",}
GPM	USPS Global Priority Mail - 4 to 6 days	weight	0	4	u	 
{''ui_ship_type' => "UPSI",'table' => "gpm_rates",'zone' => 
"234",'adder' => "3",'PriceDivide' => "1",'geo' => 
"country",'str_length' => "2",}
GPM	USPS Global Priority Mail - 4 to 6 days	weight	0	5	e Too heavy for 
USPS, use Express Mail Instead		{''ui_ship_type' => "UPSI",'table' => 
"gpm_rates",'zone' => "234",'adder' => "3",'PriceDivide' => "1",'geo' => 
"country",'str_length' => "2",}
APP	USPS Air Parcel Post  - 4 to 10 days	weight	0	0	e Nothing to ship!	 
{'ui_ship_type' => "UPSI",'table' => "app_rates",'zone' => 
"345",'at_least' => "11.00",'adder' => "3.00",'str_length' => "2",'geo' 
=> "country",}
APP	USPS Air Parcel Post - 4 to 10 days	weight	0	44	u		{''ui_ship_type' 
=> "UPSI",'table' => "app_rates",'zone' => "345",'adder' => 
"3",'PriceDivide' => "1",'geo' => "country",'str_length' => "2",}
APP	USPS Air Parcel Post - 4 to 10 days	weight	0	45	e Too heavy for 
USPS, use Express Mail Instead		{''ui_ship_type' => "UPSI",'table' => 
"app_rates",'zone' => "345",'adder' => "3",'PriceDivide' => "1",'geo' => 
"country",'str_length' => "2",}
[/snip]


If you would like the zone/rate files you can get them here:

EMS (Express Mail) zone file: 
http://www.storeofmartialarts.com/ic/usps/123.csv

EMS rate file: http://www.storeofmartialarts.com/ic/usps/ems_rates.csv

GPM (Global Priority Mail) zone file: 
http://www.storeofmartialarts.com/ic/usps/234.csv

GPM rate file: http://www.storeofmartialarts.com/ic/usps/gpm_rates.csv

APP (Air Parcel Post) zone file: 
http://www.storeofmartialarts.com/ic/usps/345.csv

APP rate file: http://www.storeofmartialarts.com/ic/usps/app_rates.csv


And the updated country.txt file is at 
http://www.storeofmartialarts.com/ic/usps/country.txt


Also, remember to place your ems_rates.dbm, gpm_rates.dbm, and 
app_rates.dbm files in your appropriate dbconf directory, restart and 
should be up and running.

If you have any questions, please let me know.

Thanks,
Dorothy