Results 1 to 8 of 8
  1. #1
    Join Date
    Feb 2006
    Posts
    96
    Plugin Contributions
    0

    Default 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

  2. #2
    Join Date
    Feb 2006
    Posts
    96
    Plugin Contributions
    0

    Default 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

  3. #3
    Join Date
    Feb 2006
    Posts
    96
    Plugin Contributions
    0

    Default 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

  4. #4
    Join Date
    Dec 2004
    Posts
    104
    Plugin Contributions
    0

    Default 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?

  5. #5
    Join Date
    Dec 2004
    Posts
    104
    Plugin Contributions
    0

    Default 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

  6. #6
    Join Date
    Feb 2006
    Posts
    96
    Plugin Contributions
    0

    Default 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

  7. #7
    Join Date
    Dec 2004
    Posts
    104
    Plugin Contributions
    0

    Default 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.

  8. #8
    Join Date
    Feb 2006
    Posts
    96
    Plugin Contributions
    0

    Default 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

 

 

Similar Threads

  1. Upgrade best practices
    By swguy in forum Upgrading from 1.3.x to 1.3.9
    Replies: 3
    Last Post: 2 Nov 2006, 07:22 PM
  2. No upgrade button
    By sobebabies in forum Upgrading from 1.3.x to 1.3.9
    Replies: 10
    Last Post: 19 Oct 2006, 04:38 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •