SafeSale · Blog

Shopify sales when prices include VAT: what 25% off takes off

Your prices include VAT and you run 25% off. What happens to the tax, why amount-off is smaller than it looks, and why .99 endings break in other markets.

A shop in Cologne sells a jacket for 119.00. The price on the product page is the price the customer pays, VAT included, because that is how prices are shown to consumers in Germany and in most of Europe. The owner sets up 25% off for Black Friday week and then stops at a question that American tutorials never cover: 25% off what? The 119.00 on the page, or the 100.00 the shop keeps after 19% VAT?

The short answer is that for a percentage it does not matter, and for everything else it does. This post walks through how SafeSale treats tax-inclusive prices, where the numbers come out differently from what you expected, and what to check if you sell to more than one country.

What Shopify stores, and what SafeSale reads

A variant in Shopify has one price field. Whether that number includes tax is not a property of the product. It is a store setting, under Settings > Taxes and duties, and Shopify's page on including taxes in prices gives the formula it uses once the setting is on: tax = (rate x price) / (1 + rate). For the jacket that is 19.00 of tax inside 119.00.

SafeSale reads the variant price and the compare-at price, calculates the sale price from them, and writes two fields back. It has no tax setting and does not look at your tax rates. So the rule is simple: the discount comes off the number you typed into Shopify. If that number includes VAT, so does the sale price.

Percentage off: the tax shrinks with the price

Take 25% off 119.00 and the jacket costs 89.25. Run Shopify's formula on the new price and you get 14.25 of tax and 75.00 net. Before the sale it was 19.00 and 100.00. Every part of the price went down by exactly a quarter.

Customer paysVAT inside (19%)You keep
Regular price119.0019.00100.00
25% off89.2514.2575.00
20.00 off99.0015.8183.19

This is why the question in the first paragraph has no wrong answer for a percentage sale. 25% off gross and 25% off net are the same sale. The customer sees 25%, your margin calculation uses 25%, and the percentage SafeSale shows in the preview is the one that will appear on a sale badge.

Amount off: part of what you give away was never yours

The third row of the table is where people get surprised, usually in a good way. An amount-off rule of 20.00 takes the jacket to 99.00. The customer saves 20.00. You do not lose 20.00. Your net goes from 100.00 to 83.19, a drop of 16.81, and the other 3.19 is VAT you no longer collect and no longer owe.

If you plan a sale in a spreadsheet using net prices and then enter the amounts into a store with tax-inclusive prices, the sale will be shallower than planned. A 20.00 net reduction on this jacket needs 23.80 off the shelf price. The same goes for fixed-price rules: a fixed price of 79.00 is 79.00 at the till, which is 66.39 to you.

The safety settings work on the stored price as well. The confirmation threshold (50% by default) and the hard cap (90% by default) compare the old and new variant price, and since tax is proportional, the percentage is the same gross or net. You do not need a separate set of thresholds for a VAT store. The post on the two thresholds explains what each one blocks.

Rounding to .99 happens on the price with tax

SafeSale can round sale prices down to end in .99 or .95. In a tax-inclusive store that is exactly what you want, because the rounded number is the one on the price tag. 89.25 becomes 88.99, the customer sees a tidy price, and the net works out to 74.78.

In a store whose prices exclude tax, the same rounding gives a tidy net price and an untidy total. A US store rounds to 88.99, and a shopper in a state with 7.25% sales tax pays 95.44 at checkout. Nobody minds, because American shoppers expect tax to be added. It is worth knowing which of the two stores you are before you pick a rounding rule. Our rounding post has the rules in detail.

Selling abroad: the stored price is not the shown price

Here is the part that catches shops out. If you sell to several countries, Shopify can adjust tax per market. Its page on dynamic tax-inclusive pricing describes the mechanism: Shopify takes your home tax rate out of the price, then applies the rate of the shopper's region if that region expects tax-inclusive prices, or shows the net price if it does not.

