Forums / General Questions / Coupons with a fixed value adds up 20% on taxable orders

Coupons with a fixed value adds up 20% on taxable orders

Views: 938

Results 1 to 8 of 8
27 Nov 2014, 10:44 PM
#1
dysfunctional avatar

dysfunctional

Zen Follower

Join Date:
Apr 2008
Posts:
159
Plugin Contributions:
0

Coupons with a fixed value adds up 20% on taxable orders

Hi,

I have just started experimenting with discount coupons with a fixed value, instead of a percentage.

I ship worldwide so obviously I have set up different tax rules depending on the shipping destination. Works great.

However, the latest coupon I sent out had a fixed value of 100 SEK.

On a tax-free order, it works just fine :

Attachment 14735

But on any order where there is tax involved, it adds 20% to the value of the coupon. And I can't for the life of me figure out why. 25% would kind of make sense because that's the Swedish sales tax (VAT). But I can't understand where 20% is pulled from?

Attachment 14736

The coupons are automatically created (by mailbeez) and are basically clones of each other. They both say that they're worth 100% when I click on them in admin.

Would really appreciate some advise here, as I have no clue on what I could have overlooked.

Thank you

Best regards

Peter

28 Nov 2014, 2:17 AM
#2
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Coupons with a fixed value adds up 20% on taxable orders

If you go to Modules ... Order Total ... and click on the Discount Coupon, what are all the settings in the right hand panel?

What are all the Sort Orders for your Order Total modules?

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

28 Nov 2014, 9:46 PM
#3
dysfunctional avatar

dysfunctional

Zen Follower

Join Date:
Apr 2008
Posts:
159
Plugin Contributions:
0

Re: Coupons with a fixed value adds up 20% on taxable orders

Hi Linda, thanks for your reply!

My settings are :

Discount Coupon

This module is installed
true

This module is enabled
true

Sort Order
703

Include Shipping
false

Include Tax
false

Re-calculate Tax
Standard

Tax Class
Taxable Goods2

Disable Wholesale
false

Disable Sales
true

Haven't touched these settings in a VERY long time so they can most likely be tweaked a little...

And here's my sort order :

Attachment 14737

:blink:

8 Dec 2014, 2:14 PM
#4
dysfunctional avatar

dysfunctional

Zen Follower

Join Date:
Apr 2008
Posts:
159
Plugin Contributions:
0

Re: Coupons with a fixed value adds up 20% on taxable orders

Ideas, anyone? :)

3 Jan 2015, 9:58 AM
#5
dysfunctional avatar

dysfunctional

Zen Follower

Join Date:
Apr 2008
Posts:
159
Plugin Contributions:
0

Re: Coupons with a fixed value adds up 20% on taxable orders

Another issue for using coupons with fixed value, if applied to an order will a smaller order product value than the coupon itself :

The order including tax was 89 SEK + shipping = 29 SEK = 118 SEK

The coupon value was 100 SEK, which, once applied, once again changes to 120 SEK.

Turned out like this :

Products

1 x CRASHDÏET Flag = 89.00kr

Sub-Total: 89.00kr
Discount Coupon: 720b9e : -117.80kr
Shipping: 29.00kr
Tax (25%): 5.80kr
Total: 0.20kr

I would hope that even kind of "aggressive" coupons like this would not affect the shipping cost... I can totally send out "free" products once in a while, this was the original plan and I know that the customer wouldn't mind paying for shipping only! But it's gonna hurt a little if I also have to cover for the shipping ;-).

And the 20% add on top of the coupons still confuses me :mellow:.

Would be truly grateful for any input here!

Thank you.

Best regards

Peter

3 Jan 2015, 10:11 AM
#6
dysfunctional avatar

dysfunctional

Zen Follower

Join Date:
Apr 2008
Posts:
159
Plugin Contributions:
0

Re: Coupons with a fixed value adds up 20% on taxable orders

I discovered another weird order, this one is with tax as well :

Sub-Total: 290.44kr
Discount Coupon: bea34a : 128.86kr
Economy Mail (€3.76) : 34.00kr
Tax (25%): 36.03kr
Total: 195.58kr

This time, 28.86 SEK was added to my 100 SEK discount coupon.

Clicking on the coupon code generates the correct info :

Congratulations, you have redeemed a Discount Coupon.

Product/Category Restrictions

This coupon is valid for all categories.
This coupon is valid for all products.

Coupon Name : 2013MB_WB#2
Coupon Description : p 100kr fixed value_/p_
The coupon is worth 100.00kr discount against your order
The coupon is valid between 12/20/2014 and 01/04/2015

The coupons are auto generated by Mailbeez but look correct in admin.

When these coupons are used on orders without sales tax / VAT the correct amount of 100 SEK is deducted.

Really have no idea where to go from here?

Best regards

Peter

3 Jan 2015, 4:26 PM
#7
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: Coupons with a fixed value adds up 20% on taxable orders

dysfunctional:

The coupons are automatically created (by mailbeez)
Does the same problem occur if you create a new test coupon by hand using the ZC admin coupon_admin screen?

dysfunctional:

Tax Class
Taxable Goods2
Tax classes are affected by zones (countries+states) and tax rates. How is Taxable Goods2 defined? ie: how could I create that on my own site to make it work just like yours?

dysfunctional:

Disable Wholesale
falseWhere did the "wholesale" option come from? What plugin added that to your site?

What other details would Ajeh need to know to set up her store to recreate this problem exactly as yours is?

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

1 Oct 2015, 2:31 PM
#8
dysfunctional avatar

dysfunctional

Zen Follower

Join Date:
Apr 2008
Posts:
159
Plugin Contributions:
0

Re: Coupons with a fixed value adds up 20% on taxable orders

Hi DrByte, thank you for looking into this! :D

DrByte:

Does the same problem occur if you create a new test coupon by hand using the ZC admin coupon_admin screen?
Yes. Just did a new test with a coupon I created myself.

Again, a tax-free order looks correct :

But once I change shipping address of my test customer - making Zen Cart realize that tax has to be added - it's still adding 20 SEK to my 100 SEK coupon :

DrByte:

Tax classes are affected by zones (countries+states) and tax rates. How is Taxable Goods2 defined? ie: how could I create that on my own site to make it work just like yours?
Oh my god, haven't touched these settings in a long time :D. However, I only use one Tax Class, called Taxable Goods2. This class have 2 rates, one with 25% tax and another rate with 0%. For the 25% tax rate I have added every country that's included in the European Union, making sure they pay the Swedish VAT of 25%. The second rate, which is 0%, has all other countries I'm shipping too. This way, all orders shipped to outside the European Union is tax-free, and instead the customer pays import taxes.

DrByte:

Where did the "wholesale" option come from? What plugin added that to your site?
Ehh, I must have installed some wholesale plugin a long time ago. I'm not using this one. Can it affect the problems I'm having with the discount coupons? Is it worth a try to uninstall this plugin?

DrByte:

What other details would Ajeh need to know to set up her store to recreate this problem exactly as yours is?
You tell me :D. I hope my answer above regarding my tax classes can bring some clarification, but please let me know if you need more details!