How can I deduct tax from the custom prices?
Apply when you tick the option "Include sales tax in product price and shipping rate"
Since you tick "include sales tax in the product price", the original price set in Admin is tax-included.
If you want to set up a B2B Pricing based on the product price with our tax, here’s a step-by-step guide to calculate and set up that pricing.
Step 1: Understanding the Formula
Assume that:
P = Price excluding tax
O = Price including tax (original price).
The relationship between the net price and the gross price is:
(1+VAT%)×P=O
Where VAT% is the VAT (Value Added Tax) percentage applied.
Step 2: Calculate the discount percentage
If the goal is to have the final price appear as X% of the net price (i.e., the price after discount), you’ll need to apply a discount percentage on the product price.
The formula for calculating the CP discount percentage to achieve the desired price can be derived as:
CP_discount_percent= (X+VAT)/(1+VAT%) ​
Example Calculation
For example, if the VAT rate is 19% and a discount of 50% from excluding tax price, the discount percentage that needs to be applied to achieve the desired CP Price is:
CP_discount_percent= (50+19)/(1+19%) = 57.98%
=> So 57,98% is the discount percentage you should fill in the Custom Pricing/Price list rule
​
Note:
If you sell products to multiple markets, you should calculate and set different rules for different markets.
The tax settings for markets also need to be synchronized in the calculations
Last updated
Was this helpful?