We are transitioning over to a new forum platform. Please post new issues there. Existing threads will be dealt with here unless you choose to move them over. Visit the new forum

Forum

Thread tagged as: Problem, Shop

Mis-calculated discount

Hi,

I am seeing a couple of weird issues on a Shop implementation to do with promotions. The company is trying to offer a £10 off code when people sign up to the newsletter. To achieve this they have put the discount before tax for the promo code to be 8.33 - as a side note it would be good to be able to have the option to enter this sort of discount including tax as well.

1) The discount is applied multiple times If I add one sku to the cart the £10 discount is given. Multiples of that sku keep the £10 discount. If I add another SKU I am now getting a £20 discount. I would expect the promotion to apply to the cart rather than the SKUs.

2) The discount is sometimes £9.99 With some products the discount is calculated to £9.99 rather than £10. I can't work out the pattern for why this happens to some and not others.

To replicate both issues you can take a look at the shop here:

https://newgatewatches.com/shop

An example of a product that causes the £9.99 error is this one:

https://newgatewatches.com/shop/products/the-king-wwlkngvs018lb-steel-watch-mens-womens-brown-leather-strap-fashion-video/

The code for the £10 off is WELCOME10

This is the diagnostics:

Perch Runway: 2.8.32, PHP: 5.6.26, MySQL: mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $, with PDO
Server OS: Linux, cgi-fcgi
Installed apps: content (2.8.32), assets (2.8.32), categories (2.8.32), perch_blog (5.0), perch_forms (1.8.3), perch_shop_orders (1.0.10), perch_shop_products (1.0.10), perch_shop (1.0.10), perch_members (1.5), perch_mailchimp (3.0.1), perch_twitter (3.6.2)
App runtimes: <?php $apps_list = array( 'content', 'categories', 'perch_forms', 'perch_mailchimp', 'perch_twitter', 'perch_members', 'perch_shop', 'perch_blog' );
PERCH_LOGINPATH: /admin
PERCH_PATH: /home/newgatewatches/public_html/admin
PERCH_CORE: /home/newgatewatches/public_html/admin/core
PERCH_RESFILEPATH: /home/newgatewatches/public_html/admin/resources
Image manipulation: GD
PHP limits: Max upload 128M, Max POST 128M, Memory: 128M, Total max file upload: 128M
F1: 2edba60ed1f613d6dd804feb202456a2
Resource folder writeable: Yes
DOCUMENT_ROOT: /home/newgatewatches/public_html
HTTP_HOST: newgatewatches.com
REQUEST_URI: /admin/core/settings/diagnostics/
SCRIPT_NAME: /admin/core/settings/diagnostics/index.php

Thanks for any help with this - I have updated to the latest Shop but am still seeing these issues

Mike Harrison

Mike Harrison 37 points

  • 3 years ago
Drew McLellan

Drew McLellan 2638 points
Perch Support

There are no per-product promotions currently - they only apply to the whole cart. So I'm struggling to see how a promo could be applied multiple times.

How many promos do you have defined?

Hi,

There are quite a few, (marketing ties specific ones into publications etc. so they are racking up fairly quickly). There are 11 listed in Perch currently. All require a code to be entered. This promo is the only one with a fixed amount discount, the rest are all percentages.

This example shows both issues in one cart:

https://drive.google.com/file/d/0B3J3Si4Ux9XQci1NQm9STGJEZms/view?usp=sharing

This is the debug from that page, with those two products in the cart:

