ISO Code and shipping by flat rate question.

[Guest]

I currently have a flat rate for shipping to anywhere in the US.

 

Today my distributor and I agreed on a flat rate price for shipping to Canada.

 

But since I did not ship to Canada before, I have deleted all of the other contries info from both my "Countries" and "Zones" area in the admin.

 

3 Questions.

 

Can someone copy and past the "Countries" info for Canada from their admin area for me?

 

Can someone copy and past the "Zones" info for Canada from their admin area for me?

 

Can someone point me to a good explination of the "Zone" shipping option that can tell me how to have a flate rate for shipping to all of the US and another flat rate for shipping to all of Canada?

 

Thank you very much for you help!

[Guest]

Some one....

 

Anyone.......

 

Thanks!

[Guest]

please don't bump your msgs - they will get answered as soon as we can get to them

 

i can help you with the first two:

 

 

INSERT INTO countries VALUES (38, 'Canada', 'CA', 'CAN', 1);

 

 

 

INSERT INTO zones VALUES (66, 38, 'AB', 'Alberta');

INSERT INTO zones VALUES (67, 38, 'BC', 'British Columbia');

INSERT INTO zones VALUES (68, 38, 'MB', 'Manitoba');

INSERT INTO zones VALUES (69, 38, 'NF', 'Newfoundland');

INSERT INTO zones VALUES (70, 38, 'NB', 'New Brunswick');

INSERT INTO zones VALUES (71, 38, 'NS', 'Nova Scotia');

INSERT INTO zones VALUES (72, 38, 'NT', 'Northwest Territories');

INSERT INTO zones VALUES (73, 38, 'NU', 'Nunavut');

INSERT INTO zones VALUES (74, 38, 'ON', 'Ontario');

INSERT INTO zones VALUES (75, 38, 'PE', 'Prince Edward Island');

INSERT INTO zones VALUES (76, 38, 'QC', 'Quebec');

INSERT INTO zones VALUES (77, 38, 'SK', 'Saskatchewan');

INSERT INTO zones VALUES (78, 38, 'YT', 'Yukon Territory');

 

:)