Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2009
    Posts
    2,123
    Plugin Contributions
    0

    Default 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?

  2. #2
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default 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/i...hp?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: v1.5.5]
    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!

  3. #3
    Join Date
    Jan 2009
    Posts
    2,123
    Plugin Contributions
    0

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

  4. #4
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default 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: v1.5.5]
    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!

  5. #5
    Join Date
    Jan 2009
    Posts
    2,123
    Plugin Contributions
    0

    Default 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

 

 

Similar Threads

  1. v154 Free US shipping, Flat Rate International over $50, $5.00 Shipping under $50
    By Rick5150 in forum Built-in Shipping and Payment Modules
    Replies: 5
    Last Post: 27 Feb 2015, 04:24 PM
  2. Flat Rate / Over $250.00 FREE shipping exclude certain items
    By WebSiteGuru in forum Built-in Shipping and Payment Modules
    Replies: 5
    Last Post: 31 Dec 2008, 04:44 AM
  3. Flat rate in US but flat rate + $1 for ea additional item - International?
    By bakdoor in forum Built-in Shipping and Payment Modules
    Replies: 8
    Last Post: 19 Oct 2008, 12:07 AM
  4. Flat Rate International Shipping Based on Order Amount
    By kabbink in forum Built-in Shipping and Payment Modules
    Replies: 4
    Last Post: 15 Apr 2008, 09:45 PM
  5. flat rate shipping, exclude countries
    By b18cya in forum Built-in Shipping and Payment Modules
    Replies: 4
    Last Post: 17 Apr 2007, 04:08 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR