Forum

Thread tagged as: Problem, Runway, Shop

Shop shipping zone not updating

When I try to edit billing and shipping addresses during checkout process (perch_shop_edit_address_form(1234)), addresses update in the database however the shipping zone doesn't change when editing the country. Shipping options remain the same. I have 2 shipping zones (UK and Ireland) with UK being set as a default. Diagnostics on my checkout page indicates Using shipping opts from cache. and Using shipping zone from cache. after trying to change the country from UK to Ireland. Everything is up-to-date.

Under what circumstances is it possible to change the shipping address country which then allows the correct zone (and consequent options) to be shown?

Thanks.

Runway 3 Diagnostics:

Perch Runway: 3.0.2
Production mode: Development (10)
Installed apps: content (3.0.2), assets (3.0.2), categories (3.0.2), perch_forms (1.9), perch_gallery (2.8.9), perch_shop_orders (1.1), perch_shop_products (1.1), chirp_seo (1), perch_shop (1.1), perch_comments (1.2.1), perch_members (1.6.1), perch_mailchimp (3.1)
DB driver: PDO
DB tables: perch2_backup_plans (0), perch2_backup_resources (0), perch2_backup_runs (0), perch2_categories (11), perch2_category_counts (0), perch2_category_sets (1), perch2_chirp_seo (1), perch2_collection_index (40), perch2_collection_items (8), perch2_collection_revisions (4), perch2_collections (0), perch2_comments (0), perch2_comments_votes (0), perch2_content_index (569), perch2_content_items (215), perch2_content_locks (0), perch2_content_regions (23), perch2_forms (2), perch2_forms_responses (2), perch2_gallery_albums (6), perch2_gallery_image_versions (714), perch2_gallery_images (119), perch2_mailchimp_campaigns (0), perch2_mailchimp_imports (0), perch2_mailchimp_lists (1), perch2_mailchimp_subscribers (69), perch2_mailchimp_subscriptions (71), perch2_mailchimp_webhooks (1), perch2_members (71), perch2_members_forms (1), perch2_members_member_tags (0), perch2_members_sessions (4), perch2_members_tags (0), perch2_menu_items (17), perch2_navigation (0), perch2_navigation_pages (0), perch2_page_routes (7), perch2_page_templates (21), perch2_pages (16), perch2_resource_log (510), perch2_resource_tags (0), perch2_resources (144), perch2_resources_to_tags (0), perch2_settings (41), perch2_shop_addresses (142), perch2_shop_admin_index (102), perch2_shop_brands (8), perch2_shop_cart (1273), perch2_shop_cart_data (190), perch2_shop_cart_items (103), perch2_shop_countries (250), perch2_shop_currencies (152), perch2_shop_customers (71), perch2_shop_emails (1), perch2_shop_index (565), perch2_shop_option_values (0), perch2_shop_options (0), perch2_shop_order_items (0), perch2_shop_order_promotions (0), perch2_shop_order_statuses (9), perch2_shop_orders (0), perch2_shop_orders_meta (1), perch2_shop_product_files (0), perch2_shop_product_option_values (0), perch2_shop_product_options (0), perch2_shop_product_tags (0), perch2_shop_products (3), perch2_shop_promotions (0), perch2_shop_search (3), perch2_shop_shipping_zone_countries (3), perch2_shop_shipping_zones (2), perch2_shop_shippings (3), perch2_shop_tax_exhibits (0), perch2_shop_tax_group_rates (1), perch2_shop_tax_groups (1), perch2_shop_tax_locations (1), perch2_shop_tax_rates (1), perch2_shop_variants (6), perch2_user_passwords (1), perch2_user_privileges (78), perch2_user_role_privileges (23), perch2_user_roles (2), perch2_users (2)
Users: 2
App runtimes:
<?php
    $apps_list = array(
        'perch_members',
        'perch_shop',
        'perch_forms',
        'perch_mailchimp',
        'perch_gallery',
        'perch_comments',
        'chirp_seo'
    );
