[ic] USPS Priority Mail, Canadian Expedited Mail & Shipping options

John Murtari interchange-users@icdevgroup.org
Wed Sep 11 11:46:01 2002


Folks,

        I've been doing some work on customizing a catalog for
a customer who is located in Canada, near the US border.  When he
ships to a US address he wants to offer UPS shipping and also
USPS Priority Mail, no taxes.  When shipping to Canada, just
Expedited Mail, provincial taxes, and 10% tax on all shipping charges.
He has a US drop point and a Canadian drop point for his shipments.
After checking this list and the doc sites, most of it has come
together, and I wanted to share some of the shipping config info
in case anyone else wants to do this (which will follow).

        But I do have a couple of questions which seem simple,
but I haven't come up with a good solution.  We are running
Interchange 4.8.6 on Redhat 7.2 using Apache 1.3.26

    1. He'd like to put a couple of checkboxes up on the checkout
page to offer insurance ($2.00) and delivery confirmation ($.45)
as an option for Priority Mail.  I saw one person do this by just
making them additional shipping options in shipping.asc, but it
seems a little clumsy since you have to offer every combination.

    2. I wanted to just add a 10% multiplier in shipping.asc to
handle Canada and thought I had found an example on a search --
but can't find it again!

        Any examples that do this would be appreciated!

NOTE.  In the US he actually ships from a 990xx zip code, and that
is what is used for UPS (990.csv). I got the priority mail zone
charts for the zip 990xx, and stored them in 980.csv

 Here is the config so far and it does seem to work as far as shipping
and canadian sales tax:

===== country.txt  (entries for US and Canada)
US  0    North America   US      2DA GNDNEW PriorityMail     United States   USA     840
CA  1    North America   CA      ExpeditedMail   Canada  CAN     124

===== shipping.asc

GNDNEW  UPS Ground Commercial   weight  0       0       e Nothing to ship!              { 'ui_ship_type' => "UPSE:GN
DCOM", 'ups' => "0", 'at_least' => "1", adder => "0.00" }
GNDNEW  UPS Ground Commercial   weight  0       150     u Ground [default zip 990]

PriorityMail: USPS Priority Mail
        criteria        weight
        zone            980
        geo             zip
        default_geo     98017
        adder           0
        table           PriorityMail
        ui_ship_type    UPSI

        min             0
        max             0
        cost            e Nothing to ship!

        min             0
        max             150
        cost            u

ExpeditedMail:  Expedited Mail
        criteria        weight
        zone            V1N
        geo             zip
        default_geo     V1N 4J5
        adder           0
        table           ExpeditedMail
        ui_ship_type    UPSI
        str_length      3
        min             0
        max             0
        cost            e Nothing to ship!

        min             0
        max             150
        cost            u

=====  980.csv
"ZONES"
Dest. ZIP,PriorityMail

005-098,8
100-212,8
214-268,8
270-342,8
344,8
346-347,8
... (more)

==== 990.csv
"ZONES"
Dest. ZIP,Ground,3 Day Select,2nd Day Air,2nd Day Air A.M.,Next Day Air Saver,Next Day Air

004-005,8,308,208,248,138,108
006-007,-,-,225,-,-,125
008,-,-,[1],-,-,[1]
009,-,-,225,-,-,125
010-089,8,308,208,248,138,108
090-099,-,-,-,-,-,-
... (more)


=== V1N.csv

"ZONES"
Destination,ExpeditedMail
A0A-A9Z,3
B0A-B9Z,3
C0A-C9Z,3
D0A-D9Z,3
E0A-E9Z,2
F0A-F9Z,3
G0A-G9Z,3



==== ExpeditedMail.csv.numeric

Exceed 2 3 4 5 6 7 8 9   

==== PriorityMail.csv.numeric

Exceed 2 3 4 5 6 7 8


==== ExpeditedMail.csv

Exceed,2,3,12,22,23,31,32,33
1,3.51,3.62,4.15,5.10,5.39,5.56,5.86,6.20
2,3.51,3.62,4.15,5.10,5.39,5.56,5.86,6.20
3,3.66,3.81,4.23,5.38,5.68,5.94,6.26,6.63
4,3.82,4.00,4.43,5.65,5.98,6.33,6.67,7.06
5,3.97,4.19,4.64,5.93,6.27,6.71,7.07,7.48
6,4.12,4.38,4.85,6.20,6.57,7.09,7.48,7.91
7,4.43,4.77,5.26,6.75,7.15,7.86,8.28,8.77
8,4.43,4.77,5.26,6.75,7.15,7.86,8.28,8.77
9,4.58,4.96,5.47,7.03,7.45,8.24,8.69,9.20
... (more)

==== PriorityMail.csv

Exceed,3,4,5,6,7,8
1,3.85,3.85,3.85,3.85,3.85,3.85
2,3.95,4.55,4.90,5.05,5.40,5.75
3,4.75,6.05,6.85,7.15,7.85,8.55
4,5.30,7.05,8.05,8.50,9.45,10.35
5,5.85,8.00,9.30,9.85,11.00,12.15
6,6.30,8.85,9.90,10.05,11.30,12.30
7,6.80,9.80,10.65,11.00,12.55,14.05
8,7.35,10.75,11.45,11.95,13.80,15.75
9,7.90,11.70,12.20,12.90,15.05,17.50
10,8.40,12.60,13.00,14.00,16.30,19.20
... (more)

===- catalog.cfg

UPSZoneFile  products/990.csv
Database            PriorityMail          PriorityMail.csv        CSV
Database            PriorityMail          GUESS_NUMERIC     1
Database            ExpeditedMail          ExpeditedMail.csv        CSV
Database            ExpeditedMail          GUESS_NUMERIC     1

==== variable.txt

TAXAREA AB BC MB NB NF NS NT NU ON PE QC SK YT  Tax
TAXFIELD        state   Tax
TAXRATE AB=7.0, BC=14.5, MB=7.0, NB=15.0, NF=15.0, NS=15.0, NT=7.0, NU=7.0, ON=7.0, PE=7.0, QC=7.0, SK=7.0, YT=7.0      Tax


Thanks!   
-- 
                                          John
___________________________________________________________________
John Murtari                              Software Workshop Inc.
mrlist@thebook.com 315.695.1301(x-211)    "TheBook.Com" (TM)
http://www.thebook.com/