Forums / Upgrading from 1.2 to 1.3.x / Coupons not calculating correctly after upgrade

Coupons not calculating correctly after upgrade

Locked

Started by vegascoug on 21 Nov 2007, 1:27 AM · Views: 2,751

Results 1 to 8 of 8
This thread is locked. New replies are disabled.
21 Nov 2007, 1:27 AM
#1
vegascoug avatar

vegascoug

New Zenner

Join Date:
Feb 2006
Posts:
94
Plugin Contributions:
0

Coupons not calculating correctly after upgrade

Here's my issue:

Upgraded from 1.2.6 to 1.3.7.1 and all went smoothly. Or so I thought.

We have 7.75% sales tax for CA shoppers. Tax is added correctly until you enter a coupon code...then it removes the tax. Found some posts on here and followed a tip to change the coupon settings to Credit Note and then it was adding the tax back on, but it was also taking the discount off shipping.

Include shipping is set to False under the Coupon settings in Order Total, so why is it taking the discount off shipping?

http://www.socalscrap.us/store

Anyone know what's going on or care to test it?

Coupon code TEST45

21 Nov 2007, 5:22 AM
#2
vegascoug avatar

vegascoug

New Zenner

Join Date:
Feb 2006
Posts:
94
Plugin Contributions:
0

Re: Coupons not calculating correctly after upgrade

UPDATE

Okay, I know what's going on but not why and not how to correct it.

If I purchase items in the store for a total of $21.96 and $5.99 shipping, apply a 40% discount, my total should be $20.19 with 7.75% CA Sales Tax

However, this is what's happening. The cart is subtracting $9.46 which is $21.96 in products and $1.71 Sales Tax, Total of $23.67.

The cart is subtracting $8.78 (40%) for the $21.96 and subtracting $0.68 (40% of $1.71 Tax)

It then adds $5.99 for Shipping

It then adds $0.98 Sales Tax (Should be $1.02 at 7.75% of $13.18)

The final total $19.47

However if you take $21.96 and subtract 40% and then add tax, your total should be $20.19.

Zen Cart is taking off the tax discount twice. I am off by .72 cents and that will add up over time and would be worse on larger orders.

Anyone that can help me fix this?

Mike

21 Nov 2007, 5:44 AM
#3
vegascoug avatar

vegascoug

New Zenner

Join Date:
Feb 2006
Posts:
94
Plugin Contributions:
0

Re: Coupons not calculating correctly after upgrade

Turned out to be a simple fix, just didn't know enough about the wording of Zen Cart

I changed Re-Calculate Tax to None and it's perfect.

If I have it on Standard it charges NO TAX

If I use Credit Note it takes too much tax off, does it twice. But if I leave it at none, it lists the full amount of tax which might confuse some buyers, but they are being charged correctly.

Total should be $20.20 for this order and that's what I get. It's charging $1.71 for tax but also taking off the 40% discount off the total including tax, so it's all good in the hood.

Thanks

21 Nov 2007, 10:54 PM
#4
member avatar

member

Zen Follower

Join Date:
Dec 2004
Posts:
102
Plugin Contributions:
0

Re: Coupons not calculating correctly after upgrade

I am having the same problem. Your solution charged twice the tax (based on a 50% off coupon) charging for the price before the coupon, when it should be based on the selling price instead? Does yours double the tax too?

21 Nov 2007, 11:02 PM
#5
member avatar

member

Zen Follower

Join Date:
Dec 2004
Posts:
102
Plugin Contributions:
0

Re: Coupons not calculating correctly after upgrade

This seems to work, would have thought standard was the way to go for recalculate tax.

Re-calculate Tax

Credit Note

Tax Class

Taxable Goods

22 Nov 2007, 12:07 AM
#6
vegascoug avatar

vegascoug

New Zenner

Join Date:
Feb 2006
Posts:
94
Plugin Contributions:
0

Re: Coupons not calculating correctly after upgrade

Have you tried doing the math manually to see if the total is correct?

Zen Cart lists the entire original tax amount but also includes a discount off that amount in the coupon discount amount.

For example, you buy a product for $20 and have 10% Sales Tax. Tax would be $2.00 for a total of $22.

If you apply a coupon for a 50% discount the cart will show the product price of $20 minus an $11 discount plus $2 tax and the total of $11.

It looks like its charging double tax but in reality its not because it took off half the tax with the coupon.

It is the same as listing the product at $20, the discount at $10, and the tax at $1...the total is the same and its correct, at least that's how my cart is doing it.

Mike

22 Nov 2007, 5:06 AM
#7
member avatar

member

Zen Follower

Join Date:
Dec 2004
Posts:
102
Plugin Contributions:
0

Re: Coupons not calculating correctly after upgrade

It works for me when set the way I last stated. The $20 item selling for $10 shows a final tax of $1.00.

When I tried your solution the $20 item selling for $10 shows a final tax of $2.00 instead of the correct amount of $1.00.

I found your post while trying to solve the same problem. I don't know why it is working out differently for each of us.

22 Nov 2007, 5:11 AM
#8
vegascoug avatar

vegascoug

New Zenner

Join Date:
Feb 2006
Posts:
94
Plugin Contributions:
0

Re: Coupons not calculating correctly after upgrade

You might want to check the discount it gives by using Credit Note. The discount didn't change for me, but the tax did.

So by that scenario earlier, it would charge $20 for the product, discount $11, and only charge $1 for tax.

That means the total would be $10 and not $11 and that's shorting you on your tax.

But if your is working that way, great. Mine was still giving the discount of the total which included tax, and then recalculating the tax at the end, so it was giving too much of a discount.

Mike