Scheduled tasks for perch_comments: delete_spam_comments (1440 mins)
Scheduled tasks for perch_mailchimp: import_data (1 mins)
Editor plug-ins:
H1: c80ca109caff299553e99f2fd257bdba
L1: 45f1adfe02a3a4d1a863b7793c677f10
F1: 0c66c2e1f82f9e0b7617b2cb8270f2c7
headerColour: #f5aa25
content_singlePageEdit: 1
helpURL:
siteURL: /
hideBranding: 1
content_collapseList: 1
lang: en-gb
update_2.8.31: done
latest_version:
on_sale_version:
headerScheme: light
perch_gallery_bucket_mode: dynamic
perch_gallery_bucket: gallery
perch_mailchimp_api_key: 4630ebc97c5037e8c31d8d22e1bde96f-us14
perch_mailchimp_campaign_url: /404/
perch_members_login_page: /members/login.php?r={returnURL}
perch_shop_price_tax_mode: inc
perch_shop_site_url: https://crosskeys.dev
perch_shop_invoice_number_format: Invoice%d
dashboard: 0
hide_pwd_reset: 1
content_hideNonEditableRegions: 1
content_frontend_edit: 0
perch_gallery_basicUpload: 0
logoPath: /modify/resources/crosskeys-logo.svg
perch_gallery_update: 2.8.5
perch_shop_update: 1.1
perch_members_update: 1.4
perch_mailchimp_secret: deacab8
perch_comments_akismet_key:
perch_comments_max_spam_days: 0
update_runway_2.8.32: done
perch_shop_trade_price_tax_mode: exc
perch_shop_default_currency: 47
perch_shop_reporting_currency: 47
perch_shop_product_url: /shop/{slug}/{slug}/{sku}/
update_runway_3.0: done
siteOffline: 0
chirp_seo_license_key: GQVBC-OTJIK-O060F-FVEZI
update_runway_3.0.2: done
PERCH_DEVELOPMENT: 10
PERCH_STAGING: 50
PERCH_PRODUCTION: 100
PERCH_DB_USERNAME: root
PERCH_DB_SERVER: localhost
PERCH_DB_DATABASE: pixelmod_ckinn
PERCH_DB_PREFIX: perch2_
PERCH_TZ: UTC
PERCH_EMAIL_FROM: 
PERCH_EMAIL_FROM_NAME: 
PERCH_LOGINPATH: /modify
PERCH_PATH: /*redacted*//root/modify
PERCH_CORE: /*redacted*//root/modify/core
PERCH_RESFILEPATH: /*redacted*//root/modify/resources
PERCH_RESPATH: /modify/resources
PERCH_SCHEDULE_SECRET: /*redacted*/
PERCH_SITEPATH: /*redacted*//root
PERCH_HTML5: 1
PERCH_DEBUG: 1
PERCH_PRODUCTION_MODE: 10
PERCH_RUNWAY: 1
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_ASSET_VERSION: ed79f7a54b300ef2b1e6
PERCH_PREVIEW_ARG: preview
PERCH_TEMPLATE_PATH: /*redacted*//root/modify/templates
PERCH_TEMPLATE_FILTERS:
PERCH_DEFAULT_DOC: index.php
PERCH_DEFAULT_EXT: .php
PERCH_XHTML_MARKUP:
PERCH_RWD: 1
PERCH_HTML_ENTITIES:
PERCH_SSL:
PERCH_STRIPSLASHES:
PERCH_PROGRESSIVE_FLUSH: 1
PERCH_PARANOID:
PERCH_FORCE_SECURE_COOKIES:
PERCH_DEFAULT_BUCKET: default
PERCH_TRANSLATION_ASSIST:
PERCH_PASSWORD_MIN_LENGTH: 6
PERCH_MAX_FAILED_LOGINS: 10
PERCH_AUTH_LOCKOUT_DURATION: 1 HOUR
PERCH_VERIFY_UPLOADS:
PERCH_PRIV_ASSIST:
PERCH_AUTH_PLUGIN:
PERCH_DB_CHARSET: utf8
PERCH_DB_PORT:
PERCH_DB_SOCKET:
PERCH_APPS_EDITOR_PLUGIN: markitup
PERCH_APPS_EDITOR_MARKUP_LANGUAGE: markdown
PERCH_SHOP_VERSION: 1.1
Hosting settings

