If this is your first visit, check our documentation. To post, register or login.
Forums / Built-in Shipping and Payment Modules / Exclude UK from Flat Rate International Shipping module

Exclude UK from Flat Rate International Shipping module

Started by limelites on 29 Mar 2012, 9:37 AM · Views: 1,249

Results 1 to 5 of 5
29 Mar 2012, 9:37 AM
#1
limelites avatar

limelites

Totally Zenned

Join Date:
Jan 2009
Posts:
2,085
Plugin Contributions:
0

Exclude UK from Flat Rate International Shipping module

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?

29 Mar 2012, 1:04 PM
#2
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Exclude UK from 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/index.php?article=409

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

29 Mar 2012, 2:01 PM
#3
limelites avatar

limelites

Totally Zenned

Join Date:
Jan 2009
Posts:
2,085
Plugin Contributions:
0

Re: Exclude UK from Flat Rate International Shipping module

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');

29 Mar 2012, 2:38 PM
#4
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Exclude UK from Flat Rate International Shipping module

Sounds like you have a Zone definition already using 35, change those to a value that you are not using ...

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

29 Mar 2012, 3:01 PM
#5
limelites avatar

limelites

Totally Zenned

Join Date:
Jan 2009
Posts:
2,085
Plugin Contributions:
0

Re: Exclude UK from Flat Rate International Shipping module

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