[ic] UPS charges not correct ( using wrong zip ? )

ACforSale Inc Sales Team interchange-users@icdevgroup.org
Mon Jan 20 01:18:01 2003


>> I am still having a severe problem with the UPS external (web) 
>> lookup. I have the shipping zip as 35006 and default zip as 35006, 
>> but the UPS still appears to be using the 450.csv for zone 
>> calculation or some other zip code table. I have been through the 
>> entire shipping setup and tables and can not find anywhere that the 
>> system is using anything wrong. Everything is set to 350.

>> If it looks up a package for zip 35006 it sets zone 7 or 8 while it 
>> should be zone 2! It charges more to ship to my own zipcode and 
>> neighboring states than it does to the west coast!

>> This is not a new problem, I checked back and it has existed since I 
>> started using Interchange.

>> Also, how can I trap and log the data being sent to UPS and returned?

>> Any ideas?


> Check your variable table to see what the default zip there is set to.

> It should be set to your ship from zip.

> Gerry


All zip code entries were originally set as follows:

UPS_ORIGIN 35006 Shipping
ZIP 35006 Company
SHIP_DEFAULT_ZIP 35006 Shipping

UPS_POSTCODE_FIELD zip Shipping
_______________________________________________

Check your products/shipping.asc file for your zip code you should have
something like this for an external www ups style lookup (I'm shipping
from zip 33155 so modify below to suit your requirements):

GNDRES	UPS Ground Shipping Residential	weight	0	0	e
Nothing to ship!		{'origin' => "33155",'ui_ship_type' =>
"UPSE:GNDRES",'table' => "Ground",'zone' => "330",'ups' => "1",'adder'
=> "0.00",'at_least' => "0.00",'PriceDivide' => "1",'geo' => "zip",}
GNDRES	Ground Shipping	weight	0	150	f [ups-query mode=GNDRES
weight="@@TOTAL@@"]		{'PriceDivide' => "1",}
GNDRES	Ground Shipping	weight	150	9999999	e Too heavy - Please
call for Quote		{'PriceDivide' => "1",}

If you are doing an internal lookup try something like this (I just got
my internal working up to 600lbs - another story - hence the 600 values
below):

INTGND	Ground Shipping (US 48 States)	weight	0	0	e
Nothing to ship!		{'ui_ship_type' => "UPSI",'zone' =>
"330",'table' => "Ground",'ups' => "1",'adder' => "0.00",'at_least' =>
"0.00",'PriceDivide' => "1",'geo' => "zip",}
INTGND	Ground Shipping (US 48 States)	weight	0	600	u 330
[Ground zip]
INTGND	Ground Shipping (US 48 States)	weight	601	9999999	e Please
call for Shipping Quote

What you may need to do also is make sure that the zone file (in my case
products/330.zip) exists and contains the zone information for zone
range zips, you could modify the 450.zip with your data, however I
suggest that you download a new set of zip zone data from UPS and create
your zip zone file.

Hope this helps

Gerry