PHP: 5.6.30
Zend: 2.6.0
OS: Darwin
SAPI: apache2handler
Safe mode: not detected
MySQL client: mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $
MySQL server: 5.6.35
Free disk space: 12.38 GB
Extensions: Core, date, ereg, libxml, openssl, pcre, sqlite3, zlib, bcmath, bz2, calendar, ctype, curl, dom, hash, fileinfo, filter, ftp, gd, SPL, iconv, intl, json, ldap, mbstring, session, standard, mysqlnd, mysqli, PDO, pdo_mysql, pdo_sqlite, Phar, posix, Reflection, mysql, SimpleXML, soap, sockets, exif, tokenizer, wddx, xml, xmlreader, xmlwriter, xsl, zip, apache2handler, imap, gettext, mcrypt, pgsql, pdo_pgsql, igbinary, memcached, mhash
GD: Yes
ImageMagick: No
PHP max upload size: 32M
PHP max form post size: 32M
PHP memory limit: 128M
Total max uploadable file size: 32M
Resource folder writeable: Yes
Session timeout: 24 minutes
Native JSON: Yes
Filter functions: Yes
Transliteration functions: Yes
HTTPS: on
SSL_TLS_SNI: crosskeys.dev
SSL_SERVER_S_DN_C: UK
SSL_SERVER_S_DN_ST: /*redacted*/
SSL_SERVER_S_DN_L: /*redacted*/
SSL_SERVER_S_DN_O: /*redacted*/
SSL_SERVER_S_DN_CN: /*redacted*/
SSL_SERVER_S_DN_Email: /*redacted*/
SSL_SERVER_I_DN_C: UK
SSL_SERVER_I_DN_ST: /*redacted*/
SSL_SERVER_I_DN_L: /*redacted*/
SSL_SERVER_I_DN_O: /*redacted*/
SSL_SERVER_I_DN_CN: /*redacted*/
SSL_SERVER_I_DN_Email: /*redacted*/
SSL_VERSION_INTERFACE: mod_ssl/2.2.31
SSL_VERSION_LIBRARY: OpenSSL/1.0.2j
SSL_PROTOCOL: TLSv1.2
SSL_SECURE_RENEG: true
SSL_COMPRESS_METHOD: NULL
SSL_CIPHER: ECDHE-RSA-AES256-GCM-SHA384
SSL_CIPHER_EXPORT: false
SSL_CIPHER_USEKEYSIZE: 256
SSL_CIPHER_ALGKEYSIZE: 256
SSL_CLIENT_VERIFY: NONE
SSL_SERVER_M_VERSION: 1
SSL_SERVER_M_SERIAL: BC7E3396F86B8E74
SSL_SERVER_V_START: Mar 11 01:22:58 2017 GMT
SSL_SERVER_V_END: Mar 9 01:22:58 2027 GMT
SSL_SERVER_S_DN: /*redacted*/
SSL_SERVER_I_DN: /*redacted*/
SSL_SERVER_A_KEY: rsaEncryption
SSL_SERVER_A_SIG: sha1WithRSAEncryption
SSL_SESSION_ID: 63A0C4BD5FB4A6792EA131260DA29A9D409C600849A28EA16F37D8239AEE60BE
HTTP_HOST: /*redacted*/
HTTP_ACCEPT_ENCODING: gzip, deflate
HTTP_COOKIE: __utma=258655320.1604131853.1472088318.1492515424.1492643792.50; __utmz=258655320.1472088318.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none); PHPSESSID=1c695b7b2672f420059ca89360d6ba23; cmsa=1
HTTP_CONNECTION: keep-alive
HTTP_ACCEPT: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_USER_AGENT: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_4) AppleWebKit/603.1.30 (KHTML, like Gecko) Version/10.1 Safari/603.1.30
HTTP_ACCEPT_LANGUAGE: en-gb
HTTP_REFERER: https://redacted/modify/core/settings/diagnostics/
HTTP_DNT: 1
PATH: /usr/bin:/bin:/usr/sbin:/sbin
SERVER_SOFTWARE: Apache
SERVER_NAME: crosskeys.dev
SERVER_ADDR: ::1
SERVER_PORT: 443
REMOTE_ADDR: ::1
DOCUMENT_ROOT: /*redacted*/
SERVER_ADMIN: you@example.com
SCRIPT_FILENAME: /*redacted*//root/modify/core/settings/diagnostics/index.php
REMOTE_PORT: 60946
GATEWAY_INTERFACE: CGI/1.1
SERVER_PROTOCOL: HTTP/1.1
REQUEST_METHOD: GET
QUERY_STRING: extended
REQUEST_URI: /modify/core/settings/diagnostics/?extended
SCRIPT_NAME: /modify/core/settings/diagnostics/index.php
PHP_SELF: /modify/core/settings/diagnostics/index.php
REQUEST_TIME_FLOAT: 1493229044.84
REQUEST_TIME: 1493229044
argc: 1

