[ic] USPS Priority Mail Shipping via UPS Style Lookup returns zero (whoops... read this one)
JT Justman
interchange-users@interchange.redhat.com
Sun Jan 20 17:28:00 2002
got a little trigger happy : ) Here's the whole thing:
Hello, everyone! I'm using IC 4.8.3 working with an overhauled Foundation
cat (bears little resemblance on the user end). I have been using a flat $5
shipping charge, but I want to only charge the actual Priority Mail charge.
A search on the list turned up several fairly detailed messages about this.
I decided that Jim Balcom's message
(http://interchange.redhat.com/archive/interchange-users/2002/msg07154.html)
was the most detailed. I have tried this numerous ways, here is my latest
attempt:
1) Made the following lines the only ones in shipping.asc:
Priority<tab>Priority<tab>weight<tab>0<tab>0<tab>e Nothing to ship!
Priority<tab>Priority<tab>weight<tab>0<tab>150<tab>u Priority [value
name=zip filter=digits default=22306]<tab>{}
Priority<tab>Priority<tab>weight<tab>150<tab>999999<tab>e @@TOTAL@@ lbs too
heavy for Priority Mail<tab>{}
2) Set up Priority.csv with the data from the USPS website:
Exceed,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.2,5.2,5.2,5.2,5.2,5.2,5.2,5.2
4,6.45,6.45,6.45,6.45,6.45,6.45,6.45,6.45
5,7.7,7.7,7.7,7.7,7.7,7.7,7.7,7.7
...and so on...
I made sure there was a column for each zone, as the original USPS zone
listed 1,2,3 together.
3) Made a Priority.csv.numeric as follows:
Exceed 1 2 3 4 5 6 7 8
Following the example of ground.csv.numeric.
4) In my zone file (450.csv) I added a column called Priority and populated
it with the data in the Ground column:
"ZONE CHART"
"UPS Ground/UPS 3 Day Select/UPS 2nd Day Air/UPS 2nd Day Air A.M./UPS Next
Day Air Saver/UPS Next Day Air/USPS Priority Mail"
"For shipments originating in ZIP Codes 450-01 to 452-99. To determine
zone"
"take the first three digits of the receiver's ZIP Code and refer to the
chart below:"
"ZONES"
Dest. ZIP,Ground,3 Day Select,2nd Day Air,2nd Day Air A.M.,Next Day Air
Saver,Next Day Air,Priority
004-005,4,304,204,244,134,104,4
006-007,-,-,225,-,-,125,-
8,-,-,[1],-,-,[1],-
9,-,-,225,-,-,125,-
...and so on...
This is not my origin zipcode, I am merely using it for testing.
I also tried:
"ZONE CHART"
"Priority"
Dest. ZIP, Priority
001-999, 1
For debuging.
5) I put the following entry in my country.txt:
US<tab>0<tab>US<tab>Priority<tab>United States<tab>USA<tab>840
6) changed catalog.cfg mv_shipmode to Priority
7) Did "apply changes".
8) Put the code:
[shipping-desc Priority][shipping mode='Priority']<BR>
in a page. This returns:
Priority$0.00
And the error:
63.224.203.250 G4mac6Vo:63.224.203.250 - [20/January/2002:11:09:33 -0500]
edenclothing /cgi-bin/edenclothing.cgi/showvars.html Shipping 'u' lookup
called, no zone defined
What does this mean? Is it not finding the zone table, or is it saying that
there is no zone in the rate table to match the zone?
Adding the line:
[data session ship_message]
to my page returns nothing.
-------------------------------
I have tried myriad variations on this, but this seems to be the most
"correct" way to do this. Some things I have tried:
Set up a new method in admin U.I. resulting in the following shipping.asc
lines:
test This is a Test weight 0 0 e Nothing to ship! {'origin' =>
"97477",'ui_ship_type' => "UPSI",'table' => "Priority",'zone' => "450",'ups'
=> "1",'at_least' => "0",}
test This is a Test weight 0 150 u Priority [value name=zip filter=digits
default=22306] {'PriceDivide' => "1",}
test This is a Test weight 150 9999999 e Too heavy for UPS {'PriceDivide'
=> "1",}
With tabs of course.
[shipping-desc test] [shipping mode='test']<BR>
returns:
This is a Test$0.00
And the error:
63.224.203.250 G4mac6Vo:63.224.203.250 - [20/January/2002:10:59:03 -0500]
edenclothing /cgi-bin/edenclothing.cgi/showvars.html 450.csv lookup called,
zone data not found
-------------------
I tried lines similar to the following:
usps USPS Priority weight 0 0 e Nothing to ship! {'adder' => "1",'ups'
=> "1",'table' => "Priority",'ui_ship_type' => "UPSI",'geo' =>
"zip",'zone' => "450",}
usps USPS Priority weight 0 70 u Priority [value name=zip filter=digits
default=45056] {}
usps USPS Priority weight 70 999999 e @@TOTAL@@ lbs too heavy for
Priority Mail {}
tabbed correctly of course. This returned:
63.224.203.250 G4mac6Vo:63.224.203.250 - [20/January/2002:10:59:03 -0500]
edenclothing /cgi-bin/edenclothing.cgi/showvars.html 450.csv lookup called,
zone data not found
(weird session ID, Mac G4 hehe)
-------------------
Basically, I've tried every variation of this method I could find in the
archives or invent on my own with the help of the docs. I'll upload all
related files here:
http://www.signless.com/usps/shipping.asc
http://www.signless.com/usps/Priority.csv
http://www.signless.com/usps/Priority.csv.numeric
http://www.signless.com/usps/Priority.dbm
http://www.signless.com/usps/450.csv
I hope someone will be able to disclose to me the meaning of the first
error, and that will point me in the right direction. I don't see where the
problem is. Does anyone see anything blatantly wrong with this? Any advice
or insight would be appreciated, or if anyone with a working set could just
send me a copy of their files. I promise to post my results to the list for
the sake future lost souls such as myselft : )
Thanks,
JT Justman