[Date Prev][Date Next][Thread Prev][Thread Next][Interchange by date
][Interchange by thread
]
[ic] USPS Priority Mail, Canadian Expedited Mail & Shipping options
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/