I have a coupon that gives 10% off any order (excluding shipping). It works fine except when sales tax is applied. Here is an example:
Currently:
Product: $80.50
Discount: -$8.53
Tax 6%: $4.35
Shipping: $8.05
Total $84.37
The discount should be $8.05 ($80.50 * .1 = $8.05) but instead it takes the total, applies tax to it and then gives the discount. ($80.50 * 1.06 = $85.33) (85.33 * .1 = $8.53).
Then it takes the sales tax from the discount and gets the amount shown in the sales tax ($4.35).
So the customer gets a bigger discount because it includes the sales tax. The correct numbers should be:
Product: $80.50
Discount: -$8.05
Tax 6%: $4.35
Shipping: $8.05
Total $84.85
Anyone have any ideas how to fix this?
Thanks



