Forum

Thread tagged as: Problem, Shop

Shipping Weight is Ignored

I have shipping weights entered for all products and their variants. I have all weights entered into shipping.

YET, it refuses to select the DHL shipping and wants to default to the local pick up.

Under debug, I see this:

Qualifying shipping method ‘DHL Express’
Rejecting shipping method ‘DHL Express’ because: cart weight is less than min shipping weight
Qualifying shipping method ‘Local Pickup’

yet, in the cart on the same page when I do <perch:showall> I see a shipping weight of 280

weight is set from 1 to 2499 ... so I don't see why it's reject the shipping method. Full debug report below along with diagnostic report

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: custom_wishlist (3), perch3_categories (6), perch3_category_counts (0), perch3_category_sets (1), perch3_content_index (172), perch3_content_items (49), perch3_content_regions (9), perch3_forms (1), perch3_forms_responses (88), perch3_members (21), perch3_members_forms (1), perch3_members_member_tags (0), perch3_members_sessions (3), perch3_members_tags (0), perch3_menu_items (13), perch3_navigation (0), perch3_navigation_pages (0), perch3_page_templates (1), perch3_pages (9), perch3_resource_log (1897), perch3_resource_tags (0), perch3_resources (1560), perch3_resources_to_tags (0), perch3_settings (31), perch3_shop_addresses (62), perch3_shop_admin_index (192), perch3_shop_brands (1), perch3_shop_cart (47132), perch3_shop_cart_data (91), perch3_shop_cart_items (34), perch3_shop_countries (54), perch3_shop_currencies (152), perch3_shop_customers (24), perch3_shop_emails (2), perch3_shop_index (14899), perch3_shop_option_values (122), perch3_shop_options (2), perch3_shop_order_items (8), perch3_shop_order_promotions (2), perch3_shop_order_statuses (9), perch3_shop_orders (4), perch3_shop_orders_meta (1), perch3_shop_product_files (0), perch3_shop_product_option_values (140), perch3_shop_product_options (92), perch3_shop_product_tags (0), perch3_shop_products (253), perch3_shop_promotions (6), perch3_shop_sales (0), perch3_shop_search (228), perch3_shop_shipping_zone_countries (52), perch3_shop_shipping_zones (5), perch3_shop_shippings (6), perch3_shop_tax_exhibits (242), perch3_shop_tax_group_rates (56), perch3_shop_tax_groups (2), perch3_shop_tax_locations (28), perch3_shop_tax_rates (77), perch3_shop_variants (158), perch3_user_passwords (2), 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: 04aff14aa716b0f3d1e384a8ece8474b
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.1.3
perch_shop_update: 1.2.5
headerScheme: light
perch_members_login_page: /accounts/login.php
perch_shop_price_tax_mode: exc
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: Europe/Budapest
PERCH_EMAIL_FROM: info@becalistyle.com
PERCH_EMAIL_FROM_NAME: BeCalifornia KFT.
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: 9d6d3a02-a7fa-4887-854c-e653194ce57f
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.20
Zend: 3.1.0
OS: Darwin
SAPI: apache2handler
Safe mode: not detected
MySQL client: mysqlnd 5.0.12-dev - 20150407 - $Id: 38fea24f2847fa7519001be390c98ae0acafe387 $
MySQL server: 5.7.23
Free disk space: 724.60 GB
Extensions: Core, date, 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, PDO, pdo_mysql, pdo_sqlite, Phar, posix, Reflection, mysqli, SimpleXML, soap, sockets, exif, tokenizer, wddx, xml, xmlreader, xmlrpc, xmlwriter, xsl, zip, apache2handler, imap, gettext, mcrypt, pgsql, pdo_pgsql, imagick
GD: Yes
ImageMagick: Yes
PHP max upload size: 256M
PHP max form post size: 256M
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: Yes
HTTP_HOST: www.becalistyle.local
HTTP_ACCEPT_ENCODING: gzip, deflate
HTTP_COOKIE: PHPSESSID=8268dd71295ba242ab0fded44078c61a; cmsa=1
HTTP_CONNECTION: keep-alive
HTTP_UPGRADE_INSECURE_REQUESTS: 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_14) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/12.0 Safari/605.1.15
HTTP_REFERER: https://www.becalistyle.local/perch/core/settings/diagnostics/
HTTP_DNT: 1
HTTP_ACCEPT_LANGUAGE: en-us
PATH: /usr/bin:/bin:/usr/sbin:/sbin
SERVER_SOFTWARE: Apache
SERVER_NAME: www.becalistyle.local
SERVER_ADDR: ::1
SERVER_PORT: 80
REMOTE_ADDR: ::1
DOCUMENT_ROOT: /Users/bmyers/Sites/becalistyle
SERVER_ADMIN: you@example.com
SCRIPT_FILENAME: /Users/bmyers/Sites/becalistyle/perch/core/settings/diagnostics/index.php
REMOTE_PORT: 59658
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: 1542382763.17
REQUEST_TIME: 1542382763
argc: 1

