cancel
Showing results for 
Search instead for 
Did you mean: 

Discount coupon applied to sum of VAT EXCLUDED prices

   Did you know you can see the translated content as per your choice?

Translation is in progress. Please check again after few minutes.

Discount coupon applied to sum of VAT EXCLUDED prices

Hello everyone and thanks for reading me.

 

I have the current issue: I am trying to setup a discount coupon so to give €5 off any order of €30 and above,

current setup:

 

Cart Price Rule Condition

-> Subtotal equals or greater than 30

 

Cart Price Rule Action

-> Apply Fixed amount discount for whole cart

-> Discount amount: 5

-> Maximum Qty Discount is Applied To: 0
-> Discount Qty Step (Buy X): 0
-> Apply to Shipping Amount: No

-> Free Shipping: No

-> Stop further rules processing: Yes

 

System -> Configuration -> Sales -> Taxes

-> Tax Calculation Method Based On: Total
-> Tax Calculation Based On: Store Origin
-> Catalog Prices: Excluding Tax
-> Shipping Prices: Excluding Tax

-> Apply Customer Tax: After Discount
-> Apply Discount On Prices: Including Tax

-> Apply Tax On: Custom price if available
-> Enable Cross Border Trade: No

 

With this setup, the discount is applied only when the sum of prices EXCLUDING VAT is 30 or more

 

Example 1: 3 bottles of wine = 3 * 9 = 27 (price excluding VAT)

VAT is 22% -> 27 + 5.94 = 32.94 (price including VAT)

In this case the discount is NOT applied

 

Example 2: 4 bottles of wine = 4 * 9 = 36 (price excluding VAT)

VAT is 22% -> 36 + 7.92 = 43.92 (price including VAT)

in this case the discount IS applied

 

I would like to apply the discount on the final price VAT included of €30, no matter what products and what tax class they are in (since we have 3 tax classes which alternate depending of destination address).

ATM, with the configuration described above, this does not happen

 

Thanks very much for any support you can give me

 

GV