Step 1)
To get ups domestic shipping to work when shipping to Canada please make sure you have the methods below added into your 'real time shipping methods'.
Code: US Orgin
01 UPS Next Day Air_
2 UPS 2nd Day Air_
3 UPS Ground
07 UPS Worldwide ExpressSM
UPS Worldwide ExpeditedSM
11 UPS Standard
12 UPS 3 Day Select
13UPS Next Day Air Saver
14 UPS Next Day Air_ Early A.M.
54 UPS Worldwide Express PlusSM
Code Canada
01 UPS Express
02 PS Expedited
03 n/a
07 UPS Worldwide Express
08 PS Worldwide Expedited
11 UPS Standard
12 UPS 3 Day Select
13 UPS Express Saver
14 UPS Express Early A.M.
54 UPS Worldwide Express PlusSM
Step 2)
After you have added the shipping methods above you will need to run the following mysql command on your database.
UPDATE `354`.`shipping_selected` SET `country` = '1,2' WHERE `shipping_selected`.`ssid` =2 LIMIT 1 ;
