Perch Shop Sale – Price added to cart is Zero

Sure, here you go:

Debug from product page

Debug Message - Perch Runway 3.0.11
[31] SELECT p.pagePath, pr.routePattern, pr.routeRegExp, p.pageTemplate, pr.routeOrder, s.settingValue AS siteOffline FROM perch3_pages p LEFT JOIN perch3_page_routes pr ON p.pageID=pr.pageID LEFT JOIN perch3_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 perch3_page_routes pr2 WHERE templateID!=0 ORDER BY routeOrder ASC, pagePath ASC
Matched route: shop/[slug:brand]/[slug:product]
Using master page: /templates/pages/shop/product.php
Page arguments:
Array
(
    [0] => /shop/tnb/karnak-tnb-002
    [brand] => tnb
    [1] => tnb
    [product] => karnak-tnb-002
    [2] => karnak-tnb-002
)
[1] SELECT * FROM perch3_pages WHERE pagePath='/shop/brand/product' LIMIT 1
[1] SELECT * FROM perch3_shop_cart WHERE cartID=10942
[1] SELECT * FROM perch3_shop_cart WHERE cartID=10942
[1] SELECT * FROM perch3_shop_sales WHERE saleFrom<='2017-11-23 09:39:00' AND saleTo>'2017-11-23 09:39:00' AND saleActive=1 AND saleDeleted IS NULL ORDER BY saleOrder ASC
UPDATE perch3_shop_cart SET cartPricing='sale' WHERE cartID='10942'
------------------------------ Calculating cart ------------------------------
[1] SELECT * FROM perch3_shop_cart WHERE cartID=10942
[1] SELECT * FROM perch3_shop_cart WHERE cartID=10942
[1] SELECT * FROM perch3_shop_tax_locations WHERE locationID=1 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_currencies WHERE currencyID=47 LIMIT 1
[1] SELECT COUNT(productID) AS product_count, SUM(itemQty) AS item_count FROM perch3_shop_cart_items WHERE cartID=10942
[44] SELECT DISTINCT settingID, settingValue FROM perch3_settings WHERE userID=0
Tax mode: inc
[nil] SELECT * FROM perch3_shop_cart_items WHERE cartID=10942 ORDER BY itemID ASC
UPDATE perch3_shop_cart SET cartTotalItems=NULL, cartTotalProducts='0', cartTotalWithTax='0.00', cartTotalWithoutTax='0.00' WHERE cartID='10942'
[4] SELECT DISTINCT idx.itemID FROM perch3_shop_index idx JOIN perch3_shop_brands main ON idx.itemID=main.brandID AND idx.itemKey='brandID' AND ((idx.indexKey='status' AND idx.indexValue='1')) GROUP BY idx.itemID HAVING COUNT(idx.itemID)=1
[1] SELECT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM perch3_shop_index idx JOIN perch3_shop_brands main ON idx.itemID=main.brandID AND idx.itemKey='brandID' JOIN perch3_shop_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='brandID' AND idx2.indexKey='_id' AND idx.itemID IN ('1', '2', '3', '4') WHERE 1=1 AND ((idx.indexKey='slug' AND idx.indexValue='tnb')) AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, brandID ) as tbl WHERE (brandDeleted IS NULL) GROUP BY itemID, sortval ORDER BY sortval ASC
Using template: /templates/shop/brands/brand.html
[1] SELECT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM perch3_shop_index idx JOIN perch3_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' JOIN perch3_shop_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='productID' AND idx2.indexKey='_id' WHERE 1=1 AND ((idx.indexKey='slug' AND idx.indexValue='karnak-tnb-002')) AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, productID ) as tbl WHERE (productDeleted IS NULL AND productStatus=1 AND parentID IS NULL) GROUP BY itemID, sortval ORDER BY sortval ASC
Using template: /templates/shop/products/product.html
[1] SELECT productID, productVariantDesc, stock_level FROM perch3_shop_products WHERE parentID=19 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=19 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[12] 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='19' 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
[5] SELECT catID, catPath FROM perch3_categories
Using template: /templates/pages/attributes/body_attributes.html
Using template: /templates/pages/attributes/seo.html
[3] SELECT regionKey, regionHTML FROM perch3_content_regions WHERE regionPage='/shop/brand/product' OR regionPage='*' ORDER BY regionPage DESC
[1] SELECT groupID FROM perch3_navigation WHERE groupSlug='main-navigation' LIMIT 1
[4] SELECT np.pageID, np.pageParentID, p.pagePath, p.pageTitle, p.pageNavText, p.pageNew, p.pageOrder, np.pageDepth, p.pageSortPath, np.pageTreePosition, p.pageAccessTags, p.pageAttributes FROM perch3_navigation_pages np, perch3_pages p WHERE p.pageID=np.pageID AND np.groupID=6 AND p.pageNew=0 ORDER BY np.pageTreePosition ASC
[0] SELECT np.pageTreePosition FROM perch3_pages p, perch3_navigation_pages np WHERE np.pageID=p.pageID AND np.groupID=6 AND p.pagePath='/shop/brand/product' LIMIT 1
[4] Using template: /templates/navigation/menu_item.html
Using template: /templates/search/search-form.html
[1] SELECT pageTreePosition FROM perch3_pages WHERE pagePath='/shop/brand/product' OR pageSortPath='/shop/brand/product' LIMIT 1
[1] SELECT * FROM perch3_pages WHERE pageHidden=0 AND pageNew=0 AND pageTreePosition IN ('000-004-001-001', '000-004-001', '000-004', '000') ORDER BY pageTreePosition
[1] Using template: /templates/navigation/breadcrumb.html
[1] SELECT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM perch3_shop_index idx JOIN perch3_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' JOIN perch3_shop_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='productID' AND idx2.indexKey='_id' WHERE 1=1 AND ((idx.indexKey='slug' AND idx.indexValue='karnak-tnb-002')) AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, productID ) as tbl WHERE (productDeleted IS NULL AND productStatus=1 AND parentID IS NULL) GROUP BY itemID, sortval ORDER BY sortval ASC
[1] SELECT * FROM perch3_shop_products WHERE parentID IN ('19') AND productDeleted IS NULL
[1] Using template: /templates/shop/products/product_detail.html
Using sub-template: /templates/shop/products/variant_detail.html
Using sub-template: /templates/shop/products/variant_detail.html
[1] SELECT productID, productVariantDesc, stock_level FROM perch3_shop_products WHERE parentID=19 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=19 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[12] 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='19' 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=19 AND productDeleted IS NULL LIMIT 1
[1] SELECT productID, productVariantDesc, stock_level FROM perch3_shop_products WHERE parentID=19 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=19 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[12] 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='19' 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_currencies WHERE currencyID=47 LIMIT 1
[1] SELECT * FROM perch3_shop_products WHERE productID=19 AND productDeleted IS NULL LIMIT 1
[1] SELECT productID, productVariantDesc, stock_level FROM perch3_shop_products WHERE parentID=19 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=19 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[12] 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
[2] 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='19' 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_categories ORDER BY catTreePosition ASC
[1] SELECT * FROM perch3_shop_brands WHERE brandID='2' AND brandDeleted IS NULL LIMIT 1
Looking up missing property slug
[1] SELECT * FROM perch3_shop_brands WHERE brandID='2' AND brandDeleted IS NULL LIMIT 1
[1] SELECT groupID FROM perch3_navigation WHERE groupSlug='secondary-navigation' LIMIT 1
[4] SELECT np.pageID, np.pageParentID, p.pagePath, p.pageTitle, p.pageNavText, p.pageNew, p.pageOrder, np.pageDepth, p.pageSortPath, np.pageTreePosition, p.pageAccessTags, p.pageAttributes FROM perch3_navigation_pages np, perch3_pages p WHERE p.pageID=np.pageID AND np.groupID=2 AND p.pageNew=0 ORDER BY np.pageTreePosition ASC
[0] SELECT np.pageTreePosition FROM perch3_pages p, perch3_navigation_pages np WHERE np.pageID=p.pageID AND np.groupID=2 AND p.pagePath='/shop/brand/product' LIMIT 1
[4] Using template: /templates/navigation/menu_item.html
[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE regionKey='ep_social' AND (regionPage LIKE '%' OR regionPage='*')
[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=9 AND idx.itemRev=7)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
[4] Using template: /templates/content//blocks/social_block.html
Request time: 0.0871
Process time: 0.086
Memory: 4.8758

Debug from cart page

Debug Message - Perch Runway 3.0.11
[31] SELECT p.pagePath, pr.routePattern, pr.routeRegExp, p.pageTemplate, pr.routeOrder, s.settingValue AS siteOffline FROM perch3_pages p LEFT JOIN perch3_page_routes pr ON p.pageID=pr.pageID LEFT JOIN perch3_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 perch3_page_routes pr2 WHERE templateID!=0 ORDER BY routeOrder ASC, pagePath ASC
Matched page: /shop/basket, so not using routes.
Using master page: /templates/pages/shop/basket.php
[1] SELECT * FROM perch3_pages WHERE pagePath='/shop/basket' LIMIT 1
[1] SELECT * FROM perch3_shop_cart WHERE cartID=10942
[1] SELECT * FROM perch3_shop_cart WHERE cartID=10942
[1] SELECT * FROM perch3_shop_sales WHERE saleFrom<='2017-11-23 09:41:00' AND saleTo>'2017-11-23 09:41:00' AND saleActive=1 AND saleDeleted IS NULL ORDER BY saleOrder ASC
UPDATE perch3_shop_cart SET cartPricing='sale' WHERE cartID='10942'
------------------------------ Calculating cart ------------------------------
[1] SELECT * FROM perch3_shop_cart WHERE cartID=10942
[1] SELECT * FROM perch3_shop_cart WHERE cartID=10942
[1] SELECT * FROM perch3_shop_tax_locations WHERE locationID=1 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_currencies WHERE currencyID=47 LIMIT 1
[1] SELECT COUNT(productID) AS product_count, SUM(itemQty) AS item_count FROM perch3_shop_cart_items WHERE cartID=10942
[44] SELECT DISTINCT settingID, settingValue FROM perch3_settings WHERE userID=0
Tax mode: inc
[nil] SELECT * FROM perch3_shop_cart_items WHERE cartID=10942 ORDER BY itemID ASC
UPDATE perch3_shop_cart SET cartTotalItems=NULL, cartTotalProducts='0', cartTotalWithTax='0.00', cartTotalWithoutTax='0.00' WHERE cartID='10942'
Using sub-template: /templates/shop/products/variant_detail.html
Using sub-template: /templates/shop/products/variant_detail.html
[1] SELECT itemID, itemQty FROM perch3_shop_cart_items WHERE cartID=10942 AND productID=20
[1] SELECT * FROM perch3_shop_products WHERE productID=20 AND productDeleted IS NULL LIMIT 1
INSERT INTO perch3_shop_cart_items(productID,itemQty,cartID) VALUES('20',1,'10942')
------------------------------ Calculating cart ------------------------------
[1] SELECT * FROM perch3_shop_cart WHERE cartID=10942
[1] SELECT * FROM perch3_shop_cart WHERE cartID=10942
[1] SELECT * FROM perch3_shop_tax_locations WHERE locationID=1 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_currencies WHERE currencyID=47 LIMIT 1
[1] SELECT COUNT(productID) AS product_count, SUM(itemQty) AS item_count FROM perch3_shop_cart_items WHERE cartID=10942
Tax mode: inc
[1] SELECT * FROM perch3_shop_cart_items WHERE cartID=10942 ORDER BY itemID ASC
[1] SELECT * FROM perch3_shop_products WHERE productID=20 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_products WHERE productID=19 AND productDeleted IS NULL LIMIT 1
[1] SELECT * FROM perch3_shop_products WHERE productID=19 AND productDeleted IS NULL LIMIT 1
[1] SELECT productID, productVariantDesc, stock_level FROM perch3_shop_products WHERE parentID=19 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=19 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[12] 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='19' 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=19 AND productDeleted IS NULL LIMIT 1
[1] SELECT productID, productVariantDesc, stock_level FROM perch3_shop_products WHERE parentID=19 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=19 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[12] 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='19' 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=19 AND productDeleted IS NULL LIMIT 1
[1] SELECT productID, productVariantDesc, stock_level FROM perch3_shop_products WHERE parentID=19 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=19 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[12] 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='19' 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=19 AND productDeleted IS NULL LIMIT 1
[1] SELECT productID, productVariantDesc, stock_level FROM perch3_shop_products WHERE parentID=19 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=19 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[12] 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='19' 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=19 AND productDeleted IS NULL LIMIT 1
[1] SELECT productID, productVariantDesc, stock_level FROM perch3_shop_products WHERE parentID=19 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=19 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[12] 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='19' 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 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=236 OR zoneIsDefault=1) ORDER BY zoneIsDefault ASC LIMIT 1
[4] SELECT * FROM perch3_shop_shippings WHERE shippingDeleted IS NULL ORDER BY shippingOrder ASC
[1] SELECT * FROM perch3_shop_shipping_zones WHERE zoneDeleted IS NULL AND zoneActive=1 AND zoneID IN (1)
[37] SELECT rateID AS id, rateTitle AS title, rateValue AS rate, locationID FROM perch3_shop_tax_rates WHERE rateDeleted IS NULL ORDER BY rateValue DESC
[3] SELECT * FROM perch3_shop_shipping_zones WHERE zoneDeleted IS NULL AND zoneActive=1 AND zoneID IN (2, 5, 6)
[3] SELECT * FROM perch3_shop_shipping_zones WHERE zoneDeleted IS NULL AND zoneActive=1 AND zoneID IN (2, 5, 6)
[1] SELECT * FROM perch3_shop_shipping_zones WHERE zoneDeleted IS NULL AND zoneActive=1 AND zoneID IN (1)
Qualifying shipping method ‘Second Class Delivery (FREE!)’
Rejecting shipping method ‘International Standard Delivery’ because: no price available for chosen shipping zone
Rejecting shipping method ‘International Tracked & Signed Delivery’ because: no price available for chosen shipping zone
Qualifying shipping method ‘First Class Tracked & Signed Delivery’
[1] SELECT * FROM perch3_shop_shippings WHERE shippingID='1' AND shippingDeleted IS NULL LIMIT 1
Using shipping zone: United Kingdom mainland
[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
[3] SELECT * FROM perch3_shop_promotions WHERE promoFrom<='2017-11-23 09:41:00' AND promoTo>'2017-11-23 09:41:00' AND promoActive=1 AND promoDeleted IS NULL ORDER BY promoOrder ASC
Promo (Mailing List 10%) skipped: discount code not applied.
Promo (Customer service 20%) skipped: discount code not applied.
Promo (Customer service 25%) skipped: discount code not applied.
UPDATE perch3_shop_cart SET cartTotalItems='1', cartTotalProducts='1', cartTotalWithTax='0.00', cartTotalWithoutTax='0.00' WHERE cartID='10942'
INSERT INTO perch3_shop_cart_data(cartID,productID,cartData) VALUES('10942','20','{\"product\":\"20\"}')
Using template: /templates/pages/attributes/body_attributes.html
Using template: /templates/pages/attributes/seo.html
[3] SELECT regionKey, regionHTML FROM perch3_content_regions WHERE regionPage='/shop/basket' OR regionPage='*' ORDER BY regionPage DESC
[1] SELECT groupID FROM perch3_navigation WHERE groupSlug='main-navigation' LIMIT 1
[4] SELECT np.pageID, np.pageParentID, p.pagePath, p.pageTitle, p.pageNavText, p.pageNew, p.pageOrder, np.pageDepth, p.pageSortPath, np.pageTreePosition, p.pageAccessTags, p.pageAttributes FROM perch3_navigation_pages np, perch3_pages p WHERE p.pageID=np.pageID AND np.groupID=6 AND p.pageNew=0 ORDER BY np.pageTreePosition ASC
[0] SELECT np.pageTreePosition FROM perch3_pages p, perch3_navigation_pages np WHERE np.pageID=p.pageID AND np.groupID=6 AND p.pagePath='/shop/basket' LIMIT 1
[4] Using template: /templates/navigation/menu_item.html
Using template: /templates/search/search-form.html
[1] SELECT pageTreePosition FROM perch3_pages WHERE pagePath='/shop/basket' OR pageSortPath='/shop/basket' LIMIT 1
[2] SELECT * FROM perch3_pages WHERE pageHidden=0 AND pageNew=0 AND pageTreePosition IN ('000-004-002', '000-004', '000') ORDER BY pageTreePosition
[2] Using template: /templates/navigation/breadcrumb.html
Using cart from cache.
[1] SELECT * FROM perch3_shop_products WHERE productID=19 AND productDeleted IS NULL LIMIT 1
[1] SELECT productID, productVariantDesc, stock_level FROM perch3_shop_products WHERE parentID=19 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=19 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[12] 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='19' 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] Using template: /templates/shop/cart/cart.html
[1] SELECT groupID FROM perch3_navigation WHERE groupSlug='secondary-navigation' LIMIT 1
[4] SELECT np.pageID, np.pageParentID, p.pagePath, p.pageTitle, p.pageNavText, p.pageNew, p.pageOrder, np.pageDepth, p.pageSortPath, np.pageTreePosition, p.pageAccessTags, p.pageAttributes FROM perch3_navigation_pages np, perch3_pages p WHERE p.pageID=np.pageID AND np.groupID=2 AND p.pageNew=0 ORDER BY np.pageTreePosition ASC
[0] SELECT np.pageTreePosition FROM perch3_pages p, perch3_navigation_pages np WHERE np.pageID=p.pageID AND np.groupID=2 AND p.pagePath='/shop/basket' LIMIT 1
[4] Using template: /templates/navigation/menu_item.html
[1] SELECT regionID, regionTemplate, regionPage, regionRev AS rev FROM perch3_content_regions WHERE regionKey='ep_social' AND (regionPage LIKE '%' OR regionPage='*')
[1] SELECT * FROM ( SELECT idx.itemID, c.regionID, idx.pageID, c.itemJSON, idx2.indexValue as sortval FROM perch3_content_index idx JOIN perch3_content_items c ON idx.itemID=c.itemID AND idx.itemRev=c.itemRev AND idx.regionID=c.regionID JOIN perch3_content_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_order' WHERE ((idx.regionID=9 AND idx.itemRev=7)) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, pageID, itemJSON, sortval, regionID ORDER BY sortval ASC
[4] Using template: /templates/content//blocks/social_block.html
Request time: 0.0924
Process time: 0.0912
Memory: 4.9787

I've been playing around with it offline and the cart also seems to change behaviour between browsers.

If I disable the promotional sale period, and even delete it, then I get even more weird behaviour:

In Safari the full price remains 0 in the cart even though it's set to a number. If I add a sale price to a variant then the sale price appears in the cart. Even though there is no sale and there is a full price set in the variant.

Testing the same product in Firefox and Chrome and the full price appears in the cart.

If I regenerate the variants then I get a Fatal Error:

Fatal error: Uncaught Error: Call to a member function get_prices() on boolean in /Users/ellimondo/Dropbox/Sites/ellipress/dev.ellipress.co.uk/perch/addons/apps/perch_shop/lib/PerchShop_Cart.class.php:723 Stack trace: #0 /Users/ellimondo/Dropbox/Sites/ellipress/dev.ellipress.co.uk/perch/addons/apps/perch_shop/lib/PerchShop_Cart.class.php(244): PerchShop_Cart->calculate_cart() #1 /Users/ellimondo/Dropbox/Sites/ellipress/dev.ellipress.co.uk/perch/addons/apps/perch_shop/lib/PerchShop_Cart.class.php(123): PerchShop_Cart->recalculate_summary_data() #2 /Users/ellimondo/Dropbox/Sites/ellipress/dev.ellipress.co.uk/perch/addons/apps/perch_shop/lib/PerchShop_Runtime.class.php(205): PerchShop_Cart->add_to_cart('114', 1) #3 /Users/ellimondo/Dropbox/Sites/ellipress/dev.ellipress.co.uk/perch/addons/apps/perch_shop/runtime/forms.php(31): PerchShop_Runtime->add_to_cart_from_form(Object(PerchAPI_SubmittedForm)) #4 /Users/ellimondo/Dropbox/Sites/ellipress/dev.ellipress.co.uk/perch/core/lib/Perch.class.php(131): perch_shop_form_handler(Obje in /Users/ellimondo/Dropbox/Sites/ellipress/dev.ellipress.co.uk/perch/addons/apps/perch_shop/lib/PerchShop_Cart.class.php on line 723

Very probably! Ignore the fatal error bit.

There's no discount code. It's just a sales promotion period of time. I assume that triggers any sales prices set on products and their variants?

So it seems that as soon as you set up a sales promotion period, any product variants are forced to take their price from the variant's sale price even if this isn't set. Any conditionals in the variant are ignored – the sale price is always taken by the cart, even if that is null.

The biggest problem I have here is that there's no way (as far as my pickled walnut of a brain can tell) to let non-sale products ignore this state because the sales promotion switch (sale_price or regular_price) is set at the product level not the variant. So full price products sell for 0 as I found out today with a live site, even though they display their full price in the product page.

Hi Drew

This is how I set it up initially:

Sales promotion date range set and activated

Products have regular price and sales price set at the variant level.

Products not in sale do not have sales price set.