Backup your database before running this ...
You can run this in either the Tools ... Install SQL Patches ... or in phpMyAdmin ...
Code:
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');
Bookmarks