Forum

Thread tagged as: Problem, Shop

Incorrect Shipping Zone

I have 4 zones. Default zone is Zone 4. Zone 0 is Hungary only (shops location). Zone 1 has the Czech Rep. (my real location and address) and several others.

Currently, I have both my billing and shipping address set to the Czech Rep. However, Zone 0 is always selected. Even if I change countries, it always shows Zone 0 and not Zone 1.

I have checked the countries listings and shipping zones over and over ... I even looked at the database. The CZ is country 58 and all the shipping stuff says no.58 is zone 1 ... and even though zone 0 only has country 99 (Hungary), it still selects Zone 0.

currently, I'm using all the default templates and forms ... I am really scratching my head on this one ...

Perch: 3.0.10
Production mode: Production (100)
Installed apps: content (3.0.10), assets (3.0.10), categories (3.0.10), perch_forms (1.9.1), perch_shop_orders (1.2.5), perch_shop_products (1.2.5), perch_shop (1.2.5), perch_members (1.6.2)
DB driver: PDO
DB tables: perch3_categories (4), perch3_category_counts (0), perch3_category_sets (1), perch3_content_index (52), perch3_content_items (19), perch3_content_regions (6), perch3_forms (1), perch3_forms_responses (0), perch3_members (2), perch3_members_forms (1), perch3_members_member_tags (0), perch3_members_sessions (1), perch3_members_tags (0), perch3_menu_items (13), perch3_navigation (0), perch3_navigation_pages (0), perch3_page_templates (1), perch3_pages (6), perch3_resource_log (1783), perch3_resource_tags (0), perch3_resources (1491), perch3_resources_to_tags (0), perch3_settings (31), perch3_shop_addresses (168), perch3_shop_admin_index (128), perch3_shop_brands (1), perch3_shop_cart (52), perch3_shop_cart_data (67), perch3_shop_cart_items (37), perch3_shop_countries (50), perch3_shop_currencies (152), perch3_shop_customers (9), perch3_shop_emails (1), perch3_shop_index (12947), perch3_shop_option_values (107), perch3_shop_options (1), perch3_shop_order_items (178), perch3_shop_order_promotions (0), perch3_shop_order_statuses (9), perch3_shop_orders (89), perch3_shop_orders_meta (1), perch3_shop_product_files (0), perch3_shop_product_option_values (121), perch3_shop_product_options (86), perch3_shop_product_tags (0), perch3_shop_products (224), perch3_shop_promotions (1), perch3_shop_sales (0), perch3_shop_search (203), perch3_shop_shipping_zone_countries (66), perch3_shop_shipping_zones (4), perch3_shop_shippings (4), perch3_shop_tax_exhibits (176), perch3_shop_tax_group_rates (56), perch3_shop_tax_groups (2), perch3_shop_tax_locations (28), perch3_shop_tax_rates (40), perch3_shop_variants (135), perch3_user_passwords (0), perch3_user_privileges (72), perch3_user_role_privileges (2), perch3_user_roles (2), perch3_users (2)
Users: 2
App runtimes:
<?php
    $apps_list = [
        'content',
        'categories',
        'perch_members',
        'perch_shop',
        'perch_forms',
    ];