Time    Δ   Debug Message
0.2921  0   [48] SELECT p.pagePath, pr.routePattern, pr.routeRegExp, p.pageTemplate FROM watches_pages p LEFT JOIN watches_page_routes pr ON p.pageID=pr.pageID ORDER BY pr.routeOrder ASC, p.pagePath ASC
0.294   0.0019  Matched page: /shop/cart, so not using routes.
0.2941  0.0001  Using master page: /templates/pages/cart.php
0.3128  0.0187  [1] SELECT * FROM watches_pages WHERE pagePath='/shop/cart' LIMIT 1
0.341   0.0282  [1] SELECT * FROM watches_shop_cart WHERE cartID=92132
0.3417  0.0006  [1] SELECT * FROM watches_shop_cart WHERE cartID=92132
0.3481  0.0064  [39] SELECT DISTINCT settingID, settingValue FROM watches_settings WHERE userID=0
0.3786  0.0305  UPDATE watches_shop_cart SET cartDiscountCode='WELCOME10' WHERE cartID='92132'
0.3796  0.001   ------------------------------ Calculating cart ------------------------------
0.3797  0.0001  [1] SELECT * FROM watches_shop_cart WHERE cartID=92132
0.4054  0.0257  [1] SELECT * FROM watches_shop_cart WHERE cartID=92132
0.4125  0.0071  [1] SELECT * FROM watches_shop_tax_locations WHERE locationID=1 AND locationDeleted IS NULL LIMIT 1
0.4132  0.0007  [1] SELECT locationID FROM watches_shop_tax_locations WHERE locationIsHome=1 LIMIT 1
0.4137  0.0004  [1] SELECT * FROM watches_shop_tax_locations WHERE locationID=1 AND locationDeleted IS NULL LIMIT 1
0.4171  0.0034  [1] SELECT * FROM watches_shop_currencies WHERE currencyID=47 LIMIT 1
0.4176  0.0005  [1] SELECT COUNT(productID) AS product_count, SUM(itemQty) AS item_count FROM watches_shop_cart_items WHERE cartID=92132
0.418   0.0004  Tax mode: inc
0.4207  0.0027  [2] SELECT * FROM watches_shop_cart_items WHERE cartID=92132 ORDER BY itemID ASC
0.43    0.0093  [1] SELECT * FROM watches_shop_products WHERE productID=348 AND productDeleted IS NULL LIMIT 1
0.4402  0.0102  [1] SELECT * FROM watches_shop_tax_groups WHERE groupID=2 AND groupDeleted IS NULL LIMIT 1
0.4407  0.0006  [1] SELECT r.rateValue FROM watches_shop_tax_group_rates gr, watches_shop_tax_rates r WHERE gr.rateID=r.rateID AND gr.groupID=2 AND gr.locationID=1
0.4457  0.0049  [1] SELECT * FROM watches_shop_products WHERE productID=331 AND productDeleted IS NULL LIMIT 1
0.4499  0.0042  [1] SELECT * FROM watches_shop_tax_groups WHERE groupID=2 AND groupDeleted IS NULL LIMIT 1
0.4504  0.0005  [1] SELECT r.rateValue FROM watches_shop_tax_group_rates gr, watches_shop_tax_rates r WHERE gr.rateID=r.rateID AND gr.groupID=2 AND gr.locationID=1
0.4575  0.0071  [1] SELECT z.* FROM watches_shop_shipping_zones z LEFT JOIN watches_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
0.4611  0.0036  [2] SELECT * FROM watches_shop_shippings WHERE shippingDeleted IS NULL ORDER BY shippingOrder ASC
0.4651  0.0039  [12] SELECT * FROM watches_shop_shipping_zones WHERE zoneDeleted IS NULL AND zoneActive=1 AND zoneID IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12)
0.466   0.0009  [1] SELECT rateID AS id, rateTitle AS title, rateValue AS rate, locationID FROM watches_shop_tax_rates WHERE rateDeleted IS NULL ORDER BY rateValue DESC
0.4664  0.0004  [1] SELECT rateID AS id, rateTitle AS title, rateValue AS rate, locationID FROM watches_shop_tax_rates WHERE rateDeleted IS NULL ORDER BY rateValue DESC
0.4667  0.0003  [nil] SELECT rateID AS id, rateTitle AS title, rateValue AS rate FROM watches_shop_tax_rates WHERE locationID=2 AND rateDeleted IS NULL ORDER BY rateValue DESC
0.4671  0.0004  [1] SELECT rateID AS id, rateTitle AS title, rateValue AS rate, locationID FROM watches_shop_tax_rates WHERE rateDeleted IS NULL ORDER BY rateValue DESC
0.4674  0.0003  [nil] SELECT rateID AS id, rateTitle AS title, rateValue AS rate FROM watches_shop_tax_rates WHERE locationID=3 AND rateDeleted IS NULL ORDER BY rateValue DESC
0.4678  0.0004  [1] SELECT rateID AS id, rateTitle AS title, rateValue AS rate, locationID FROM watches_shop_tax_rates WHERE rateDeleted IS NULL ORDER BY rateValue DESC
0.4682  0.0003  [nil] SELECT rateID AS id, rateTitle AS title, rateValue AS rate FROM watches_shop_tax_rates WHERE locationID=4 AND rateDeleted IS NULL ORDER BY rateValue DESC
0.4687  0.0005  [1] SELECT rateID AS id, rateTitle AS title, rateValue AS rate, locationID FROM watches_shop_tax_rates WHERE rateDeleted IS NULL ORDER BY rateValue DESC
0.4691  0.0004  [nil] SELECT rateID AS id, rateTitle AS title, rateValue AS rate FROM watches_shop_tax_rates WHERE locationID=5 AND rateDeleted IS NULL ORDER BY rateValue DESC
0.4697  0.0006  [1] SELECT rateID AS id, rateTitle AS title, rateValue AS rate, locationID FROM watches_shop_tax_rates WHERE rateDeleted IS NULL ORDER BY rateValue DESC
0.4701  0.0004  [nil] SELECT rateID AS id, rateTitle AS title, rateValue AS rate FROM watches_shop_tax_rates WHERE locationID=6 AND rateDeleted IS NULL ORDER BY rateValue DESC
0.4705  0.0004  [1] SELECT rateID AS id, rateTitle AS title, rateValue AS rate, locationID FROM watches_shop_tax_rates WHERE rateDeleted IS NULL ORDER BY rateValue DESC
0.4709  0.0004  [nil] SELECT rateID AS id, rateTitle AS title, rateValue AS rate FROM watches_shop_tax_rates WHERE locationID=7 AND rateDeleted IS NULL ORDER BY rateValue DESC
0.4713  0.0004  [1] SELECT rateID AS id, rateTitle AS title, rateValue AS rate, locationID FROM watches_shop_tax_rates WHERE rateDeleted IS NULL ORDER BY rateValue DESC
0.4716  0.0003  [nil] SELECT rateID AS id, rateTitle AS title, rateValue AS rate FROM watches_shop_tax_rates WHERE locationID=8 AND rateDeleted IS NULL ORDER BY rateValue DESC
0.472   0.0004  [1] SELECT rateID AS id, rateTitle AS title, rateValue AS rate, locationID FROM watches_shop_tax_rates WHERE rateDeleted IS NULL ORDER BY rateValue DESC
0.4723  0.0003  [nil] SELECT rateID AS id, rateTitle AS title, rateValue AS rate FROM watches_shop_tax_rates WHERE locationID=9 AND rateDeleted IS NULL ORDER BY rateValue DESC
0.4727  0.0004  [1] SELECT rateID AS id, rateTitle AS title, rateValue AS rate, locationID FROM watches_shop_tax_rates WHERE rateDeleted IS NULL ORDER BY rateValue DESC
0.473   0.0003  [nil] SELECT rateID AS id, rateTitle AS title, rateValue AS rate FROM watches_shop_tax_rates WHERE locationID=10 AND rateDeleted IS NULL ORDER BY rateValue DESC
0.4734  0.0004  [1] SELECT rateID AS id, rateTitle AS title, rateValue AS rate, locationID FROM watches_shop_tax_rates WHERE rateDeleted IS NULL ORDER BY rateValue DESC
0.4737  0.0003  [nil] SELECT rateID AS id, rateTitle AS title, rateValue AS rate FROM watches_shop_tax_rates WHERE locationID=11 AND rateDeleted IS NULL ORDER BY rateValue DESC
0.474   0.0003  [1] SELECT rateID AS id, rateTitle AS title, rateValue AS rate, locationID FROM watches_shop_tax_rates WHERE rateDeleted IS NULL ORDER BY rateValue DESC
0.4743  0.0003  [nil] SELECT rateID AS id, rateTitle AS title, rateValue AS rate FROM watches_shop_tax_rates WHERE locationID=12 AND rateDeleted IS NULL ORDER BY rateValue DESC
0.4747  0.0004  [1] SELECT * FROM watches_shop_shipping_zones WHERE zoneDeleted IS NULL AND zoneActive=1 AND zoneID IN (1)
0.4751  0.0004  Qualifying shipping method ‘Free Shipping’
0.4752  0.0001  Qualifying shipping method ‘Next Working Day Delivery’
0.4753  0.0001  [1] SELECT * FROM watches_shop_shippings WHERE shippingID='1' AND shippingDeleted IS NULL LIMIT 1
0.4758  0.0005  Using shipping zone: UK
0.476   0.0003  [1] SELECT * FROM watches_shop_tax_groups WHERE groupID=2 AND groupDeleted IS NULL LIMIT 1
0.4765  0.0005  [1] SELECT r.rateValue FROM watches_shop_tax_group_rates gr, watches_shop_tax_rates r WHERE gr.rateID=r.rateID AND gr.groupID=2 AND gr.locationID=1
0.4802  0.0037  [9] SELECT * FROM watches_shop_promotions WHERE promoFrom<='2016-11-22 09:39:00' AND promoTo>'2016-11-22 09:39:00' AND promoActive=1 AND promoDeleted IS NULL ORDER BY promoOrder ASC
0.4842  0.0041  Promo (newgatefriends20) skipped: discount code not applied.
0.4844  0.0002  Promo (VOGUEOCT) skipped: discount code not applied.
0.4845  0.0001  Promo (VOGUENOV) skipped: discount code not applied.
0.4849  0.0003  Promo (WELCOME10) qualifies!
0.4851  0.0002  Fixed amount discount promo
0.4863  0.0012  UPDATE watches_shop_cart SET cartTotalItems='2', cartTotalProducts='2', cartTotalWithTax='280.01', cartTotalWithoutTax='250.00' WHERE cartID='92132'
0.4872  0.0009  [1] SELECT * FROM watches_shop_products WHERE productID=348 AND productDeleted IS NULL LIMIT 1
0.4891  0.0019  UPDATE watches_shop_cart_items SET itemQty=1 WHERE cartID='92132' AND productID=348
0.4898  0.0007  [1] SELECT * FROM watches_shop_products WHERE productID=331 AND productDeleted IS NULL LIMIT 1
0.4918  0.002   UPDATE watches_shop_cart_items SET itemQty=1 WHERE cartID='92132' AND productID=331
0.4926  0.0008  ------------------------------ Calculating cart ------------------------------
0.4927  0.0001  [1] SELECT * FROM watches_shop_cart WHERE cartID=92132
0.4931  0.0004  [1] SELECT * FROM watches_shop_cart WHERE cartID=92132
0.4935  0.0003  [1] SELECT * FROM watches_shop_tax_locations WHERE locationID=1 AND locationDeleted IS NULL LIMIT 1
0.4938  0.0003  [1] SELECT locationID FROM watches_shop_tax_locations WHERE locationIsHome=1 LIMIT 1
0.4941  0.0003  [1] SELECT * FROM watches_shop_tax_locations WHERE locationID=1 AND locationDeleted IS NULL LIMIT 1
0.4945  0.0003  [1] SELECT * FROM watches_shop_currencies WHERE currencyID=47 LIMIT 1
0.4948  0.0003  [1] SELECT COUNT(productID) AS product_count, SUM(itemQty) AS item_count FROM watches_shop_cart_items WHERE cartID=92132
0.4952  0.0004  Tax mode: inc
0.4952  0.0001  [2] SELECT * FROM watches_shop_cart_items WHERE cartID=92132 ORDER BY itemID ASC
0.4957  0.0004  [1] SELECT * FROM watches_shop_products WHERE productID=348 AND productDeleted IS NULL LIMIT 1
0.4989  0.0032  [1] SELECT * FROM watches_shop_tax_groups WHERE groupID=2 AND groupDeleted IS NULL LIMIT 1
0.4993  0.0004  [1] SELECT r.rateValue FROM watches_shop_tax_group_rates gr, watches_shop_tax_rates r WHERE gr.rateID=r.rateID AND gr.groupID=2 AND gr.locationID=1
0.5036  0.0043  [1] SELECT * FROM watches_shop_products WHERE productID=331 AND productDeleted IS NULL LIMIT 1
0.5072  0.0036  [1] SELECT * FROM watches_shop_tax_groups WHERE groupID=2 AND groupDeleted IS NULL LIMIT 1
0.5076  0.0004  [1] SELECT r.rateValue FROM watches_shop_tax_group_rates gr, watches_shop_tax_rates r WHERE gr.rateID=r.rateID AND gr.groupID=2 AND gr.locationID=1
0.512   0.0044  [1] SELECT z.* FROM watches_shop_shipping_zones z LEFT JOIN watches_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
0.5126  0.0007  [2] SELECT * FROM watches_shop_shippings WHERE shippingDeleted IS NULL ORDER BY shippingOrder ASC
0.5132  0.0006  [12] SELECT * FROM watches_shop_shipping_zones WHERE zoneDeleted IS NULL AND zoneActive=1 AND zoneID IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12)
0.5141  0.0009  [1] SELECT rateID AS id, rateTitle AS title, rateValue AS rate, locationID FROM watches_shop_tax_rates WHERE rateDeleted IS NULL ORDER BY rateValue DESC
0.5146  0.0005  [nil] SELECT rateID AS id, rateTitle AS title, rateValue AS rate FROM watches_shop_tax_rates WHERE locationID=2 AND rateDeleted IS NULL ORDER BY rateValue DESC
0.5151  0.0005  [1] SELECT rateID AS id, rateTitle AS title, rateValue AS rate, locationID FROM watches_shop_tax_rates WHERE rateDeleted IS NULL ORDER BY rateValue DESC
0.5155  0.0004  [nil] SELECT rateID AS id, rateTitle AS title, rateValue AS rate FROM watches_shop_tax_rates WHERE locationID=3 AND rateDeleted IS NULL ORDER BY rateValue DESC
0.5159  0.0004  [1] SELECT rateID AS id, rateTitle AS title, rateValue AS rate, locationID FROM watches_shop_tax_rates WHERE rateDeleted IS NULL ORDER BY rateValue DESC
0.5162  0.0003  [nil] SELECT rateID AS id, rateTitle AS title, rateValue AS rate FROM watches_shop_tax_rates WHERE locationID=4 AND rateDeleted IS NULL ORDER BY rateValue DESC
0.5166  0.0004  [1] SELECT rateID AS id, rateTitle AS title, rateValue AS rate, locationID FROM watches_shop_tax_rates WHERE rateDeleted IS NULL ORDER BY rateValue DESC
0.5169  0.0003  [nil] SELECT rateID AS id, rateTitle AS title, rateValue AS rate FROM watches_shop_tax_rates WHERE locationID=5 AND rateDeleted IS NULL ORDER BY rateValue DESC
0.5173  0.0004  [1] SELECT rateID AS id, rateTitle AS title, rateValue AS rate, locationID FROM watches_shop_tax_rates WHERE rateDeleted IS NULL ORDER BY rateValue DESC
0.5176  0.0003  [nil] SELECT rateID AS id, rateTitle AS title, rateValue AS rate FROM watches_shop_tax_rates WHERE locationID=6 AND rateDeleted IS NULL ORDER BY rateValue DESC
0.518   0.0004  [1] SELECT rateID AS id, rateTitle AS title, rateValue AS rate, locationID FROM watches_shop_tax_rates WHERE rateDeleted IS NULL ORDER BY rateValue DESC
0.5183  0.0003  [nil] SELECT rateID AS id, rateTitle AS title, rateValue AS rate FROM watches_shop_tax_rates WHERE locationID=7 AND rateDeleted IS NULL ORDER BY rateValue DESC
0.5187  0.0004  [1] SELECT rateID AS id, rateTitle AS title, rateValue AS rate, locationID FROM watches_shop_tax_rates WHERE rateDeleted IS NULL ORDER BY rateValue DESC
0.519   0.0003  [nil] SELECT rateID AS id, rateTitle AS title, rateValue AS rate FROM watches_shop_tax_rates WHERE locationID=8 AND rateDeleted IS NULL ORDER BY rateValue DESC
0.5194  0.0004  [1] SELECT rateID AS id, rateTitle AS title, rateValue AS rate, locationID FROM watches_shop_tax_rates WHERE rateDeleted IS NULL ORDER BY rateValue DESC
0.5197  0.0003  [nil] SELECT rateID AS id, rateTitle AS title, rateValue AS rate FROM watches_shop_tax_rates WHERE locationID=9 AND rateDeleted IS NULL ORDER BY rateValue DESC
0.52    0.0003  [1] SELECT rateID AS id, rateTitle AS title, rateValue AS rate, locationID FROM watches_shop_tax_rates WHERE rateDeleted IS NULL ORDER BY rateValue DESC
0.5202  0.0003  [nil] SELECT rateID AS id, rateTitle AS title, rateValue AS rate FROM watches_shop_tax_rates WHERE locationID=10 AND rateDeleted IS NULL ORDER BY rateValue DESC
0.5206  0.0003  [1] SELECT rateID AS id, rateTitle AS title, rateValue AS rate, locationID FROM watches_shop_tax_rates WHERE rateDeleted IS NULL ORDER BY rateValue DESC
0.5209  0.0003  [nil] SELECT rateID AS id, rateTitle AS title, rateValue AS rate FROM watches_shop_tax_rates WHERE locationID=11 AND rateDeleted IS NULL ORDER BY rateValue DESC
0.5212  0.0003  [1] SELECT rateID AS id, rateTitle AS title, rateValue AS rate, locationID FROM watches_shop_tax_rates WHERE rateDeleted IS NULL ORDER BY rateValue DESC
0.5215  0.0003  [nil] SELECT rateID AS id, rateTitle AS title, rateValue AS rate FROM watches_shop_tax_rates WHERE locationID=12 AND rateDeleted IS NULL ORDER BY rateValue DESC
0.5219  0.0004  [1] SELECT * FROM watches_shop_shipping_zones WHERE zoneDeleted IS NULL AND zoneActive=1 AND zoneID IN (1)
0.5222  0.0004  Qualifying shipping method ‘Free Shipping’
0.5223  0.0001  Qualifying shipping method ‘Next Working Day Delivery’
0.5224  0.0001  [1] SELECT * FROM watches_shop_shippings WHERE shippingID='1' AND shippingDeleted IS NULL LIMIT 1
0.5228  0.0004  Using shipping zone: UK
0.523   0.0002  [1] SELECT * FROM watches_shop_tax_groups WHERE groupID=2 AND groupDeleted IS NULL LIMIT 1
0.5233  0.0003  [1] SELECT r.rateValue FROM watches_shop_tax_group_rates gr, watches_shop_tax_rates r WHERE gr.rateID=r.rateID AND gr.groupID=2 AND gr.locationID=1
0.5237  0.0005  [9] SELECT * FROM watches_shop_promotions WHERE promoFrom<='2016-11-22 09:39:00' AND promoTo>'2016-11-22 09:39:00' AND promoActive=1 AND promoDeleted IS NULL ORDER BY promoOrder ASC
0.5243  0.0006  Promo (newgatefriends20) skipped: discount code not applied.
0.5244  0.0001  Promo (VOGUEOCT) skipped: discount code not applied.
0.5246  0.0001  Promo (VOGUENOV) skipped: discount code not applied.
0.5248  0.0003  Promo (WELCOME10) qualifies!
0.525   0.0002  Fixed amount discount promo
0.5261  0.0011  UPDATE watches_shop_cart SET cartTotalItems='2', cartTotalProducts='2', cartTotalWithTax='280.01', cartTotalWithoutTax='250.00' WHERE cartID='92132'
0.5339  0.0078  Using template: /templates/pages/attributes/default.html
0.5522  0.0183  [5] SELECT regionKey, regionHTML FROM watches_content_regions WHERE regionPage='/shop/cart' OR regionPage='*' ORDER BY regionPage DESC
0.5558  0.0035  [3] SELECT currencyID, currencyCode FROM watches_shop_currencies WHERE currencyActive=1 ORDER BY currencyID=47 DESC, currencyCode
0.5593  0.0036  Using template: /templates/shop/currencies/selected-gbp.html
0.5767  0.0174  [1] SELECT setID FROM watches_category_sets WHERE setSlug='products' LIMIT 1
0.5773  0.0006  [11] SELECT main.* FROM watches_categories main WHERE 1=1 AND setID=1 ORDER BY catTreePosition ASC
0.6051  0.0278  [11] Using template: /templates/categories/product_categories.html
0.6252  0.0201  [1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM watches_pages WHERE pagePath='/information' OR pageSortPath='/information' LIMIT 1
0.6259  0.0006  [6] SELECT * FROM watches_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-008%' AND pageDepth >=1 AND pageDepth<=2 ORDER BY pageTreePosition ASC
0.6277  0.0019  [1] SELECT pageTreePosition FROM watches_pages WHERE pagePath='/shop/cart' LIMIT 1
0.6282  0.0005  [2] SELECT pageID FROM watches_pages WHERE pageTreePosition IN ('000-003-003', '000-003', '000') ORDER BY pageTreePosition DESC
0.6288  0.0006  [5] Using template: /templates/navigation/dropdown-item.html
0.6537  0.0249  Using template: /templates/search/search-form.html
0.6733  0.0196  Using cart from cache.
0.6912  0.0179  [2] Using template: /templates/shop/cart/cart.html
0.7738  0.0826  Request time: 0.7737
0.7738  0   Process time: 0.7662
0.7738  0   Memory: 7.7174
Drew McLellan

Drew McLellan 2638 points
Perch Support

In the database table, can you check there isn't more than one row with the WELCOME10 code?

In perch_shop_promotions there is only one row for WELCOME10

Drew McLellan

Drew McLellan 2638 points
Perch Support

Ok, thanks for checking

Hi Drew,

Anything else I can help with on this?

Drew McLellan

Drew McLellan 2638 points
Perch Support

I think I'll need to set something up to try to reproduce it. It's nothing obvious.

No worries - just saw someone got £19.99 off their order using their introductory £10 off code which reminded me about both issues, and reminded me to remove the offer!

Hi Drew,

Did you get a chance to look at this? I am still seeing mis-calculated discounts coming through