standard, priority, and express shipping, for several zones! how?

I look around and found where to set the rates. Ok everything is green so fow to I now list an item and add the different shipping prices. I thought that there would be extra boxes in the part where you list your item am I missing something

Here is a handy one for making a Zone Definition for everyone but the US and Canada ...

Backup your database before using it:

How to build a Zone for the Rest of the World NOT USA or CANADA

INSERT INTO geo_zones (geo_zone_id, geo_zone_name, geo_zone_description, last_modified, date_added)
VALUES (22, 'International', 'All Countries Except USA and Canada', NULL, CURDATE());

INSERT INTO zones_to_geo_zones (zone_country_id, zone_id, geo_zone_id, date_added)
SELECT countries_id , 0, 22, CURDATE()
FROM countries
WHERE countries_iso_code_3 NOT IN ('USA','CAN');

Do I insert this code sql patches

let me tell you what I have done I have set up the zone definitions for US, Canada and Rest Of The World.
I have also set the tax rate and put each tax rate at 0.00. Now when I go to the admin-module shipping at both perweightunit i have orange dots. I have set sort orders and they are both orange dots but if i do not set sort order they are green.

Zone Definitions for Shipping Modules do not need the Tax Rate ...

When you add a Zone to a shipping module, you will see the yellow icon rather than the green icon ...

When you test your shipping, you will only see the 1 Shipping Module that matches your shipping address ...

Be sure that after you made the Zone Definition names ... that you also made the Details for them ...

If you add 1 Sort Order, add unique Sort Order to ALL modules ...

Sort Orders have no relation to the green/yellow/red dots ...

Yeaaaahhhh:clap: I finally got it Well I did as you said and everything is working well. I thought that a box would apper in the product listing to input the canda cost and the Intl cost.

I set the percentage in the shpping clone module, so when I select canada the correct price comes up for shipping. In my case I only want to ship to UK,Australia,Canada,Germany,europe and carribean.

I saw the sql code you sent but that was for everywhere else excluding US and Canada. Is there a way I could ajust that code to suit the place I want to ship International.

Againa thanks for the patience and the help