[ic] USPS Priority Mail Shipping via UPS Style Lookup returns zero

JT Justman interchange-users@interchange.redhat.com
Sun Jan 20 21:49:01 2002


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