Editor plug-ins:
H1: 8f4d668e1c91ebaf59bc1287cd7dc318
L1: 97d1f766ac7b08a09f98dff79590a26b
F1: 3b606135b33e6a102526838f4152a807
headerColour: #04ffb6
content_singlePageEdit: 1
helpURL:
siteURL: /
hideBranding: 1
content_collapseList: 1
lang: en-gb
installedAt: 3.0.8
update_3.0.8: done
latest_version:
on_sale_version: 3.0.10
perch_shop_update: 1.2.5
headerScheme: light
perch_members_login_page: /accounts/login.php
perch_shop_price_tax_mode: inc
perch_shop_product_url: /product/{slug}
perch_shop_default_currency: 59
perch_shop_reporting_currency: 59
dashboard: 1
hide_pwd_reset: 0
keyboardShortcuts: 0
content_hideNonEditableRegions: 0
content_frontend_edit: 0
content_skip_region_list: 1
logoPath: /perch/resources/logo-2.png
perch_members_update: 1.4
update_3.0.9: done
assets_restrict_buckets: 0
perch_shop_site_url: https://www.becalistyle.com
update_3.0.10: done
perch_shop_invoice_number_format: Invoice-%d
PERCH_DEVELOPMENT: 10
PERCH_STAGING: 50
PERCH_PRODUCTION: 100
PERCH_DB_SERVER: localhost
PERCH_DB_USERNAME: stuntdawg
PERCH_DB_DATABASE: becalistyle
PERCH_DB_PREFIX: perch3_
PERCH_TZ: UTC
PERCH_EMAIL_FROM: blake.myers@xenoplexus.com
PERCH_EMAIL_FROM_NAME: BeCali Orders
PERCH_LOGINPATH: /perch
PERCH_PATH: /Users/bmyers/Sites/becalistyle/perch
PERCH_CORE: /Users/bmyers/Sites/becalistyle/perch/core
PERCH_RESFILEPATH: /Users/bmyers/Sites/becalistyle/perch/resources
PERCH_RESPATH: /perch/resources
PERCH_HTML5: 1
PERCH_DEBUG: 1
PERCH_EMAIL_METHOD: smtp
PERCH_EMAIL_HOST: smtp.postmarkapp.com
PERCH_EMAIL_AUTH: 1
PERCH_EMAIL_PORT: 587
PERCH_EMAIL_USERNAME: xxxxxxxxxxxxxxxxxxxxxx
PERCH_TEMPLATE_FILTERS: 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_ASSET_VERSION: 23f8a1427c17ade109a3
PERCH_PREVIEW_ARG: preview
PERCH_TEMPLATE_PATH: /Users/bmyers/Sites/becalistyle/perch/templates
PERCH_DEFAULT_DOC: index.php
PERCH_DEFAULT_EXT: .php
PERCH_PRODUCTION_MODE: 100
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_CUSTOM_EDITOR_CONFIGS:
PERCH_ENABLE_EXIF: 1
PERCH_AUTH_PLUGIN:
PERCH_DB_CHARSET: utf8
PERCH_DB_PORT:
PERCH_DB_SOCKET:
PERCH_SHOP_VERSION: 1.2.5
PERCH_APPS_EDITOR_PLUGIN: markitup
PERCH_APPS_EDITOR_MARKUP_LANGUAGE: markdown
Hosting settings

