Adding Different Shipping Rates to Different Countries

[ricangem]

Hi, Thank you you so much for responding! Sorry, but how can I recover the zones for Canada or would I need to recover them? I had deleted Canada in COUNTRIES and all the ZONES for Canada where deleted? Thank you

[Ajeh]

It would really depend on your current site and what you have in there vs what you removed or changed all the tables to ...

You could do a test install on a test database in a test directory to see what the defaults look like to start with ...

What you need to know is if your current site uses the same settings for the Zone tables so that you can rebuild them in the same manner or if you have changes that would require building them manually ...

Without actually seeing your current tables it is hard to guess which is better for you ...

[ricangem]

Oh no, I am confused, sorry! Ok I will just explain exactly what I did and maybe this will help: Since I only wanted to ship to the US at the moment, I went to LOCATION/TAXES/COUNTRIES and deleted all the countries manually except for the zones in the United States. When I took a look at LOCATION/TAXES/ZONES all the countries zones where gone except for United States. I guess I made the dummest mistake of deleting all the countries.

Is there a way I could just add the Canada Zones back?

[Ajeh]

Backup your database and let's try rebuilding things slowly ...

To add Canada back into the Countries table, run this in the Tools ... Install SQL patches:

INSERT INTO countries (countries_id, countries_name, countries_iso_code_2, countries_iso_code_3, address_format_id) VALUES
(38, 'Canada', 'CA', 'CAN', 2);

[ricangem]

Ok, I am gonna work on that right now and let you know what happens, hopefully it will help someone else that is in the same situation as I. Thank you

[ricangem]

Ok, I added the code and it worked like a charm!! All my Canada zones appear once again, thank you sooooo much!!!

But, I need your help once again. Where exactly would I add this on the Zone Rates?:

US
99.99:3.50;10000.00:0.00

CA
10000.00:25.00

Also, on Calculation Method, I would have to mark price correct? Sorry for asking so many questions. Thank you in advance and I really appreciate all the help.

[Ajeh]

Install the Zone Rates and when you edit it you have to fill in the information on the 2 character ISO code and the Rates you want to charge ...