[Date Prev][Date Next][Thread Prev][Thread Next][Interchange by date
][Interchange by thread
]
[ic] USPS Priority Mail Shipping via UPS Style Lookup returns zero
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
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:
-------------------
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
So...
Where exactly is the zone lookup specified? I see the following in How
Shipping is Calculated in icdatabase it says:
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