Disable sales to a specific state

[Ajeh]

Then build a Zone Definition for your shipping module where you do ship to and add it to your shipping module(s) that you have installed ...

I thought you used Zone Rate zones ... shipping module ...

The Zones Table Rate for Multiple Zones works like Zones but works off of Zone Definitions which allow you to build Zone Definitions to the State level ...

[virtualomega]

Using Zones Table Rate for Multiple Zones will setup a Zone definition that I can enter states in?

[Ajeh]

That shipping module will allow you to build as many Zone Definitions as you want ...

Then install it, and you will see that you can set a seperate Table Rate based on Item Count, Price or Weight and select any of your existing Zone Definitions for it ...

So if you made a Zone Definition for:
Country: United States
Zone: Texas

That definition would work only for Texas ...

If you made a Zone Definition for:
Country: United States
Zone: Alaska

Country: United States
Zone: Hawaii

That definition would work for only Alaska and Hawaii

If you made a Zone Definition for the 48 states plus DC ... that Zone Definition would only work for the 48 States plus DC ...

If you made a Zone Definition for:
Country: United States
State: Ohio

Country: Canada
Zone: All Zones

That Zone Definition would work only for Ohio and all of Canada ...


etc. etc. etc.

[pricediscrimination]

That shipping module will allow you to build as many Zone Definitions as you want ...

Then install it, and you will see that you can set a seperate Table Rate based on Item Count, Price or Weight and select any of your existing Zone Definitions for it ...

So if you made a Zone Definition for:
Country: United States
Zone: Texas

That definition would work only for Texas ...

If you made a Zone Definition for:
Country: United States
Zone: Alaska

Country: United States
Zone: Hawaii

That definition would work for only Alaska and Hawaii

If you made a Zone Definition for the 48 states plus DC ... that Zone Definition would only work for the 48 States plus DC ...

If you made a Zone Definition for:
Country: United States
State: Ohio

Country: Canada
Zone: All Zones

That Zone Definition would work only for Ohio and all of Canada ...


etc. etc. etc.

Bringing up an old thread for a relevant question: if only blocking state in the entire world (ie: CA) then it seems crazy to have to go to Zone Definitions and insert every single country>all zones and then United States>all zones except CA. I started it, but it's going to take forever to add all those zones! Isn't there a way to simply block one zone and allow all the others??

[Ajeh]

Create a Zone with:

INSERT INTO `geo_zones` (`geo_zone_id`, `geo_zone_name`, `geo_zone_description`, `last_modified`, `date_added`)  VALUES  (37, 'The World except California', 'The world except California', NULL, '2008-02-01 12:12:12');  
INSERT INTO `zones_to_geo_zones` (`zone_country_id`, `zone_id`, `geo_zone_id`)  VALUES (223, 1, 37), (223, 2, 37), (223, 4, 37), (223, 5, 37), (223, 12, 37), (223, 13, 37), (223, 14, 37), (223, 15, 37), (223, 16, 37), (223, 18, 37), (223, 19, 37), (223, 21, 37), (223, 22, 37), (223, 23, 37), (223, 24, 37), (223, 25, 37), (223, 26, 37), (223, 27, 37), (223, 28, 37), (223, 29, 37), (223, 31, 37), (223, 32, 37), (223, 33, 37), (223, 34, 37), (223, 35, 37), (223, 36, 37), (223, 37, 37), (223, 38, 37), (223, 39, 37), (223, 40, 37), (223, 41, 37), (223, 42, 37), (223, 43, 37), (223, 44, 37), (223, 45, 37), (223, 47, 37), (223, 48, 37), (223, 49, 37), (223, 51, 37), (223, 53, 37), (223, 54, 37), (223, 55, 37), (223, 56, 37), (223, 57, 37), (223, 58, 37), (223, 59, 37), (223, 61, 37), (223, 62, 37), (223, 63, 37), (223, 64, 37), (223, 65, 37);

Then use this:

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

Next, delete California ...

Now add the US Territories ...

I think that will build everything except California in the Zone ...

NOTE: I have not tested this but it should work ...

If not, we can try again tomorrow ...

[pricediscrimination]

Create a Zone with:

INSERT INTO `geo_zones` (`geo_zone_id`, `geo_zone_name`, `geo_zone_description`, `last_modified`, `date_added`)  VALUES  (37, 'The World except California', 'The world except California', NULL, '2008-02-01 12:12:12');  
INSERT INTO `zones_to_geo_zones` (`zone_country_id`, `zone_id`, `geo_zone_id`)  VALUES (223, 1, 37), (223, 2, 37), (223, 4, 37), (223, 5, 37), (223, 12, 37), (223, 13, 37), (223, 14, 37), (223, 15, 37), (223, 16, 37), (223, 18, 37), (223, 19, 37), (223, 21, 37), (223, 22, 37), (223, 23, 37), (223, 24, 37), (223, 25, 37), (223, 26, 37), (223, 27, 37), (223, 28, 37), (223, 29, 37), (223, 31, 37), (223, 32, 37), (223, 33, 37), (223, 34, 37), (223, 35, 37), (223, 36, 37), (223, 37, 37), (223, 38, 37), (223, 39, 37), (223, 40, 37), (223, 41, 37), (223, 42, 37), (223, 43, 37), (223, 44, 37), (223, 45, 37), (223, 47, 37), (223, 48, 37), (223, 49, 37), (223, 51, 37), (223, 53, 37), (223, 54, 37), (223, 55, 37), (223, 56, 37), (223, 57, 37), (223, 58, 37), (223, 59, 37), (223, 61, 37), (223, 62, 37), (223, 63, 37), (223, 64, 37), (223, 65, 37);

Then use this:

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

Next, delete California ...

Now add the US Territories ...

I think that will build everything except California in the Zone ...

NOTE: I have not tested this but it should work ...

If not, we can try again tomorrow ...

That is awesome! I will do it and report back. Thanks as usual, Ajeh.