Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2009
    Posts
    2,124
    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
    67,202
    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:
    http://tutorials.zen-cart.com/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: v1.5.3]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...

  3. #3
    Join Date
    Jan 2009
    Posts
    2,124
    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
    67,202
    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.3]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...

  5. #5
    Join Date
    Jan 2009
    Posts
    2,124
    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. SETTING FLAT RATE SHIPPING one local rate, one international
    By clif in forum Built-in Shipping and Payment Modules
    Replies: 2
    Last Post: 22 Jun 2011, 05:15 AM
  2. Question about flat rate shipping and international orders
    By teqmedia in forum Built-in Shipping and Payment Modules
    Replies: 8
    Last Post: 24 Sep 2009, 08:34 PM
  3. 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
  4. 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
  5. Flat rate shipping-one rate euro, one rate international
    By schwimwastaken in forum Built-in Shipping and Payment Modules
    Replies: 4
    Last Post: 11 Oct 2006, 04:59 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
  •