and the debug

Debug Message - Perch 3.0.10
[1] SELECT * FROM perch3_members_sessions WHERE sessionID='3bde5617cf4deef517615d57e2c7abe89356836c' AND sessionHttpFootprint='9720039d493fecbd052177bfc2cdfc59928c0baa' AND sessionExpires>'2018-11-16 16:28:41' 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=47806
[1] SELECT * FROM perch3_shop_cart WHERE cartID=47806
[31] SELECT DISTINCT settingID, settingValue FROM perch3_settings WHERE userID=0
UPDATE perch3_shop_cart SET shippingID='6' WHERE cartID='47806'
------------------------------ Calculating cart ------------------------------
[1] SELECT * FROM perch3_shop_cart WHERE cartID=47806
[1] SELECT * FROM perch3_shop_cart WHERE cartID=47806
[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=23
[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=47806
Tax mode: exc
[1] SELECT * FROM perch3_shop_cart_items WHERE cartID=47806 ORDER BY itemID ASC
[1] SELECT * FROM perch3_shop_products WHERE productID=237 AND productDeleted IS NULL LIMIT 1
[1] SELECT * FROM perch3_shop_products WHERE productID=233 AND productDeleted IS NULL LIMIT 1
[3] SELECT productID, productVariantDesc, stock_level FROM perch3_shop_products WHERE parentID=233 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=233 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[14] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch3_shop_option_values WHERE optionID=2 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[3] 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='233' 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 perch3_shop_products WHERE productID=233 AND productDeleted IS NULL LIMIT 1
[1] SELECT * FROM perch3_shop_tax_groups WHERE groupID=1 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=1 AND gr.locationID=1
[1] SELECT * FROM perch3_shop_tax_groups WHERE groupID=1 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=1 AND gr.locationID=1
[1] SELECT * FROM perch3_shop_products WHERE productID=233 AND productDeleted IS NULL LIMIT 1
[1] SELECT * FROM perch3_shop_products WHERE productID=233 AND productDeleted IS NULL LIMIT 1
[3] SELECT productID, productVariantDesc, stock_level FROM perch3_shop_products WHERE parentID=233 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=233 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[14] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch3_shop_option_values WHERE optionID=2 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[3] 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='233' 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 perch3_shop_products WHERE productID=233 AND productDeleted IS NULL LIMIT 1
[3] SELECT productID, productVariantDesc, stock_level FROM perch3_shop_products WHERE parentID=233 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=233 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[14] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch3_shop_option_values WHERE optionID=2 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[3] 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='233' 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 perch3_shop_products WHERE productID=233 AND productDeleted IS NULL LIMIT 1
[3] SELECT productID, productVariantDesc, stock_level FROM perch3_shop_products WHERE parentID=233 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=233 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[14] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch3_shop_option_values WHERE optionID=2 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[3] 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='233' 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 perch3_shop_products WHERE productID=233 AND productDeleted IS NULL LIMIT 1
[3] SELECT productID, productVariantDesc, stock_level FROM perch3_shop_products WHERE parentID=233 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=233 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[14] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch3_shop_option_values WHERE optionID=2 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[3] 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='233' 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 perch3_shop_products WHERE productID=233 AND productDeleted IS NULL LIMIT 1
[3] SELECT productID, productVariantDesc, stock_level FROM perch3_shop_products WHERE parentID=233 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=233 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[14] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch3_shop_option_values WHERE optionID=2 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[3] 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='233' 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 perch3_shop_cart WHERE billingAddress IS NOT NULL AND cartID=47806
[1] SELECT * FROM perch3_shop_addresses WHERE customerID='24' AND orderID IS NULL AND countryID>0 AND addressSlug='shipping'
[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
[4] SELECT * FROM perch3_shop_shippings WHERE shippingDeleted IS NULL ORDER BY shippingOrder ASC
[5] SELECT * FROM perch3_shop_shipping_zones WHERE zoneDeleted IS NULL AND zoneActive=1 AND zoneID IN (2, 3, 4, 6, 5)
[61] SELECT rateID AS id, rateTitle AS title, rateValue AS rate, locationID FROM perch3_shop_tax_rates WHERE rateDeleted IS NULL ORDER BY rateValue DESC
[5] SELECT * FROM perch3_shop_shipping_zones WHERE zoneDeleted IS NULL AND zoneActive=1 AND zoneID IN (2, 3, 4, 6, 5)
[5] SELECT * FROM perch3_shop_shipping_zones WHERE zoneDeleted IS NULL AND zoneActive=1 AND zoneID IN (2, 3, 4, 6, 5)
[1] SELECT * FROM perch3_shop_shipping_zones WHERE zoneDeleted IS NULL AND zoneActive=1 AND zoneID IN (2)
Qualifying shipping method ‘DHL Express’
Rejecting shipping method ‘DHL Express’ because: cart weight is less than min shipping weight
Qualifying shipping method ‘Local Pickup’
[1] SELECT * FROM perch3_shop_shippings WHERE shippingID='6' 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=7
[2] SELECT * FROM perch3_shop_promotions WHERE promoFrom<='2018-11-16 15:28:00' AND promoTo>'2018-11-16 15:28:00' AND promoActive=1 AND promoDeleted IS NULL ORDER BY promoOrder ASC
Promo (Influencer - Atilla Kozla - athos10) skipped: discount code not applied.
Promo (Free Shipping) qualifies!
This is a free shipping promo
UPDATE perch3_shop_cart SET cartTotalItems='2', cartTotalProducts='1', cartTotalWithTax='13970', cartTotalWithoutTax='11000' WHERE cartID='47806'
[0] SELECT setID FROM perch3_category_sets WHERE setSlug='' LIMIT 1
[6] SELECT main.* FROM perch3_categories main WHERE 1=1 ORDER BY catTreePosition ASC
[6] Using template: /templates/categories/menu-mobile.html
[0] SELECT setID FROM perch3_category_sets WHERE setSlug='' LIMIT 1
[6] SELECT main.* FROM perch3_categories main WHERE 1=1 ORDER BY catTreePosition ASC
[6] Using template: /templates/categories/menu-navbar.html
Using cart from cache.
[1] SELECT * FROM perch3_shop_products WHERE productID=233 AND productDeleted IS NULL LIMIT 1
[3] SELECT productID, productVariantDesc, stock_level FROM perch3_shop_products WHERE parentID=233 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=233 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[14] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch3_shop_option_values WHERE optionID=2 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[3] 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='233' 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: /templates/shop/cart/cart_static.html
[1] SELECT * FROM perch3_shop_customers WHERE memberID=23
[1] SELECT SQL_CALC_FOUND_ROWS DISTINCT main.* FROM perch3_shop_addresses main WHERE 1=1 AND (addressSlug='shipping') AND addressDeleted IS NULL AND orderID IS NULL ORDER BY addressID DESC LIMIT 0, 1
[24] SELECT FOUND_ROWS() AS `count`
[1] Using template: /templates/shop/addresses/list.html
[1] SELECT * FROM perch3_shop_countries WHERE countryID='99' LIMIT 1
Using cart from cache.
[1] SELECT * FROM perch3_shop_products WHERE productID=233 AND productDeleted IS NULL LIMIT 1
[3] SELECT productID, productVariantDesc, stock_level FROM perch3_shop_products WHERE parentID=233 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=233 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[14] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM perch3_shop_option_values WHERE optionID=2 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[3] 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='233' 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
[2] 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 (3, 6)) GROUP BY itemID, sortval ORDER BY sortval ASC
Using template: /templates/shop/shippings/options.html
[5] SELECT * FROM perch3_shop_shipping_zones WHERE zoneDeleted IS NULL AND zoneActive=1 AND zoneID IN (2, 3, 4, 6, 5)
[1] SELECT * FROM perch3_shop_shipping_zones WHERE zoneDeleted IS NULL AND zoneActive=1 AND zoneID IN (2)
[2] 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 (3, 6)) GROUP BY itemID, sortval ORDER BY sortval ASC
[2] Using template: /templates/shop/shippings/alist_options.html
[5] SELECT * FROM perch3_shop_shipping_zones WHERE zoneDeleted IS NULL AND zoneActive=1 AND zoneID IN (2, 3, 4, 6, 5)
[1] SELECT * FROM perch3_shop_currencies WHERE currencyID=59 LIMIT 1
[1] SELECT * FROM perch3_shop_shipping_zones WHERE zoneDeleted IS NULL AND zoneActive=1 AND zoneID IN (2)
[1] SELECT cartProperties FROM perch3_shop_cart WHERE cartID=47806
Using template: /templates/shop/checkout/confirm.html
Blake Myers

Blake Myers 0 points

  • 2 years ago
Drew McLellan

Drew McLellan 2638 points
Perch Support

Have you tried changing the order the shippings are evaluated in?

Drew McLellan said:

Have you tried changing the order the shippings are evaluated in?

I'm not sure what you mean by this.

If you mean Priority, the DHL is set to 1 and Local Pick up to 2