[ic] USPS International Shiping rates/zones
Dorothy Puma
dorothy at digilink.net
Thu Oct 16 17:44:29 EDT 2003
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
More information about the interchange-users
mailing list