PHP: 7.1.8
Zend: 3.1.0
OS: Darwin
SAPI: apache2handler
Safe mode: not detected
MySQL client: mysqlnd 5.0.12-dev - 20150407 - $Id: b396954eeb2d1d9ed7902b8bae237b287f21ad9e $
MySQL server: 5.6.31
Free disk space: 771.00 GB
Extensions: Core, date, libxml, openssl, pcre, sqlite3, zlib, bcmath, bz2, calendar, ctype, curl, dba, dom, hash, fileinfo, filter, ftp, gd, gettext, SPL, iconv, json, ldap, mbstring, session, standard, odbc, mysqlnd, PDO, pdo_mysql, PDO_ODBC, pdo_sqlite, Phar, posix, Reflection, mysqli, shmop, SimpleXML, soap, sockets, exif, sysvmsg, sysvsem, sysvshm, tokenizer, wddx, xml, xmlreader, xmlrpc, xmlwriter, xsl, zip, apache2handler, geoip, imagick, mcrypt
GD: Yes
ImageMagick: Yes
PHP max upload size: 128M
PHP max form post size: 128M
PHP memory limit: 128M
Total max uploadable file size: 128M
Resource folder writeable: Yes
Session timeout: 24 minutes
Native JSON: Yes
Filter functions: Yes
Transliteration functions: No
HTTP_HOST: becalistyle.local
HTTP_ACCEPT_ENCODING: br, gzip, deflate
HTTP_COOKIE: PHPSESSID=1n9p5akkccuovujptu1sdb81te; p_m=ece8463a6bb3a6537e94af624af83eabfa7802cb; cmsa=1
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_13) AppleWebKit/604.1.38 (KHTML, like Gecko) Version/11.0 Safari/604.1.38
HTTP_ACCEPT_LANGUAGE: en-us
HTTP_REFERER: https://becalistyle.local/perch/core/settings/diagnostics/
HTTP_DNT: 1
HTTP_X_FORWARDED_PROTO: https
HTTP_X_FORWARDED_PORT: 443
HTTP_X_FORWARDED_FOR: 127.0.0.1
HTTP_X_FORWARDED_HOST: becalistyle.local
HTTP_X_FORWARDED_SERVER: becalistyle.local
HTTP_CONNECTION: Keep-Alive
PATH: /usr/bin:/bin:/usr/sbin:/sbin
SERVER_SIGNATURE: <address>Apache Server at becalistyle.local Port 443</address>
SERVER_SOFTWARE: Apache
SERVER_NAME: becalistyle.local
SERVER_ADDR: 127.0.0.1
SERVER_PORT: 443
REMOTE_ADDR: 127.0.0.1
DOCUMENT_ROOT: /Users/bmyers/Sites/becalistyle
REQUEST_SCHEME: https
CONTEXT_DOCUMENT_ROOT: /Users/bmyers/Sites/becalistyle
SERVER_ADMIN: admin@example.com
SCRIPT_FILENAME: /Users/bmyers/Sites/becalistyle/perch/core/settings/diagnostics/index.php
REMOTE_PORT: 59254
GATEWAY_INTERFACE: CGI/1.1
SERVER_PROTOCOL: HTTP/1.1
REQUEST_METHOD: GET
QUERY_STRING: extended
REQUEST_URI: /perch/core/settings/diagnostics/?extended
SCRIPT_NAME: /perch/core/settings/diagnostics/index.php
PHP_SELF: /perch/core/settings/diagnostics/index.php
REQUEST_TIME_FLOAT: 1507656870.518
REQUEST_TIME: 1507656870
Debug Message - Perch 3.0.10
[1] SELECT * FROM perch3_members_sessions WHERE sessionID='a7e17ef33107e2e3357ff21a6f6d51458e8f2716' AND sessionHttpFootprint='1e5c8adc7811abc667632b38899990ad78c0ea2c' AND sessionExpires>'2017-10-10 19:41:22' LIMIT 1
User is logged in
[1] SELECT * FROM perch3_pages WHERE pagePath='/hta.php' LIMIT 1
[1] SELECT * FROM perch3_shop_cart WHERE cartID=129
[1] SELECT * FROM perch3_shop_cart WHERE cartID=129
[0] SELECT setID FROM perch3_category_sets WHERE setSlug='' LIMIT 1
[4] SELECT main.* FROM perch3_categories main WHERE 1=1 ORDER BY catTreePosition ASC
[4] Using template: /templates/categories/menu-mobile.html
[0] SELECT setID FROM perch3_category_sets WHERE setSlug='' LIMIT 1
[4] SELECT main.* FROM perch3_categories main WHERE 1=1 ORDER BY catTreePosition ASC
[4] Using template: /templates/categories/menu-navbar.html
Using cart from cache.
[1] SELECT * FROM perch3_shop_products WHERE productID=218 AND productDeleted IS NULL LIMIT 1
[1] SELECT productID, productVariantDesc, stock_level FROM perch3_shop_products WHERE parentID=218 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM perch3_shop_options o, perch3_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=218 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[59] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch3_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[1] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch3_shop_product_option_values pov, perch3_shop_options o, perch3_shop_option_values ov WHERE pov.productID='218' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[31] SELECT DISTINCT settingID, settingValue FROM perch3_settings WHERE userID=0
[1] Using template: /templates/shop/cart/cart_static.html
[1] SELECT * FROM perch3_shop_customers WHERE memberID=8
[2] SELECT main.* FROM perch3_shop_addresses main WHERE 1=1 AND (customerID=8) AND addressDeleted IS NULL AND orderID IS NULL ORDER BY addressTitle ASC
[2] Using template: /templates/shop/addresses/list.html
[1] SELECT * FROM perch3_shop_countries WHERE countryID='58' LIMIT 1
[1] SELECT * FROM perch3_shop_countries WHERE countryID='58' LIMIT 1
------------------------------ Calculating cart ------------------------------
[1] SELECT * FROM perch3_shop_cart WHERE cartID=129
[1] SELECT * FROM perch3_shop_cart WHERE cartID=129
[1] SELECT * FROM perch3_shop_tax_locations WHERE locationID=7 AND locationDeleted IS NULL LIMIT 1
[1] SELECT locationID FROM perch3_shop_tax_locations WHERE locationIsHome=1 LIMIT 1
[1] SELECT * FROM perch3_shop_tax_locations WHERE locationID=1 AND locationDeleted IS NULL LIMIT 1
[1] SELECT * FROM perch3_shop_customers WHERE memberID=8
[1] SELECT * FROM perch3_shop_currencies WHERE currencyID=59 LIMIT 1
[1] SELECT COUNT(productID) AS product_count, SUM(itemQty) AS item_count FROM perch3_shop_cart_items WHERE cartID=129
Tax mode: inc
[1] SELECT * FROM perch3_shop_cart_items WHERE cartID=129 ORDER BY itemID ASC
[1] SELECT * FROM perch3_shop_products WHERE productID=219 AND productDeleted IS NULL LIMIT 1
[1] SELECT * FROM perch3_shop_products WHERE productID=218 AND productDeleted IS NULL LIMIT 1
[1] SELECT productID, productVariantDesc, stock_level FROM perch3_shop_products WHERE parentID=218 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM perch3_shop_options o, perch3_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=218 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[59] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch3_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[1] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch3_shop_product_option_values pov, perch3_shop_options o, perch3_shop_option_values ov WHERE pov.productID='218' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[1] SELECT * FROM perch3_shop_products WHERE productID=218 AND productDeleted IS NULL LIMIT 1
[1] SELECT * FROM perch3_shop_tax_groups WHERE groupID=2 AND groupDeleted IS NULL LIMIT 1
[1] SELECT r.rateValue FROM perch3_shop_tax_group_rates gr, perch3_shop_tax_rates r WHERE gr.rateID=r.rateID AND gr.groupID=2 AND gr.locationID=1
[1] SELECT * FROM perch3_shop_tax_groups WHERE groupID=2 AND groupDeleted IS NULL LIMIT 1
[1] SELECT r.rateValue FROM perch3_shop_tax_group_rates gr, perch3_shop_tax_rates r WHERE gr.rateID=r.rateID AND gr.groupID=2 AND gr.locationID=1
[1] SELECT * FROM perch3_shop_products WHERE productID=218 AND productDeleted IS NULL LIMIT 1
[1] SELECT * FROM perch3_shop_products WHERE productID=218 AND productDeleted IS NULL LIMIT 1
[1] SELECT productID, productVariantDesc, stock_level FROM perch3_shop_products WHERE parentID=218 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM perch3_shop_options o, perch3_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=218 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[59] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch3_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[1] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch3_shop_product_option_values pov, perch3_shop_options o, perch3_shop_option_values ov WHERE pov.productID='218' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[1] SELECT * FROM perch3_shop_products WHERE productID=218 AND productDeleted IS NULL LIMIT 1
[1] SELECT productID, productVariantDesc, stock_level FROM perch3_shop_products WHERE parentID=218 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM perch3_shop_options o, perch3_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=218 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[59] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch3_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[1] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch3_shop_product_option_values pov, perch3_shop_options o, perch3_shop_option_values ov WHERE pov.productID='218' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[1] SELECT * FROM perch3_shop_products WHERE productID=218 AND productDeleted IS NULL LIMIT 1
[1] SELECT productID, productVariantDesc, stock_level FROM perch3_shop_products WHERE parentID=218 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM perch3_shop_options o, perch3_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=218 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[59] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch3_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[1] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch3_shop_product_option_values pov, perch3_shop_options o, perch3_shop_option_values ov WHERE pov.productID='218' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[1] SELECT * FROM perch3_shop_products WHERE productID=218 AND productDeleted IS NULL LIMIT 1
[1] SELECT productID, productVariantDesc, stock_level FROM perch3_shop_products WHERE parentID=218 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM perch3_shop_options o, perch3_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=218 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[59] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch3_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[1] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch3_shop_product_option_values pov, perch3_shop_options o, perch3_shop_option_values ov WHERE pov.productID='218' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[1] SELECT * FROM perch3_shop_products WHERE productID=218 AND productDeleted IS NULL LIMIT 1
[1] SELECT productID, productVariantDesc, stock_level FROM perch3_shop_products WHERE parentID=218 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM perch3_shop_options o, perch3_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=218 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[59] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch3_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[1] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM perch3_shop_product_option_values pov, perch3_shop_options o, perch3_shop_option_values ov WHERE pov.productID='218' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[1] SELECT billingAddress, shippingAddress FROM perch3_shop_cart WHERE billingAddress IS NOT NULL AND cartID=129
[1] SELECT z.* FROM perch3_shop_shipping_zones z LEFT JOIN perch3_shop_shipping_zone_countries c ON z.zoneID=c.zoneID WHERE z.zoneActive=1 AND z.zoneDeleted IS NULL AND (c.countryID=99 OR zoneIsDefault=1) ORDER BY zoneIsDefault ASC LIMIT 1
[2] SELECT * FROM perch3_shop_shippings WHERE shippingDeleted IS NULL ORDER BY shippingOrder ASC
[4] SELECT * FROM perch3_shop_shipping_zones WHERE zoneDeleted IS NULL AND zoneActive=1 AND zoneID IN (2, 3, 4, 5)
[34] SELECT rateID AS id, rateTitle AS title, rateValue AS rate, locationID FROM perch3_shop_tax_rates WHERE rateDeleted IS NULL ORDER BY rateValue DESC
[4] SELECT * FROM perch3_shop_shipping_zones WHERE zoneDeleted IS NULL AND zoneActive=1 AND zoneID IN (2, 3, 4, 5)
Rejecting shipping method ‘DHL Express’ because: cart weight is greater than the max
Qualifying shipping method ‘DHL Express’
[1] SELECT * FROM perch3_shop_shippings WHERE shippingID='4' AND shippingDeleted IS NULL LIMIT 1
Using shipping zone: Zone 0
[1] SELECT * FROM perch3_shop_tax_groups WHERE groupID=2 AND groupDeleted IS NULL LIMIT 1
[1] SELECT r.rateValue FROM perch3_shop_tax_group_rates gr, perch3_shop_tax_rates r WHERE gr.rateID=r.rateID AND gr.groupID=2 AND gr.locationID=1
[nil] SELECT * FROM perch3_shop_promotions WHERE promoFrom<='2017-10-10 17:41:00' AND promoTo>'2017-10-10 17:41:00' AND promoActive=1 AND promoDeleted IS NULL ORDER BY promoOrder ASC
[1] SELECT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM perch3_shop_admin_index idx JOIN perch3_shop_shippings main ON idx.itemID=main.shippingID AND idx.itemKey='shippingID' JOIN perch3_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 (4)) GROUP BY itemID, sortval ORDER BY sortval ASC
[1] Using template: /templates/shop/shippings/options.html
[4] SELECT * FROM perch3_shop_shipping_zones WHERE zoneDeleted IS NULL AND zoneActive=1 AND zoneID IN (2, 3, 4, 5)
[1] SELECT * FROM perch3_shop_currencies WHERE currencyID=59 LIMIT 1
[1] SELECT * FROM perch3_shop_shippings WHERE shippingID IN (4)
Using template: /templates/shop/shippings/method_form.html
Blake Myers

