Printable View
We've just swapped over from Royal Mail modules to Flat Rate Shipping modules. We're 99.9% there but just one little niggle with the "Flat Rate International Shipping" module. We have the zone set to "none" in the drop down so that it's pretty much enabled for the entire world. The only trouble then is that it's showing up even for our UK customers.
Question then, how do we exclude the UK from the "Flat Rate International Shipping" module?
Build a Zone that excludes the UK ... peek in the FAQs for the Zones, such as:
https://www.zen-cart.com/tutorials/i...hp?article=409
When I try to create a zone includes the whole worlkd but excludes the UK, I get this error message:
1062 Duplicate entry '35' for key 'PRIMARY'
in:
[INSERT INTO geo_zones (geo_zone_id, geo_zone_name, geo_zone_description, last_modified, date_added) VALUES (35, 'International', 'All Countries Except United Kingdom', NULL, CURDATE());]
Here is the SQL patch I tried to use:
INSERT INTO geo_zones (geo_zone_id, geo_zone_name, geo_zone_description, last_modified, date_added)
VALUES
(35, 'International', 'All Countries Except United Kingdom', NULL, CURDATE());
INSERT INTO zones_to_geo_zones (zone_country_id, zone_id, geo_zone_id, date_added)
SELECT countries_id , 0, 35, CURDATE()
FROM countries
WHERE countries_iso_code_3 NOT IN ('GBR');
Sounds like you have a Zone definition already using 35, change those to a value that you are not using ...
Hi Linda.
Thank you! Seems to have worked a treat. Just need to run a few tests and make sure it's not excluding anyone but it's working as far as I can see. Just use 935 instead of 35