[ic] Zero cost returned for mode Ground, geo code 335.

Dan Garwood res087jh@verizon.net
Wed, 7 Mar 2001 18:01:22 -0500


We are trying to set up UPS shipping on our store. I downloaded the zone
file for our location (i.e. 463.cvs). I have this defined in catalog.cfg
with the following lines:

## Set some initial values
ValuesDefault    mv_shipmode       upsg

UpsZoneFile   products/463.csv

We started with the Internal UPS Lookup received the following error:

Zero cost returned for mode Ground, geo code 335. on the checkout.html page
when the zip was set for 33566.

I tried editing shipping with the Admin, than was able to get it working by
using the WWW UPS Lookup. Upon taking the site live, we would get timeout
and no shipping. We decided to come back to the internal UPS lookup style.
Now I am faced again with the same dilemma of the above error. What follows
is configuration and files involved.

System Setup

System one
PIII 800 mghz
768 Megs Ram
Running Apache, Interchange, and Mysql(only for connectivity to machine 2)

System two
PIII 800 mghz
768 megs Ram
Running MYSQL


Machines set on a T3 with 100 meg bit cards.

#Area of Zone File 463.csv Where zip should be calculated from? (I believe)

304,5,305,205,245,135,105
305-307,4,304,204,244,134,104
308-310,5,305,205,245,135,105
311,4,304,204,244,134,104
312-329,5,305,205,245,135,105
330-334,6,306,206,246,136,106
335-338,5,305,205,245,135,105
339,6,306,206,246,136,106
340,-,-,-,-,-,-
341,6,306,206,246,136,106
342-347,5,305,205,245,135,105
349,6,306,206,246,136,106


#Shipping.asc

upsg    UPS Ground      weight  0       0       e Nothing to ship!
{'ui_ship_type' => "UPSI",'tabl
e' => "Ground",'zone' => "463",'ups' => "1",'adder' => "x = x + ( x *
.40 )",'round' => "1",'geo' => "zip",}
upsg    UPS Ground      weight  0       150     u Ground [value name=zip
default=46368]         {}
upsg    UPS Ground      weight  150     999999  e @@TOTAL@@ lbs too heavy
for UPS               {}
upsb    UPS Two Day     weight  0       0       e Nothing to ship!
{'ui_ship_type' => "UPSI",'zone
' => "463",'table' => "2ndDayAir",'ups' => "1",'adder' => "x = x + ( x *
.40 )",'geo' => "zip",}
upsb    UPS Two Day     weight  0       150     u 2ndDayAir [value name=zip
default=46368]              {}
upsb    UPS Two Day     weight  150     999999  e @@TOTAL@@ lbs too heavy
for UPS               {}
upsr    UPS Next Day    weight  0       0       e Nothing to ship!
{'ui_ship_type' => "UPSI",'tabl
e' => "NextDayAir",'zone' => "463",'ups' => "1",'adder' => "x = x + ( x *
.40 )",'geo' => "zip",}
upsr    UPS Next Day    weight  0       150     u NextDayAir [value name=zip
default=46368]             {}
upsr    UPS Next Day    weight  150     999999  e @@TOTAL@@ lbs too heavy
for UPS               {}
ups3    UPS Three Day   weight  0       0       e Nothing to ship!
{'ui_ship_type' => "UPSI",'tabl
e' => "3DaySelect",'zone' => "463",'ups' => "1",'adder' => "x = x + ( x *
.40 )",'geo' => "zip",}
ups3    UPS Three Day   weight  0       150     u 3DaySelect [value name=zip
default=46368]    {}
 {}
ups3    UPS Three Day   weight  150     999999  e @@TOTAL@@ lbs too heavy
for UPS               {}
 {}

permissions on all files in products are set to 660 and owned by interch
(user that runs interchange) and abicom (user that owns the store).

I searched the archives and only return something about Canadian shipping
with no real fix for the problem. I also read the Reference manual in the
section Database, subsection shipping. Which helped understand this greatly,
but did not give the solution to this specific error.

I have also tried the following line in the shipping.asc file:

[value name=zip filter=digits default=46368] vs. what we have now [value
name=zip default=46368]

Any help on this would be greatly appreciated.

Here is a link to the site if it helps in visualize what I have done.

http://www.abilitywholesale.com

Sincerely,
Dan Garwood