Template being used to edit addresses: /templates/shop/addresses/edit.html

<perch:form id="address" method="post" app="perch_shop" class="edit-address">
    <fieldset>
        <div class="large-6 columns">
            <perch:label for="first_name">First name</perch:label>
            <perch:input type="text" id="first_name" required="true" label="First name" placeholder="First name *" />
            <perch:error for="first_name" type="required"><small>Please add your name</small></perch:error>
    </div>
    <div class="large-6 columns">
            <perch:label for="last_name">Last name</perch:label>
            <perch:input type="text" id="last_name" required="true" label="Last name" placeholder="Last name *" />
            <perch:error for="last_name" type="required"><small>Please add your name</small></perch:error>
    </div>
    <div class="large-12 columns">
            <perch:label for="address_1">Address 1</perch:label>
            <perch:input type="text" id="address_1" required="true" label="Address 1" placeholder="Address 1 *" />
            <perch:error for="address_1" type="required"><small>Please add the first line of your billing address</small></perch:error>

            <perch:label for="address_2">Address 2</perch:label>
            <perch:input type="text" id="address_2" label="Address 2" placeholder="Address 2" />
    </div>
    <div class="large-6 columns">
            <perch:label for="postcode">Postcode</perch:label>
            <perch:input type="text" id="postcode" label="Postcode" placeholder="Postcode" />
    </div>
    <div class="large-6 columns">
            <perch:label for="city">Town / City</perch:label>
            <perch:input type="text" id="city" required="true" label="Town / City" placeholder="Town / City *" />
            <perch:error for="city" type="required"><small>Please add the city</small></perch:error>
    </div>
    <div class="large-6 columns">
            <perch:label for="county">County / State</perch:label>
            <perch:input type="text" id="county" required="true" label="County / State" placeholder="County / State *" />
            <perch:error for="county" type="required"><small>Please add the county or region</small></perch:error>
    </div>
    <div class="large-6 columns">
            <perch:label for="country">Country</perch:label>
            <perch:input type="select" options="<perch:shop id="country_list" />" value="236" id="country" label="Country" />
    </div>
    </fieldset>    
    <div class="continue">
        <a class="button remove" href="/shop/checkout">Cancel</a> <perch:input type="submit" value="Update" class="button" />
        <perch:input type="hidden" id="addressID" />
        <perch:input type="hidden" id="r" value="/shop/addresses" />
    </div>
</perch:form>

Checkout page diagnostics:

