Forum

Thread tagged as: Problem, Shop

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.

David Henderson

David Henderson 0 points

  • 4 years ago
Drew McLellan

Drew McLellan 2638 points
Perch Support

What's changed between it working and now?

The client has added some extra shipping methods, that's it as far as I can see

Drew McLellan

Drew McLellan 2638 points
Perch Support

When you say you "gave Northern Ireland a new ID in the DB" - have you been hacking around at the database tables rather than using the software?