ISO Codes for Canada

[alichance]

Hello there,

 

I'm locating in the states but want to start shipping to Canada. Do any of you know the ISO codes for Canada?

 

Thx!

[insomniac2]

ISO Code(2) = CA

ISO CODE(3) = CAN

 

 

If you do not have the provinces in your zones table you'll need to add them into the TABLE zones

 

INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name ) VALUES ('',38,'AB','Alberta');

INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name ) VALUES ('',38,'BC','British Columbia');

INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name ) VALUES ('',38,'MB','Manitoba');

INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name ) VALUES ('',38,'NB','New Brunswick');

INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name ) VALUES ('',38,'NL','Newfoundland');

INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name ) VALUES ('',38,'NT','Northwest Territories');

INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name ) VALUES ('',38,'NT','Nunavut');

INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name ) VALUES ('',38,'NS','Nova Scotia');

INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name ) VALUES ('',38,'ON','Ontario');

INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name ) VALUES ('',38,'PE','Prince Edward Island');

INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name ) VALUES ('',38,'QC','Quebec');

INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name ) VALUES ('',38,'SK','Saskatchewan');

INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name ) VALUES ('',38,'YT','Yukon');

Edited September 30, 2006 by insomniac2