Apply that to the jacket on sale at 88.99 with a home rate of 19%:

  • Germany (19%). 88.99. The price you rounded.
  • France (20%). Net 74.78 plus 20% is about 89.74.
  • Denmark (25%). About 93.48.
  • United States. About 74.78, with any state tax added at checkout.

Three things follow. The .99 ending survives only at home. The discount percentage is still 25% (and a little more, after rounding) in every market, because both the old and the new price were adjusted the same way. And the amount saved differs per country, so an email that says "save 30" is only right for one of them. Say the percentage in marketing that goes to several markets.

If the endings matter abroad, Shopify Markets has its own price rounding for converted prices, and a market can carry fixed prices per product. A fixed market price is not touched by a rewrite of the base price, which the post on markets and currencies covers.

Rewrite mode and discount mode give the same tax

SafeSale runs a sale either by rewriting prices or by creating one automatic discount. For tax, the two end in the same place. Shopify calculates tax on what the customer pays for the line, so a jacket sold at 89.25 carries 14.25 of VAT whether 89.25 was the variant price or 119.00 less a 29.75 discount.

What differs is the paperwork. In rewrite mode the order line reads 89.25 and there is no discount line. In discount mode the line reads 119.00 with a discount of 29.75 under it. Accountants in some countries prefer to see the discount stated; others want the invoice to match the shelf price. Ask yours before the sale and not after four hundred orders. The comparison of the two modes lists the other differences.

Two edge cases

Tax-exempt customers. Shopify's help page is blunt about this one: if a customer is marked tax exempt and you use tax-included pricing, they are still charged the full listed price. During a sale that means the exempt customer pays 89.25 like everyone else. This is Shopify behaviour, not something a sale app changes. If you sell to businesses that should pay net prices, that is a job for B2B catalogs.

Products that do not charge tax. A gift card or a zero-rated book in a tax-inclusive store has a price with no tax in it. 25% off is still 25% off. Nothing special happens, but your blended margin for the sale will not match a calculation that assumed 19% in every price.

Before you press publish

  1. Open Settings > Taxes and duties and confirm which kind of store you are. People who inherited a store are sometimes wrong about this.
  2. If the sale is amount-off or fixed-price, convert your planned net figures to shelf prices first.
  3. In the SafeSale preview, read the new price column as the price a home-market customer will pay.
  4. After the sale starts, open one product from each market you sell in, using the country selector on your storefront, and look at the price and the struck-through price.
  5. Place a test order at home and check the tax line on it against the formula.

We build a pricing tool and are not tax advisers. Nothing here tells you what rate applies to your goods or how to present a price reduction under your country's rules. What it does tell you is which number the software will change, so that the conversation with your accountant is about tax and not about arithmetic.

Frequently asked questions

Does SafeSale take the discount off the price with VAT or without it?

Off the price stored on the variant, whichever kind that is. If your store is set to include tax in prices, the variant price is the gross price and the discount is calculated on it. If your prices exclude tax, the discount is calculated on the net price and Shopify adds tax to the result at checkout. SafeSale has no tax setting of its own and never reads your tax rates.

Is 25% off a tax-inclusive price the same as 25% off the net price?

Yes. VAT is a fixed proportion of the price, so cutting the gross price by a quarter cuts the net price and the tax by a quarter too. That is only true for percentage rules. An amount-off rule of 20.00 on a tax-inclusive price lowers your net revenue by less than 20.00, because part of the 20.00 was tax.

Why do my sale prices not end in .99 for shoppers in other countries?

Because Shopify recalculates them. With tax-inclusive pricing set up per market, Shopify removes your home tax rate from the stored price and applies the shopper's local rate. SafeSale rounds the stored price to .99, and the recalculated price for a country with a different rate lands wherever the arithmetic puts it. Price rounding rules in Markets can tidy converted prices; check one product in each market after the sale starts.

Does the sale change how much tax I report?

It changes the amount, not the method. Shopify works out the tax on each order from the price the customer paid, so a lower sale price means less tax collected on that order. In price-rewrite mode the order shows the sale price as the line price; in automatic-discount mode it shows the full price and a discount line. Both arrive at the same tax for the same final price.