Adding Different Shipping Rates to Different Countries

[ricangem]

Hello, I currently ship only to the US. The shipping flat rate is $3.50 and free shipping over $100. The problem I am having is that I now want to also ship to Canada and someday ship worldwide but I have no idea how to set up a different shipping rate. I wanted to charge $25.00 flat rate to Canada and leave the US Shipping Rates as is. I made the biggest mistake of deleteing all the countries expect for US. Now I guess I need to recover the code for Canada in Countries and recover all Canada Zones. Unfortunately, I am running the store on my own and been trying MONTHS to figure this one out. If someone could please help me I would really appreciate it. Thank you in advance.

I don't know if this helps but my current version of zencart is 1.3.9b.

[Ajeh]

You can use the Zone Rate zones shipping module and set it up for:
US
99.99:3.50;10000.00:0.00

CA
10000.00:25.00

and later for the Rest of the World use:
00
(rates as needed)

The 00 means anyone not otherwise defined ...

If you need more than 3 Zones, then you would edit the file:
/includes/modules/shipping/zones.php

and set the number of Zones to how many you need ...

[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);