Hi there,
We are currently using version 1.9.2.4 and are experiencing some difficulties with the way discount is being calculated.
We have shopping cart rules set up for trade customers. So for example we have a customer group called "Trade Customer 20% Discount". Any customers added to this group receive 20% discount off the list price of any products we sell. This is discounted prior to delivery charges and VAT being added to the total price.
Here is my issue. We have created a new cart rule which uses a discount code "MM05". The idea is that we can offer existing customers that already get the "20% trade discount" an extra (one off) 5% discount. So we want it to apply 25% discount to the list price of the products before adding delivery and VAT.
Magento is currently calculating it like this:
Product subtotal: £55.60
Discount (20% Trade Discount, MM05): -£13.34
VAT (20%): £10.66
Grand Total £52.94
But this is wrong. It should be:
Product subtotal: £55.60
Discount (20% Trade Discount, MM05): -£13.90
VAT (20%): £8.34
Delivery is free in this instance.
Can anyone advise why Magento is calculating it in this way? I can't even work out how it is arriving at these figures.
Thanks
Lee
