Step 1)
To get ups domestic shipping to work when shipping to canada please make sure you have the metods below added into your 'realtime 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 ;