Problem with Perch Shop

Hi, I've a site with Perch Shop which is playing up, it's not picking up the correct shipping method for the country I've selected.

Here's the diagnostics...

Perch: 2.8.34
Production mode: Production (100)
Installed apps: content (2.8.34), assets (2.8.34), categories (2.8.34), perch_forms (1.8.3), perch_shop_orders (1.0.9), perch_shop_products (1.0.9), perch_shop (1.0.9), perch_members (1.5)
DB driver: PDO
DB tables: perch2_categories (3), perch2_category_counts (0), perch2_category_sets (1), perch2_content_index (37006), perch2_content_items (1855), perch2_content_regions (324), perch2_forms (2), perch2_forms_responses (0), perch2_members (100), perch2_members_forms (1), perch2_members_member_tags (28), perch2_members_sessions (4), perch2_members_tags (3), perch2_navigation (2), perch2_navigation_pages (5), perch2_page_templates (6), perch2_pages (85), perch2_resource_log (19239), perch2_resource_tags (1), perch2_resources (5025), perch2_resources_to_tags (8), perch2_settings (30), perch2_shop_addresses (146), perch2_shop_admin_index (426), perch2_shop_brands (1), perch2_shop_cart (57797), perch2_shop_cart_data (213), perch2_shop_cart_items (101), perch2_shop_countries (251), perch2_shop_currencies (152), perch2_shop_customers (40), perch2_shop_emails (2), perch2_shop_index (3813), perch2_shop_option_values (27), perch2_shop_options (4), perch2_shop_order_items (74), perch2_shop_order_promotions (0), perch2_shop_order_statuses (9), perch2_shop_orders (34), perch2_shop_orders_meta (1), perch2_shop_product_files (0), perch2_shop_product_option_values (40), perch2_shop_product_options (20), perch2_shop_product_tags (0), perch2_shop_products (52), perch2_shop_promotions (0), perch2_shop_search (49), perch2_shop_shipping_zone_countries (191), perch2_shop_shipping_zones (15), perch2_shop_shippings (14), perch2_shop_tax_exhibits (64), perch2_shop_tax_group_rates (1), perch2_shop_tax_groups (1), perch2_shop_tax_locations (1), perch2_shop_tax_rates (1), perch2_shop_variants (61), perch2_user_passwords (0), perch2_user_privileges (71), perch2_user_role_privileges (58), perch2_user_roles (2), perch2_users (3)
Users: 3
PHPMailer: 5.2.21
App runtimes:
<?php
    $apps_list = array(
        'content', 
        'categories',
        'perch_members',
        'perch_shop',
        'perch_forms',
    );
