[ic] Shipping Problem - USPS Shipping - Round 3
Russ Mann
tech@khouse.org
Wed, 25 Apr 2001 11:22:58 -0600
Does anyone have USPS shipping implemented in Interchange? Does anyone know
the proper file format for UPS style lookup config files? Thanks
Sent: Monday, April 23, 2001 12:26 PM
To: Interchange Users
Subject: [ic] Shipping Problem - USPS Shipping - Round 2
Sent: Friday, April 20, 2001 1:41 PM
To: interchange-users@lists.akopia.com
Subject: [ic] Shipping Problem - Full Details Enclosed, Does Anyone know how
it works?
Hello List,
I am trying to set up USPS lookup shipping in IC 4.6.4. This is what I've
done:
shipping.asc file:
code description criteria min max formula
0 No shipping weight 0 99999999 e No shipping mode
selected.
default No shipping weight 0 99999999 g PriceDivide
upsg UPS Ground weight 0 0 e Nothing to ship!
upsg UPS Ground weight 0 150 u Ground [value zip]
upsg UPS Ground weight 150 999999 e @@TOTAL@@ lbs too heavy
for UPS
ups3 UPS Three Day weight 0 0 e Nothing to ship!
ups3 UPS Three Day weight 0 150 u 3DaySelect [value zip]
ups3 UPS Three Day weight 150 999999 e @@TOTAL@@ lbs too heavy
for UPS
ups2 UPS Two Day weight 0 0 e Nothing to ship!
ups2 UPS Two Day weight 0 150 u 2ndDayAir [value zip]
ups2 UPS Two Day weight 150 999999 e @@TOTAL@@ lbs too heavy
for UPS
upsbak UPS Two Day AK/HI weight 0 0 c A UPS
products/AKHI.csv 5 1
upsbak UPS Two Day AK/HI weight -1 -1 o PriceDivide=0
upsbak UPS Two Day AK/HI weight 0 0 e Nothing to ship
upsbak UPS Two Day AK/HI weight 0 150 A 2ndDayAir [value
zip]
upsbak UPS Two Day AK/HI weight 150 999999 e Not Available
uspspm USPS Mail weight 0 0 c B products/usps838.csv
uspspm USPS Mail weight -1 -1 o PriceDivide=0
uspspm USPS Mail weight 0 0 e Nothing to ship
uspspm USPS Mail weight 0 70 B Priority [value zip]
uspspm USPS Mail weight 70 999999 e @@TOTAL@@ lbs to heavy for
USPS Mail.
Priority.csv file:
Weight,1,2,3,4,5,6,7,8
1,3.5,3.5,3.5,3.5,3.5,3.5,3.5,3.5
2,3.95,3.95,3.95,3.95,3.95,3.95,3.95,3.95
3,5.15,5.15,5.15,5.15,5.15,5.15,5.15,5.15
4,6.35,6.35,6.35,6.35,6.35,6.35,6.35,6.35
5,7.55,7.55,7.55,7.55,7.55,7.55,7.55,7.55
6,7.9,7.9,7.9,8.1,8.15,8.25,9.5,10.35
7,8.25,8.25,8.25,8.65,8.75,8.95,10.45,11.65
8,8.5,8.5,8.5,9.2,9.35,9.65,11.4,12.95
9,8.65,8.65,8.65,9.75,9.95,10.35,12.35,14.25
10,8.75,8.75,8.75,10.3,10.55,11.05,13.3,15.55
11,9,9,9,10.85,11.15,11.75,14.25,16.85
12,9.25,9.25,9.25,11.4,11.75,12.45,15.2,18.15
13,9.6,9.6,9.6,11.95,12.35,13.15,16.15,19.45
14,9.95,9.95,9.95,12.5,12.95,13.85,17.1,20.75
15,10.3,10.3,10.3,13.05,13.55,14.55,18.05,22.05
16,10.65,10.65,10.65,13.6,14.15,15.25,19,23.35
17,11,11,11,14.15,14.75,15.95,19.95,24.65
18,11.35,11.35,11.35,14.7,15.35,16.65,20.9,25.95
19,11.7,11.7,11.7,15.25,15.95,17.35,21.85,27.25
20,12.05,12.05,12.05,15.8,16.55,18.05,22.8,28.55
(It continues on to 70 lbs.)
usps838.csv file:
"ZONE CHART"
"USPS Priority"
Dest. ZIP, Priority
005-098, 8
100-212, 8
214-268, 8
270-342, 8
344, 8
346-347, 8
349-352, 8
354-355, 8
356-358, 7
359-369, 8
370-372, 7
373-374, 8
375, 7
376-379, 8
380-392, 7
393-395, 8
396-397, 7
399, 8
400-406, 7
407-409, 8
410, 7
411-412, 8
413-414, 7
415-418, 8
420-427, 7
430-438, 7
439, 8
440-443, 7
444-447, 8
448-456, 7
457, 8
458-497, 7
498-516, 6
520-528, 6
530-532, 7
534, 7
535, 6
537-551, 6
553-564, 6
565, 5
566, 6
567, 5
(Continues to all zip codes).
This is the error I get when I restart the interchange daemon:
- - - [20/April/2001:12:41:43 -0800] catalog - Bad shipping file for zone
'B', lookup disabled.
This is the error I get when trying to check out (should be performing the
lookup).
63.46.217.58 xLFAk3ru:63.46.217.58 - [20/April/2001:12:42:46 -0800] catalog
/store/catalog/process.html products/usps838.csv lookup called, zone data
not found
UPS Shipping, and the AK/HI shipping, all work properly.
I've read as many docs as I can, searched the mailing list, and tried many
things by experimentation. Does anyone have any suggestions?
Thanks,
Russ
_______________________________________________
Interchange-users mailing list
Interchange-users@lists.akopia.com
http://lists.akopia.com/mailman/listinfo/interchange-users
_______________________________________________
Interchange-users mailing list
Interchange-users@lists.akopia.com
http://lists.akopia.com/mailman/listinfo/interchange-users