Adding Different Shipping Rates to Different Countries

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. :lookaroun

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

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 ...

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 :smile:

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 ...

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? :cry:

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

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 :smile:

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

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. :smile:

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 ...

Ok let me see if I got this right:

Where it says "Zone 1 Countries" I would place: US

Where it says "Zone 1 Shipping Table" I would place:
99.99:3.50;10000.00:0.00

Then...Where it says " Zone 2 Countries" I would place: CA

Where it says "Zone 2 Shipping Table" I would place: 10000.00:25.00

Is this correct?? I am so sorry for being such a bother, I just want to make sure I am doing it correctly, thank you Ajeh :blush:

That should work ... try it and test it out ... :smile:

Sorry for the late response...I did exactly like you told me and it worked like a charm, thank you!! :D

I have a small problem that hopefully you can help me with, I would like to leave The US Shipping as is but I would like the Canadian shipping price to be $25.00 for the first item and $10.00 for the next. How can I do this? Thank you in advance and I really appreciate your help. :smile:

Create a Zone Definition for Canada ...

Install the Item Rate item shipping module and set the:
Handling: 15.00
Rate: 10.00

and set the Zone to your new Zone Definition ...

Set on the Zone Rate zones shipping module for the Skip Countries to have:
CA

and remove your definition for CA ...

I will go ahead and do that! :bigups:

Thank you for all your help, I really appreciate it! :smile:

Hello,
Thank you the above exchange. It has been very helpful. I have a question, though, that I am hoping you could help me with.
I added the US in zone one, changed it to 0.00 for shipping (I am offering a free shipping sale).
I tried to add CA and CZ to zone 2 (Canada and Czech Republic) and make it $4.50 for 1 item, etc.

CA,CZ
( 1:4.50,2:5.50, etc)

When I tried to purchase something from the Czech Address, in my

"Shopping Cart Contents" the
Zone Rates (shipping to): $0.00

"Shipping Method" the
Zone Rate is correct, $4.50

But then when it continues to Paypal, the shopping cart contents continues. Do you know why this might happen?
Thank you in advance.
john

Forgot: Zen Cart
Zen Cart 1.3.8a
Patch: 1::
Database Patch Level: 1.3.8
v1.3.8 [2010-01-26 15:42:27] (Fresh Installation)
v1.3.8 [2010-01-26 15:42:27] (Fresh Installation)
PHP Logo
PHP Version 5.2.11

As long as you are not ordering more than quantity 2 you should get the $4.50 or $5.50 rate for Canada and Czech Republic with those settings ...

If you order 3 or more items you will get $0.00 as you do not have anything defined for more than 1 or 2 items ...

You could change it to:
1:4.50, 10000:5.50

and now you will get $4.50 for quantity 1 and $5.50 for all quantities over 1 ...