Editor plug-ins: ckeditor, markitup
H1: 4f4bbc4462a2452bd8f6555432240af7
L1: 4213fc09b9f1d216b16600e41659f8fe
F1: 6a33f95eca3667f9e0c39bf5ca2980fe
headerColour: #ffffff
content_singlePageEdit: 1
helpURL:
siteURL: /
hideBranding: 1
content_collapseList: 1
lang: en-gb
update_2.8.19: done
latest_version: 2.8.15
on_sale_version:
headerScheme: light
hide_pwd_reset: 1
perch_shop_paypal_email: andantepercussion@gmail.com
perch_shop_product_url: /store/product.php?s={productSlug}
dashboard: 0
content_hideNonEditableRegions: 0
content_frontend_edit: 0
perch_shop_display_oos: 0
logoPath: /admin/resources/1450671576_admin-logo.png
update_2.8.32: done
perch_shop_update: 1.0.9
perch_members_login_page: /members/login.php?r={returnURL}
perch_shop_price_tax_mode: inc
perch_shop_default_currency: 47
perch_shop_reporting_currency: 47
perch_shop_invoice_number_format: Invoice%d
perch_members_update: 1.4
perch_shop_site_url: https://www.prelaunch.andantedrums.co.uk/store
update_2.8.34: done
PERCH_DEVELOPMENT: 10
PERCH_STAGING: 50
PERCH_PRODUCTION: 100
PERCH_DB_USERNAME: andanteperchuser
PERCH_DB_SERVER: mysql.andantedrums.co.uk
PERCH_DB_DATABASE: andante_new_db
PERCH_DB_PREFIX: perch2_
PERCH_TZ: UTC
PERCH_EMAIL_FROM: david@davidhendersondesign.com
PERCH_EMAIL_FROM_NAME: David Henderson
PERCH_LOGINPATH: /admin
PERCH_PATH: /home/andantedr/andantedrums.co.uk/admin
PERCH_CORE: /home/andantedr/andantedrums.co.uk/admin/core
PERCH_RESFILEPATH: /home/andantedr/andantedrums.co.uk/admin/resources
PERCH_RESPATH: /admin/resources
PERCH_YOUTUBE_API_KEY: AIzaSyDJpHMOAyKr0pmQxUfKiPhLBCEKiaKmS64
PERCH_HTML5: 1
PERCH_DEBUG: 1
PERCH_RUNWAY:
PERCH_ERROR_MODE: DIE
PERCH_DATE_LONG: %d %B %Y
PERCH_DATE_SHORT: %d %b %Y
PERCH_TIME_SHORT: %H:%M
PERCH_TIME_LONG: %H:%M:%S
PERCH_RUNWAY_ROUTED:
PERCH_STRONG_PASSWORDS:
PERCH_PREVIEW_ARG: preview
PERCH_TEMPLATE_PATH: /home/andantedr/andantedrums.co.uk/admin/templates
PERCH_DEFAULT_DOC: index.php
PERCH_DEFAULT_EXT: .php
PERCH_PRODUCTION_MODE: 100
PERCH_RWD:
PERCH_HTML_ENTITIES:
PERCH_SSL:
PERCH_STRIPSLASHES:
PERCH_PROGRESSIVE_FLUSH: 1
PERCH_PARANOID:
PERCH_FORCE_SECURE_COOKIES:
PERCH_PASSWORD_MIN_LENGTH: 6
PERCH_MAX_FAILED_LOGINS: 10
PERCH_AUTH_LOCKOUT_DURATION: 1 HOUR
PERCH_VERIFY_UPLOADS:
PERCH_AUTH_PLUGIN:
PERCH_DB_CHARSET: utf8
PERCH_DB_PORT:
PERCH_DB_SOCKET:
PERCH_SESSION_TIMEOUT_MINS: 20
PERCH_SHOP_VERSION: 1.0.9
PERCH_APPS_EDITOR_PLUGIN: markitup
PERCH_APPS_EDITOR_MARKUP_LANGUAGE: textile
HOSTING SETTINGS

PHP: 5.6.31
Zend: 2.6.0
OS: Linux
SAPI: cgi-fcgi
Safe mode: not detected
MySQL client: mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $
MySQL server: 5.6.34-log
Free disk space: 1.32 TB
Extensions: Core, date, ereg, libxml, pcre, sqlite3, filter, mbstring, SPL, PDO, Reflection, pdo_sqlite, hash, session, cgi-fcgi, bcmath, bz2, calendar, ctype, curl, dom, standard, ftp, gd, gettext, exif, iconv, imap, json, mcrypt, mysqlnd, mysqli, openssl, pcntl, pdo_mysql, posix, pspell, mysql, SimpleXML, soap, sockets, tokenizer, xml, xmlreader, xmlrpc, xmlwriter, xsl, zip, zlib, imagick, fileinfo, mhash, Zend OPcache
GD: Yes
ImageMagick: Yes
PHP max upload size: 64M
PHP max form post size: 65M
PHP memory limit: 90M
Total max uploadable file size: 64M
Resource folder writeable: Yes
Session timeout: 24 minutes
Native JSON: Yes
Filter functions: Yes
Transliteration functions: No
PATH: /bin:/usr/bin:/sbin:/usr/sbin
RAILS_ENV: production
SCRIPT_NAME: /admin/core/settings/diagnostics/index.php
REQUEST_URI: /admin/core/settings/diagnostics/?extended
QUERY_STRING: extended
REQUEST_METHOD: GET
SERVER_PROTOCOL: HTTP/1.1
GATEWAY_INTERFACE: CGI/1.1
REMOTE_PORT: 55165
SCRIPT_FILENAME: /home/andantedr/andantedrums.co.uk/admin/core/settings/diagnostics/index.php
SERVER_ADMIN: webmaster@andantedrums.co.uk
DOCUMENT_ROOT: /home/andantedr/andantedrums.co.uk
REMOTE_ADDR: 81.136.73.89
SERVER_PORT: 443
SERVER_ADDR: 173.236.226.14
SERVER_NAME: www.andantedrums.co.uk
SERVER_SOFTWARE: Apache
HTTP_COOKIE: p_m=118822fbc364b7d914a59fa04385cdf21e48d7fa; cmsa=1; _ga=GA1.3.1454935332.1504006136; _gid=GA1.3.474568267.1504864057; PHPSESSID=C7NHvR6Cy%2C8EvyfjIJsyv1
HTTP_ACCEPT_LANGUAGE: en-US,en;q=0.8
HTTP_ACCEPT_ENCODING: gzip, deflate, br
HTTP_REFERER: https://www.andantedrums.co.uk/admin/core/settings/diagnostics/
HTTP_ACCEPT: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8
HTTP_USER_AGENT: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/60.0.3112.113 Safari/537.36
HTTP_UPGRADE_INSECURE_REQUESTS: 1
HTTP_CONNECTION: close
HTTP_HOST: www.andantedrums.co.uk
SSL_TLS_SNI: www.andantedrums.co.uk
HTTPS: on
DH_USER: andantedr
dsid: 33767467
SCRIPT_URI: https://www.andantedrums.co.uk/admin/core/settings/diagnostics/
SCRIPT_URL: /admin/core/settings/diagnostics/
UNIQUE_ID: WbJzz63s4JgAABfuIfUAAAAL
FCGI_ROLE: RESPONDER
PHP_SELF: /admin/core/settings/diagnostics/index.php
REQUEST_TIME_FLOAT: 1504867279.0054
REQUEST_TIME: 1504867279