Time    Δ   Debug Message - Perch Runway 3.0.2
0.066   0   [19] SELECT p.pagePath, pr.routePattern, pr.routeRegExp, p.pageTemplate, pr.routeOrder, s.settingValue AS siteOffline FROM perch2_pages p LEFT JOIN perch2_page_routes pr ON p.pageID=pr.pageID LEFT JOIN perch2_settings s ON s.settingID='siteOffline' UNION SELECT NULL AS pagePath, pr2.routePattern, pr2.routeRegExp, pr2.templatePath AS pageTemplate, pr2.routeOrder, NULL AS siteOffline FROM perch2_page_routes pr2 WHERE templateID!=0 ORDER BY routeOrder ASC, pagePath ASC
0.0703  0.0043  Matched page: /shop/checkout, so not using routes.
0.0704  0.0001  Using master page: /templates/pages/shop/checkout.php
0.0722  0.0017  [1] SELECT * FROM perch2_members_sessions WHERE sessionID='6c8baa0a5e0f653cd0fd3898a1f5b27815c22420' AND sessionHttpFootprint='568a433c0590f9d192764a925c09da6b3e3edb56' AND sessionExpires>'2017-04-26 16:33:18' LIMIT 1
0.0732  0.001   User is logged in
0.0779  0.0048  [1] SELECT * FROM perch2_pages WHERE pagePath='/shop/checkout' LIMIT 1
0.0862  0.0083  [1] SELECT * FROM perch2_shop_cart WHERE cartID=1387
0.0869  0.0006  [1] SELECT * FROM perch2_shop_cart WHERE cartID=1387
0.0882  0.0013  [40] SELECT DISTINCT settingID, settingValue FROM perch2_settings WHERE userID=0
0.0955  0.0073  [1] SELECT * FROM perch2_shop_customers WHERE memberID=67
0.0984  0.0028  [1] SELECT * FROM perch2_shop_addresses WHERE customerID='67' AND addressID=134
0.0998  0.0015  
Array
(
    [first_name] => First
    [last_name] => Name
    [address_1] => 123 Test road
    [address_2] => 
    [postcode] => 
    [city] => Dublin
    [county] => Dublin
    [country] => 236
    [addressID] => 134
    [r] => /shop/addresses
)
0.1001  0.0003  UPDATE perch2_shop_addresses SET addressDynamicFields='{\"first_name\":\"Test\",\"last_name\":\"Name\",\"address_1\":\"123 Test road\",\"address_2\":\"\",\"postcode\":\"\",\"country\":\"236\",\"company\":\"test\",\"city\":\"Dublin\",\"county\":\"Dublin\",\"addressID\":\"134\",\"r\":\"\\/shop\\/addresses\"}', addressFirstName='Test', addressLastName='Name', addressCompany='test', addressLine1='123 Test road', countryID='236', addressUpdated='2017-04-26 16:33:18' WHERE addressID='134'
0.102   0.0018  No ids to log.
0.1042  0.0022  Using cart from cache.
0.1052  0.001   [3] SELECT regionKey, regionHTML FROM perch2_content_regions WHERE regionPage='/shop/checkout' OR regionPage='*' ORDER BY regionPage DESC
0.1059  0.0007  [1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch2_content_regions WHERE regionKey='Site Name' AND (regionPage='/shop/checkout' OR regionPage='*')
0.1063  0.0004  [1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch2_content_index idx JOIN perch2_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch2_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=1 AND idx.itemRev=2)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
0.1095  0.0032  [1] Using template: /templates/content/shared/site_name.html
0.1118  0.0023  [1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch2_content_regions WHERE regionKey='Site Description' AND (regionPage='/shop/checkout' OR regionPage='*')
0.1124  0.0006  [1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch2_content_index idx JOIN perch2_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch2_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=2 AND idx.itemRev=3)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
0.1162  0.0038  [1] Using template: /templates/content/shared/site_desc.html
0.117   0.0007  Using cart from cache.
0.1177  0.0007  Using template: /templates/pages/attributes/default.html
0.1179  0.0002  Using sub-template: /templates/pages/attributes/_seo.html
0.119   0.0011  Using cart from cache.
0.1199  0.001   Using template: /templates/shop/cart/mini.html
0.1219  0.0019  [1] SELECT billingAddress, shippingAddress FROM perch2_shop_cart WHERE billingAddress IS NOT NULL AND cartID=1387
0.1225  0.0006  [1] SELECT * FROM perch2_shop_customers WHERE memberID=67
0.123   0.0005  [1] SELECT * FROM perch2_shop_addresses WHERE customerID='67' AND orderID IS NULL AND addressSlug='default'
0.1234  0.0004  [1] SELECT * FROM perch2_shop_addresses WHERE customerID='67' AND orderID IS NULL AND addressSlug='shipping'
0.1239  0.0005  Using template: /templates/shop/addresses/confirm.html
0.1243  0.0004  [1] SELECT * FROM perch2_shop_countries WHERE countryID='236' LIMIT 1
0.1248  0.0006  [1] SELECT * FROM perch2_shop_countries WHERE countryID='236' LIMIT 1
0.1276  0.0028  [1] SELECT * FROM perch2_shop_customers WHERE memberID=67
0.1302  0.0027  [2] SELECT main.* FROM perch2_shop_addresses main WHERE 1=1 AND (customerID=67) AND addressDeleted IS NULL AND orderID IS NULL ORDER BY addressTitle ASC
0.1313  0.0011  Using template: /templates/shop/addresses/list.html
0.1315  0.0002  [1] SELECT * FROM perch2_shop_countries WHERE countryID='236' LIMIT 1
0.132   0.0005  [1] SELECT * FROM perch2_shop_countries WHERE countryID='236' LIMIT 1
0.1326  0.0006  Using shipping opts from cache.
0.1326  0   Using shipping zone from cache.
0.1335  0.0009  [1] SELECT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM perch2_shop_admin_index idx JOIN perch2_shop_shippings main ON idx.itemID=main.shippingID AND idx.itemKey='shippingID' JOIN perch2_shop_admin_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='shippingID' AND idx2.indexKey='_id' WHERE 1=1 AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, shippingID ) as tbl WHERE (shippingID IN (2)) GROUP BY itemID, sortval ORDER BY sortval ASC
0.1415  0.008   Using template: /addons/apps/perch_shop/templates/shop/shippings/options.html
0.142   0.0005  [1] SELECT * FROM perch2_shop_shipping_zones WHERE zoneDeleted IS NULL AND zoneActive=1 AND zoneID IN (2)
0.1432  0.0013  [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
0.1436  0.0004  [nil] SELECT rateID AS id, rateTitle AS title, rateValue AS rate FROM perch2_shop_tax_rates WHERE locationID=2 AND rateDeleted IS NULL ORDER BY rateValue DESC
0.1444  0.0008  Using shipping opts from cache.
0.1445  0.0001  [1] SELECT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM perch2_shop_admin_index idx JOIN perch2_shop_shippings main ON idx.itemID=main.shippingID AND idx.itemKey='shippingID' JOIN perch2_shop_admin_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='shippingID' AND idx2.indexKey='_id' WHERE 1=1 AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, shippingID ) as tbl WHERE (shippingID IN (2)) GROUP BY itemID, sortval ORDER BY sortval ASC
0.1502  0.0057  [1] Using template: /addons/apps/perch_shop/templates/shop/shippings/options.html
0.1506  0.0003  [1] SELECT * FROM perch2_shop_shipping_zones WHERE zoneDeleted IS NULL AND zoneActive=1 AND zoneID IN (2)
0.1511  0.0006  [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
0.1515  0.0004  [1] SELECT rateID AS id, rateTitle AS title, rateValue AS rate FROM perch2_shop_tax_rates WHERE locationID=2 AND rateDeleted IS NULL ORDER BY rateValue DESC
0.1534  0.0019  [1] SELECT * FROM perch2_shop_currencies WHERE currencyID=47 LIMIT 1
0.1547  0.0013  Using cart from cache.
0.1553  0.0006  [1] Using template: /templates/shop/cart/cart_static.html
0.1587  0.0034  Using template: /templates/mailchimp/subscribe.html
0.1609  0.0022  Request time: 0.1609
0.161   0.0001  Process time: 0.1587
0.161   0   Memory: 7.0897
Chris Henry

Chris Henry 0 points

  • 4 years ago
Drew McLellan

Drew McLellan 2638 points
Perch Support

Is the scenario that you're selecting an address and then editing it to be a completely different country?

Yep, in case of user error (it's unlikely but possible). Or lets say the user changes their mind about where to deliver the product (maybe they want to send it directly to someone in a different country as a gift for example).

Drew McLellan

Drew McLellan 2638 points
Perch Support

Ok, that's fine, just wanted to be clear.

Found this, same thing: https://forum.grabaperch.com/forum/08-09-2016-shop-customer-edit-form-not-working

Will implement something else but this would be a nice addition to the password-less checkout.