Does anyone have zone All Countries Except the AU and NZ

Hi

I need All Countries Except the AU and NZ zones.

At least someone to show how to create one so I can do it my self

all this stuff ...

INSERT INTO `geo_zones` (`geo_zone_id`, `geo_zone_name`, `geo_zone_description`, `last_modified`, `date_added`) VALUES (20, 'Not US', 'All Countries Except the US', NULL, '2006-07-03 12:32:13');

INSERT INTO `zones_to_geo_zones` (`zone_country_id`, `zone_id`, `geo_zone_id`) VALUES (1, 0, 20),
(2, 0, 20),
(3, 0, 20),
(4, 0, 20),
(5, 0, 20),
(6, 0, 20),
(7, 0, 20),

Anyone at all?

Not even one ? At least show me how to edit the file so I can do it my self. Not sure which file and do not understand what those numbers means .

VALUES (1, 0, 20), what are they and what do they belong to??

and

(2, 0, 20),
(3, 0, 20),
(4, 0, 20),

Gosh why nobody told me about this before?

Here is a solution in case you might be also interested.

http://www.zen-cart.com/forum/showthread.php?t=113040

Hi All,

I am new to the setup of the shipping options....

I need set up this simple shipping rate:

1. Registered Post: Always free....
2. Express Post: for Australia: AU$8.50 / Others: AU$12.50

There are 2 different rates for express post, depending on if buyer from Australia or another country

How do I set this up I was trying but I have no clue how to do this the shipping part is really unclear.

Re: How to set up this shipping Options?
You could use the Zone Rate zones and the Free Shipping Options freeoptions for this ...

Configure the Free Shipping Options freeoptions as Totals >= 0.00

Setup the Zone Rates where Zone 1 is set for Australia by setting that to AU and set to 10000:8.50

Setup the Zone 2 for the Rest of the World by setting that to 00 and and set to 10000:12.50

Next, you can change the language files to read as you want for these shipping modules with your templates and overrides ...