[ic] Help with shipping zone setup

sstreich interchange-users@interchange.redhat.com
Tue May 7 12:28:00 2002


Since I evidently can't read very well I need some suggestions on what I did
wrong setting up zone files for IC.
I am running 4.8.1 with MYSQL
Currently the setup for using UPS shipping zones is working fine, However I
want to also offer Priority Mail shipping.
Upon doing what I read on the boards Now I get an error in the log;
Error message from log:
/cgi-bin/streichs/process.html Zone 'u' lookup failed, type 'Priority' not
found

What I have done so far.
Added these lines to /products/shipping.asc
USPSPM Priority Mail weight 0 0 e Nothing to Ship!
USPSPM Priority Mail weight 0 70 u Priority  [default zip 163] {}
USPSPM Priority Mail weight 70 999999 e @@TOTAL@@ lbs to heavy for Priority
Mail {}

Copied and renamed  /products/Ground.db to Priority.db
/products/Ground.csv to Priority.csv
"Exceed","2","3","4","5","6","7","8"
"1","3.02","3.12","3.35","3.40","3.59","3.63","3.73"
"3","3.17","3.43","3.81","3.97","4.26","4.40","4.81"
"5","3.42","3.71","4.20","4.43","4.72","4.92","5.43" (trimmed this for
mailing)

/products/Ground.autonumber to Priority.autonumber
#COUNTER-1.0
00001

/products/Ground.csv.numeric to Priority.csv.numeric
Exceed 2 3 4 5 6 7 8

IN /dbconfig/default_db
added:
Priority.dbm
Database            Priority         Priority.csv        CSV
Database            Priority          GUESS_NUMERIC     1

IN /dbconfig/mysql
added:
Priority.dbm
Database            Priority          Priority.csv        CSV
Database            Priority          GUESS_NUMERIC     1

Since I want to run both Priority and UPS I downloaded the zone table from
UPS for my zip code (16313) and added Priority as a new column using the
same zone numbers as UPS. figured I could fix errors later if any were found
in the zones.
First few lines of 163.csv
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/Priority,,,,,,,,
For shipments originating in ZIP Codes 163-01 to 163-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,3,303,203,243,133,103,3,
006-007,-,-,225,-,-,125, -,
8,-,-,[1],-,-,[1], -,
9,-,-,225,-,-,125, -,
010-045,4,304,204,244,134,104,4,
046-047,5,305,205,-,135,105,5,
048-067,4,304,204,244,134,104,4,
068-083,3,303,203,243,133,103,3,

IN catalog.cfg
# Cart, order, and route settings.
ParseVariables  Yes
ValuesDefault   country      __SHIP_DEFAULT_COUNTRY__
ValuesDefault   mv_shipmode  __SHIP_DEFAULT_MODE__
DefaultShipping __SHIP_DEFAULT_MODE__
UPSZoneFile  products/163.csv  (I added this line)
Database Priority Priority.csv CSV  (and also this line)
MailOrderTo     __ORDERS_TO__
AlwaysSecure    ord/checkout login change_password

In country.txt and also in country.sql
US 0  US GNDRES USPSPM  United States USA 840

I also added USPSPM to the admin
Reconfigured catalog and restarted the IC server.
I played with these setting quite a bit and nothing seemed to make a
difference, so evidently not playing with the right ones.
I did try to add PriorityZoneFile /products/163.csv in place of UPSZoneFile
but catlog refused to load on restart.

Any advise would be greatly appreciated.
Thanks
Steve