Blake Myers 0 points

  • 3 years ago

I discovered a little more info ... this test customer was created before his new shipping method ... any subsequent customer comes up correctly. Very strange.

I'm still having this problem ... any insight anyone?

Drew McLellan

Drew McLellan 2638 points
Perch Support

How are you selecting the shipping zone?

I thought shipping zones were automatically taken/determined by their shipping address.

Is that not true? Did I miss a step where they say what zone they are in?

I was trying to consolodate their checkout process as much as possible.

What I found is, first time registered customers and guest customers have no problem.

It’s only when a registered customer signs in for a second order that the issue occurs. I’m guessing their saved addresses are not being used for zones.

Drew McLellan

Drew McLellan 2638 points
Perch Support

Is the correct address being selected when they return?

yes ... that’s what baffling me ... i call the address for the to review and edit.

what’s really odd is this.

only hungary is zone 0. zone 4 (the default catch all zone) is like china and what not.

test address is set for czech (should be zone 1)

if i remove hungary from zone 0, then refresh the page, it says i’m zone 4. as soon as i add hungary back to zone 0, it puts me in zone 0 again.

ultimately, it thinks i’m in hungary even though my billing and shipping addresses are set to the czech.

found the problem, but not the solution

when a returning customer logs in after they've added an item to the cart and are proceeding to checkout, the perch3_shop_cart table is not being populated with their customerID->'#', billingAddress->'billing', shippingAddress->'shipping'

so the means PerchShop_Cart.class.php -> get_shipping_zone() is pulling the shipping zone from the $HomeTaxLocation

if I manually change the DB table of perch3_shop_cart and refresh, everything appears as it should.

so, that's the problem ... but not a solution, yet ...

Drew McLellan

Drew McLellan 2638 points
Perch Support

Are you getting any SQL errors either in the debug output or in your logs?