Here's the debug report from the checkout page....

SELECT * FROM perch2_members_sessions WHERE sessionID='118822fbc364b7d914a59fa04385cdf21e48d7fa' AND sessionHttpFootprint='74373d11086eea203396976a30b8b069716aa53f' AND sessionExpires>'2017-09-08 10:37:24' LIMIT 1
User is logged in
[1] SELECT * FROM perch2_pages WHERE pagePath='/store/checkout.php' LIMIT 1
[1] SELECT * FROM perch2_shop_cart WHERE cartID=57826
[1] SELECT * FROM perch2_shop_cart WHERE cartID=57826
[29] SELECT DISTINCT settingID, settingValue FROM perch2_settings WHERE userID=0
[1] SELECT * FROM perch2_shop_products WHERE productID=52 AND productDeleted IS NULL LIMIT 1
UPDATE perch2_shop_cart_items SET itemQty=1 WHERE cartID='57826' AND productID=52
------------------------------ Calculating cart ------------------------------
[1] SELECT * FROM perch2_shop_cart WHERE cartID=57826
[1] SELECT * FROM perch2_shop_cart WHERE cartID=57826
[1] SELECT * FROM perch2_shop_tax_locations WHERE locationID=2 AND locationDeleted IS NULL LIMIT 1
[1] SELECT locationID FROM perch2_shop_tax_locations WHERE locationIsHome=1 LIMIT 1
[1] SELECT * FROM perch2_shop_tax_locations WHERE locationID=2 AND locationDeleted IS NULL LIMIT 1
[1] SELECT * FROM perch2_shop_customers WHERE memberID=119
[1] SELECT * FROM perch2_shop_currencies WHERE currencyID=47 LIMIT 1
[1] SELECT COUNT(productID) AS product_count, SUM(itemQty) AS item_count FROM perch2_shop_cart_items WHERE cartID=57826
Tax mode: inc
[1] SELECT * FROM perch2_shop_cart_items WHERE cartID=57826 ORDER BY itemID ASC
[1] SELECT * FROM perch2_shop_products WHERE productID=52 AND productDeleted IS NULL LIMIT 1
[1] SELECT * FROM perch2_shop_products WHERE productID=18 AND productDeleted IS NULL LIMIT 1
[1] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=18 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=18 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[14] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=2 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[1] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='18' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='2' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[1] SELECT * FROM perch2_shop_products WHERE productID=18 AND productDeleted IS NULL LIMIT 1
[1] SELECT * FROM perch2_shop_tax_groups WHERE groupID=1 AND groupDeleted IS NULL LIMIT 1
[1] SELECT r.rateValue FROM perch2_shop_tax_group_rates gr, perch2_shop_tax_rates r WHERE gr.rateID=r.rateID AND gr.groupID=1 AND gr.locationID=2
[1] SELECT * FROM perch2_shop_products WHERE productID=18 AND productDeleted IS NULL LIMIT 1
[1] SELECT * FROM perch2_shop_products WHERE productID=18 AND productDeleted IS NULL LIMIT 1
[1] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=18 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=18 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[14] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=2 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[1] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='18' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='2' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[1] SELECT * FROM perch2_shop_products WHERE productID=18 AND productDeleted IS NULL LIMIT 1
[1] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=18 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=18 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[14] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=2 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[1] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='18' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='2' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[1] SELECT * FROM perch2_shop_products WHERE productID=18 AND productDeleted IS NULL LIMIT 1
[1] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=18 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=18 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[14] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=2 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[1] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='18' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='2' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[1] SELECT * FROM perch2_shop_products WHERE productID=18 AND productDeleted IS NULL LIMIT 1
[1] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=18 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=18 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[14] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=2 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[1] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='18' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='2' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[1] SELECT * FROM perch2_shop_products WHERE productID=18 AND productDeleted IS NULL LIMIT 1
[1] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=18 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=18 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[14] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=2 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[1] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='18' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='2' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[1] SELECT billingAddress, shippingAddress FROM perch2_shop_cart WHERE billingAddress IS NOT NULL AND cartID=57826
[1] SELECT z.* FROM perch2_shop_shipping_zones z LEFT JOIN perch2_shop_shipping_zone_countries c ON z.zoneID=c.zoneID WHERE z.zoneActive=1 AND z.zoneDeleted IS NULL AND (c.countryID=236 OR zoneIsDefault=1) ORDER BY zoneIsDefault ASC LIMIT 1
[11] SELECT * FROM perch2_shop_shippings WHERE shippingDeleted IS NULL ORDER BY shippingOrder ASC
[12] SELECT * FROM perch2_shop_shipping_zones WHERE zoneDeleted IS NULL AND zoneActive=1 AND zoneID IN (3, 4, 1, 7, 8, 14, 15, 12, 13, 11, 10, 9)
[1] SELECT rateID AS id, rateTitle AS title, rateValue AS rate, locationID FROM perch2_shop_tax_rates WHERE rateDeleted IS NULL ORDER BY rateValue DESC
[nil] SELECT rateID AS id, rateTitle AS title, rateValue AS rate FROM perch2_shop_tax_rates WHERE locationID=1 AND rateDeleted IS NULL ORDER BY rateValue DESC
[1] SELECT rateID AS id, rateTitle AS title, rateValue AS rate, locationID FROM perch2_shop_tax_rates WHERE rateDeleted IS NULL ORDER BY rateValue DESC
[nil] SELECT rateID AS id, rateTitle AS title, rateValue AS rate FROM perch2_shop_tax_rates WHERE locationID=3 AND rateDeleted IS NULL ORDER BY rateValue DESC
[1] SELECT rateID AS id, rateTitle AS title, rateValue AS rate, locationID FROM perch2_shop_tax_rates WHERE rateDeleted IS NULL ORDER BY rateValue DESC
[nil] SELECT rateID AS id, rateTitle AS title, rateValue AS rate FROM perch2_shop_tax_rates WHERE locationID=4 AND rateDeleted IS NULL ORDER BY rateValue DESC
[1] SELECT rateID AS id, rateTitle AS title, rateValue AS rate, locationID FROM perch2_shop_tax_rates WHERE rateDeleted IS NULL ORDER BY rateValue DESC
[nil] SELECT rateID AS id, rateTitle AS title, rateValue AS rate FROM perch2_shop_tax_rates WHERE locationID=7 AND rateDeleted IS NULL ORDER BY rateValue DESC
[1] SELECT rateID AS id, rateTitle AS title, rateValue AS rate, locationID FROM perch2_shop_tax_rates WHERE rateDeleted IS NULL ORDER BY rateValue DESC
[nil] SELECT rateID AS id, rateTitle AS title, rateValue AS rate FROM perch2_shop_tax_rates WHERE locationID=8 AND rateDeleted IS NULL ORDER BY rateValue DESC
[1] SELECT rateID AS id, rateTitle AS title, rateValue AS rate, locationID FROM perch2_shop_tax_rates WHERE rateDeleted IS NULL ORDER BY rateValue DESC
[nil] SELECT rateID AS id, rateTitle AS title, rateValue AS rate FROM perch2_shop_tax_rates WHERE locationID=9 AND rateDeleted IS NULL ORDER BY rateValue DESC
[1] SELECT rateID AS id, rateTitle AS title, rateValue AS rate, locationID FROM perch2_shop_tax_rates WHERE rateDeleted IS NULL ORDER BY rateValue DESC
[nil] SELECT rateID AS id, rateTitle AS title, rateValue AS rate FROM perch2_shop_tax_rates WHERE locationID=10 AND rateDeleted IS NULL ORDER BY rateValue DESC
[1] SELECT rateID AS id, rateTitle AS title, rateValue AS rate, locationID FROM perch2_shop_tax_rates WHERE rateDeleted IS NULL ORDER BY rateValue DESC
[nil] SELECT rateID AS id, rateTitle AS title, rateValue AS rate FROM perch2_shop_tax_rates WHERE locationID=11 AND rateDeleted IS NULL ORDER BY rateValue DESC
[1] SELECT rateID AS id, rateTitle AS title, rateValue AS rate, locationID FROM perch2_shop_tax_rates WHERE rateDeleted IS NULL ORDER BY rateValue DESC
[nil] SELECT rateID AS id, rateTitle AS title, rateValue AS rate FROM perch2_shop_tax_rates WHERE locationID=12 AND rateDeleted IS NULL ORDER BY rateValue DESC
[1] SELECT rateID AS id, rateTitle AS title, rateValue AS rate, locationID FROM perch2_shop_tax_rates WHERE rateDeleted IS NULL ORDER BY rateValue DESC
[nil] SELECT rateID AS id, rateTitle AS title, rateValue AS rate FROM perch2_shop_tax_rates WHERE locationID=13 AND rateDeleted IS NULL ORDER BY rateValue DESC
[1] SELECT rateID AS id, rateTitle AS title, rateValue AS rate, locationID FROM perch2_shop_tax_rates WHERE rateDeleted IS NULL ORDER BY rateValue DESC
[nil] SELECT rateID AS id, rateTitle AS title, rateValue AS rate FROM perch2_shop_tax_rates WHERE locationID=14 AND rateDeleted IS NULL ORDER BY rateValue DESC
[1] SELECT rateID AS id, rateTitle AS title, rateValue AS rate, locationID FROM perch2_shop_tax_rates WHERE rateDeleted IS NULL ORDER BY rateValue DESC
[nil] SELECT rateID AS id, rateTitle AS title, rateValue AS rate FROM perch2_shop_tax_rates WHERE locationID=15 AND rateDeleted IS NULL ORDER BY rateValue DESC
[2] SELECT * FROM perch2_shop_shipping_zones WHERE zoneDeleted IS NULL AND zoneActive=1 AND zoneID IN (12, 19)
[1] SELECT rateID AS id, rateTitle AS title, rateValue AS rate, locationID FROM perch2_shop_tax_rates WHERE rateDeleted IS NULL ORDER BY rateValue DESC
[nil] SELECT rateID AS id, rateTitle AS title, rateValue AS rate FROM perch2_shop_tax_rates WHERE locationID=12 AND rateDeleted IS NULL ORDER BY rateValue DESC
[1] SELECT rateID AS id, rateTitle AS title, rateValue AS rate, locationID FROM perch2_shop_tax_rates WHERE rateDeleted IS NULL ORDER BY rateValue DESC
[nil] SELECT rateID AS id, rateTitle AS title, rateValue AS rate FROM perch2_shop_tax_rates WHERE locationID=19 AND rateDeleted IS NULL ORDER BY rateValue DESC
[1] SELECT * FROM perch2_shop_shipping_zones WHERE zoneDeleted IS NULL AND zoneActive=1 AND zoneID IN (18)
[1] SELECT rateID AS id, rateTitle AS title, rateValue AS rate, locationID FROM perch2_shop_tax_rates WHERE rateDeleted IS NULL ORDER BY rateValue DESC
[nil] SELECT rateID AS id, rateTitle AS title, rateValue AS rate FROM perch2_shop_tax_rates WHERE locationID=18 AND rateDeleted IS NULL ORDER BY rateValue DESC
[1] SELECT * FROM perch2_shop_shipping_zones WHERE zoneDeleted IS NULL AND zoneActive=1 AND zoneID IN (6)
[1] SELECT rateID AS id, rateTitle AS title, rateValue AS rate, locationID FROM perch2_shop_tax_rates WHERE rateDeleted IS NULL ORDER BY rateValue DESC
[nil] SELECT rateID AS id, rateTitle AS title, rateValue AS rate FROM perch2_shop_tax_rates WHERE locationID=6 AND rateDeleted IS NULL ORDER BY rateValue DESC
[1] SELECT * FROM perch2_shop_shipping_zones WHERE zoneDeleted IS NULL AND zoneActive=1 AND zoneID IN (19)
[1] SELECT rateID AS id, rateTitle AS title, rateValue AS rate, locationID FROM perch2_shop_tax_rates WHERE rateDeleted IS NULL ORDER BY rateValue DESC
[nil] SELECT rateID AS id, rateTitle AS title, rateValue AS rate FROM perch2_shop_tax_rates WHERE locationID=19 AND rateDeleted IS NULL ORDER BY rateValue DESC
[1] SELECT * FROM perch2_shop_shipping_zones WHERE zoneDeleted IS NULL AND zoneActive=1 AND zoneID IN (18)
[1] SELECT rateID AS id, rateTitle AS title, rateValue AS rate, locationID FROM perch2_shop_tax_rates WHERE rateDeleted IS NULL ORDER BY rateValue DESC
[nil] SELECT rateID AS id, rateTitle AS title, rateValue AS rate FROM perch2_shop_tax_rates WHERE locationID=18 AND rateDeleted IS NULL ORDER BY rateValue DESC
[1] SELECT * FROM perch2_shop_shipping_zones WHERE zoneDeleted IS NULL AND zoneActive=1 AND zoneID IN (6)
[1] SELECT rateID AS id, rateTitle AS title, rateValue AS rate, locationID FROM perch2_shop_tax_rates WHERE rateDeleted IS NULL ORDER BY rateValue DESC
[nil] SELECT rateID AS id, rateTitle AS title, rateValue AS rate FROM perch2_shop_tax_rates WHERE locationID=6 AND rateDeleted IS NULL ORDER BY rateValue DESC
[12] SELECT * FROM perch2_shop_shipping_zones WHERE zoneDeleted IS NULL AND zoneActive=1 AND zoneID IN (3, 4, 1, 7, 8, 14, 15, 12, 13, 11, 10, 9)
[1] SELECT rateID AS id, rateTitle AS title, rateValue AS rate, locationID FROM perch2_shop_tax_rates WHERE rateDeleted IS NULL ORDER BY rateValue DESC
[nil] SELECT rateID AS id, rateTitle AS title, rateValue AS rate FROM perch2_shop_tax_rates WHERE locationID=1 AND rateDeleted IS NULL ORDER BY rateValue DESC
[1] SELECT rateID AS id, rateTitle AS title, rateValue AS rate, locationID FROM perch2_shop_tax_rates WHERE rateDeleted IS NULL ORDER BY rateValue DESC
[nil] SELECT rateID AS id, rateTitle AS title, rateValue AS rate FROM perch2_shop_tax_rates WHERE locationID=3 AND rateDeleted IS NULL ORDER BY rateValue DESC
[1] SELECT rateID AS id, rateTitle AS title, rateValue AS rate, locationID FROM perch2_shop_tax_rates WHERE rateDeleted IS NULL ORDER BY rateValue DESC
[nil] SELECT rateID AS id, rateTitle AS title, rateValue AS rate FROM perch2_shop_tax_rates WHERE locationID=4 AND rateDeleted IS NULL ORDER BY rateValue DESC
[1] SELECT rateID AS id, rateTitle AS title, rateValue AS rate, locationID FROM perch2_shop_tax_rates WHERE rateDeleted IS NULL ORDER BY rateValue DESC
[nil] SELECT rateID AS id, rateTitle AS title, rateValue AS rate FROM perch2_shop_tax_rates WHERE locationID=7 AND rateDeleted IS NULL ORDER BY rateValue DESC
[1] SELECT rateID AS id, rateTitle AS title, rateValue AS rate, locationID FROM perch2_shop_tax_rates WHERE rateDeleted IS NULL ORDER BY rateValue DESC
[nil] SELECT rateID AS id, rateTitle AS title, rateValue AS rate FROM perch2_shop_tax_rates WHERE locationID=8 AND rateDeleted IS NULL ORDER BY rateValue DESC
[1] SELECT rateID AS id, rateTitle AS title, rateValue AS rate, locationID FROM perch2_shop_tax_rates WHERE rateDeleted IS NULL ORDER BY rateValue DESC
[nil] SELECT rateID AS id, rateTitle AS title, rateValue AS rate FROM perch2_shop_tax_rates WHERE locationID=9 AND rateDeleted IS NULL ORDER BY rateValue DESC
[1] SELECT rateID AS id, rateTitle AS title, rateValue AS rate, locationID FROM perch2_shop_tax_rates WHERE rateDeleted IS NULL ORDER BY rateValue DESC
[nil] SELECT rateID AS id, rateTitle AS title, rateValue AS rate FROM perch2_shop_tax_rates WHERE locationID=10 AND rateDeleted IS NULL ORDER BY rateValue DESC
[1] SELECT rateID AS id, rateTitle AS title, rateValue AS rate, locationID FROM perch2_shop_tax_rates WHERE rateDeleted IS NULL ORDER BY rateValue DESC
[nil] SELECT rateID AS id, rateTitle AS title, rateValue AS rate FROM perch2_shop_tax_rates WHERE locationID=11 AND rateDeleted IS NULL ORDER BY rateValue DESC
[1] SELECT rateID AS id, rateTitle AS title, rateValue AS rate, locationID FROM perch2_shop_tax_rates WHERE rateDeleted IS NULL ORDER BY rateValue DESC
[nil] SELECT rateID AS id, rateTitle AS title, rateValue AS rate FROM perch2_shop_tax_rates WHERE locationID=12 AND rateDeleted IS NULL ORDER BY rateValue DESC
[1] SELECT rateID AS id, rateTitle AS title, rateValue AS rate, locationID FROM perch2_shop_tax_rates WHERE rateDeleted IS NULL ORDER BY rateValue DESC
[nil] SELECT rateID AS id, rateTitle AS title, rateValue AS rate FROM perch2_shop_tax_rates WHERE locationID=13 AND rateDeleted IS NULL ORDER BY rateValue DESC
[1] SELECT rateID AS id, rateTitle AS title, rateValue AS rate, locationID FROM perch2_shop_tax_rates WHERE rateDeleted IS NULL ORDER BY rateValue DESC
[nil] SELECT rateID AS id, rateTitle AS title, rateValue AS rate FROM perch2_shop_tax_rates WHERE locationID=14 AND rateDeleted IS NULL ORDER BY rateValue DESC
[1] SELECT rateID AS id, rateTitle AS title, rateValue AS rate, locationID FROM perch2_shop_tax_rates WHERE rateDeleted IS NULL ORDER BY rateValue DESC
[nil] SELECT rateID AS id, rateTitle AS title, rateValue AS rate FROM perch2_shop_tax_rates WHERE locationID=15 AND rateDeleted IS NULL ORDER BY rateValue DESC
[1] SELECT * FROM perch2_shop_shipping_zones WHERE zoneDeleted IS NULL AND zoneActive=1 AND zoneID IN (18)
[1] SELECT rateID AS id, rateTitle AS title, rateValue AS rate, locationID FROM perch2_shop_tax_rates WHERE rateDeleted IS NULL ORDER BY rateValue DESC
[nil] SELECT rateID AS id, rateTitle AS title, rateValue AS rate FROM perch2_shop_tax_rates WHERE locationID=18 AND rateDeleted IS NULL ORDER BY rateValue DESC
[1] SELECT * FROM perch2_shop_shipping_zones WHERE zoneDeleted IS NULL AND zoneActive=1 AND zoneID IN (18)
[1] SELECT rateID AS id, rateTitle AS title, rateValue AS rate, locationID FROM perch2_shop_tax_rates WHERE rateDeleted IS NULL ORDER BY rateValue DESC
[nil] SELECT rateID AS id, rateTitle AS title, rateValue AS rate FROM perch2_shop_tax_rates WHERE locationID=18 AND rateDeleted IS NULL ORDER BY rateValue DESC
[1] SELECT * FROM perch2_shop_shipping_zones WHERE zoneDeleted IS NULL AND zoneActive=1 AND zoneID IN (18)
[1] SELECT rateID AS id, rateTitle AS title, rateValue AS rate, locationID FROM perch2_shop_tax_rates WHERE rateDeleted IS NULL ORDER BY rateValue DESC
[nil] SELECT rateID AS id, rateTitle AS title, rateValue AS rate FROM perch2_shop_tax_rates WHERE locationID=18 AND rateDeleted IS NULL ORDER BY rateValue DESC
Rejecting shipping method ‘International’ because: no price available for chosen shipping zone
Rejecting shipping method ‘UK Mainland Shipping’ because: cart weight is less than min shipping weight
Rejecting shipping method ‘Northern Ireland Shipping’ because: no price available for chosen shipping zone
Rejecting shipping method ‘Ireland Shipping’ because: no price available for chosen shipping zone
Rejecting shipping method ‘UK Mainland Shipping Large Item’ because: cart weight is less than min shipping weight
Rejecting shipping method ‘Northern Ireland Shipping Large Item’ because: no price available for chosen shipping zone
Rejecting shipping method ‘Ireland Shipping Large item’ because: no price available for chosen shipping zone
Rejecting shipping method ‘International Large Item’ because: no price available for chosen shipping zone
Rejecting shipping method ‘Northern Ireland (2kgs)’ because: no price available for chosen shipping zone
Rejecting shipping method ‘Northern Ireland (500g)’ because: no price available for chosen shipping zone
Rejecting shipping method ‘Northern Ireland 750g’ because: no price available for chosen shipping zone
[nil] SELECT * FROM perch2_shop_promotions WHERE promoFrom<='2017-09-08 10:37:00' AND promoTo>'2017-09-08 10:37:00' AND promoActive=1 AND promoDeleted IS NULL ORDER BY promoOrder ASC
UPDATE perch2_shop_cart SET cartTotalItems='1', cartTotalProducts='1', cartTotalWithTax='3.00', cartTotalWithoutTax='3.00' WHERE cartID='57826'
Using template: /templates/pages/attributes/default.html
Using sub-template: /templates/pages/attributes/image.html
Using sub-template: /templates/pages/attributes/seo.html
[4] SELECT regionKey, regionHTML FROM perch2_content_regions WHERE regionPage='/store/checkout.php' OR regionPage='*' ORDER BY regionPage DESC
[1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM perch2_pages WHERE pagePath='/products' OR pageSortPath='/products' LIMIT 1
[30] SELECT * FROM perch2_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-007%' AND pageDepth >=1 AND pageDepth<=3 ORDER BY pageTreePosition ASC
[1] SELECT pageTreePosition FROM perch2_pages WHERE pagePath='/store/checkout.php' LIMIT 1
[2] SELECT pageID FROM perch2_pages WHERE pageTreePosition IN ('000-006-004', '000-006', '000') ORDER BY pageTreePosition DESC
Using template: /templates/navigation/topnavitem.html
[2] Using template: /templates/navigation/topnavitem2.html
[2] Using template: /templates/navigation/topnavitem2.html
[2] Using template: /templates/navigation/topnavitem2.html
[3] Using template: /templates/navigation/topnavitem2.html
[3] Using template: /templates/navigation/topnavitem2.html
[7] Using template: /templates/navigation/topnavitem2.html
[7] Using template: /templates/navigation/topnavitem2.html
[1] SELECT * FROM perch2_shop_customers WHERE memberID=119
[2] SELECT main.* FROM perch2_shop_addresses main WHERE 1=1 AND (customerID=40) AND addressDeleted IS NULL AND orderID IS NULL ORDER BY addressTitle ASC
[2] Using template: /addons/apps/perch_shop/templates/shop/addresses/list.html
[1] SELECT * FROM perch2_shop_countries WHERE countryID='251' LIMIT 1
[1] SELECT * FROM perch2_shop_countries WHERE countryID='251' LIMIT 1
Using cart from cache.
[1] SELECT * FROM perch2_shop_products WHERE productID=18 AND productDeleted IS NULL LIMIT 1
[1] SELECT productID, productVariantDesc, stock_level FROM perch2_shop_products WHERE parentID=18 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM perch2_shop_options o, perch2_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=18 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[14] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch2_shop_option_values WHERE optionID=2 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[1] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch2_shop_product_option_values pov, perch2_shop_options o, perch2_shop_option_values ov WHERE pov.productID='18' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='2' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[1] Using template: /addons/apps/perch_shop/templates/shop/cart/checkout.html

Basically, I divided the United Kingdom into UK Mainland and Northern Ireland, and gave Northern Ireland a new ID in the DB in the countries table, everything has worked fine now for the last 8 months or so, but the customer has been modifying their shipping methods recently.

If I add a shipping zone for UK Mainland to my shipping method it picks up the shipping method at checkout, but it wont pickup my shipping method when it has the shipping zone as Northern Ireland.