[ic] USPS parcel post domestic and international airmail
internallookups
Curt Hauge
ictech at mnwebdesign.com
Wed Oct 19 11:13:13 EDT 2005
Paul Jordan [jordan at gishnetwork.com] said:
> Hi list
>
> I have temporarily setup USPS Priority internal lookups for a
> catalog. What
> I am interested for this catalog is actually just USPS parcel
> post domestic
> and international airmail rates, internal lookup. I setup Priority lookups
> because my search for the possibility of usps ground was becoming
> dimmer and
> dimmer.
>
> Does anyone know if USPS ground (parcel post) and USPS international air
> mail zones and rates can be integrated with IC for internal
> lookup?
Paul, not sure if this will help, but I have been meaning to post this for
quite awhile. I wrote a how-to to get UPS International to do lookups by
weight / zone. I have reviewed each step to be sure I wrote it correctly (I
hope).
It is kinda kludgy because you have to convert the rate table, but it does
work.
How To Get UPS International shipping by zone to work.
1) Declare your new shipping options in CATROOT/catalog.cfg, something like
this:
Shipping UPSIntl
Shipping Postal default_geo 08010
Shipping QueryUPS default_geo 08010
Database UPSWWE ship/UPSWWE.txt TAB
Database UPS ship/UPS.txt TAB
2) Copy Postal.pm to UPSIntl.pm in ~/lib/Vend/Ship
3) Edit UPSIntl.pm:
Change all words 'Postal' to 'UPSIntl'
Change all words 'usps' to 'UPS'
4) Make a tab separated file called UPS.txt, just like
CATROOT/products/ship/usps.txt, but make it from a
downloaded UPS International zone file like ewwzone. Change the 'zone' field
name to UPSWWE, and also the first field name to 'code', like this:
code name UPSWWE Extended Area Surcharge
AL Albania 907
DZ Algeria 907
AS American Samoa 907
Note: Extended Area Surcharge is not used, although it may be possible to
use it if you rename the field similar to usps.txt, after reviewing
UPSINTL.pm to see how it is utilized. 8-)
5) Download UPS rate table for International service (like Express or
Expedited) and name it UPSWWE.txt
Convert UPSWWE.txt from comma separated values to TAB (it MAY work with
csv's if properly declared in catalog.cfg, but this is how 'Postal' is by
default). Rename fields to 'zone900' instead of '900', like:
weight zone900 zone901 zone902 zone903 zone904 zone905 zone906
zone907 zone908
1 36.50 47.50 47.50 56.25 53.00 53.75 61.75 89.00 89.75
2 44.75 55.50 54.75 65.75 60.00 60.50 77.75 105.50 107.00
6) Make an entry in CATROOT/products/ship/shipping.asc similar to this:
upswe: UPS Worldwide
crit weight
at_least 40
adder @@TOTAL@@ * ($Variable->{UPS_ADDER_PCT} || .10)
table UPSWWE
min 0
max 0
cost e No shipping needed!
min 0
max 150
cost s UPSIntl
min 151
max 9999999
cost e @@TOTAL@@ lbs. is too heavy for UPS!
7) In CATROOT/products/country.txt put'upswe' (without quotes) in the
'shipmodes' field for every
country that you want to use this shipmode. MAKE SURE you have a matching
country code in the UPS.txt file,
or you will have countries coming up with $0 shipping on checkout page.
8) Don't forget to restart!
Good luck!
Curt Hauge
Office 763-689-4984
Cell 612-598-5530
www.IWantAConsultant.com
www.MNWebDesign.com
More information about the interchange-users
mailing list