PPCDATAFEED

How to add VAT to the prices in a product feed

A rule with Calculate: take price and multiply by 1.21 for 21% VAT. The result comes with 2 decimals, every product gets its price with VAT; your store is untouched.

Open in the app →About this feature

Google Shopping and most marketplaces in the EU want the price a shopper pays, VAT included. If your store exports prices without VAT, fix it in the feed.

  1. Open the data source, go to Rules and create a new rule - for example “Price with VAT”.
  2. Leave Conditions empty to change every product (or limit it, for example to one country's products).
  3. Under then pick the field price, choose Calculate and set it to take price, multiply by 1.21.
  4. Check the result in Changes preview, then Save Rule. Do the same for sale_price if you use it.
Rule “Price with VAT”: if All, then Take price and Calculate - take price, multiply by, 1.21

Example

Changes preview of the VAT rule, 48 of 48 products: price 107.69 for Trail Runner 2 Blue (89.00 before), 78.53 for City Sneaker White (64.90 before), 143.99 for Rain Jacket Blue XL (119.00 before)
  • price 89.00 → 107.69
  • price 64.90 → 78.53 - the result is already rounded to 2 decimals
  • sale_price stays as it is until you add the same rule for it
Other rates: 1.19 for 19%, 1.20 for 20%, 1.25 for 25%. Need a different number of decimals? Add a rule with Round number after this one.

Still stuck? Write to info@ppcdatafeed.com - we answer ourselves and can set it up with you.