Rouding prices to adjust for different VAT rates

Hi,

Different EU countries have different VAT rates, meaning that our products are priced slightly different in every country - and kind of awkward (i.e. € 31,88 instead of € 32,00).

If I remember correctly there is a functionality to ‘round’ these prices, but I can’t find it.

I understand that as a result our gross margins will be slightly different in every country. Is there a way to give Shopify ex VAT prices and let it round to the nearest number?

To clarify, I am aware you can also do this by creating new markets, but we are not looking to create a new market for every EU country.

Thank you.

Hi @Olaf2 You don’t need to create the new market or different markets but the round off functionality is available in Market settings only, Here are the steps to enable the same.

  1. From your Shopify admin, go to Settings > Markets.

  2. In the Other markets section, click Preferences.

  3. Select the Price rounding check box.

  4. Click Save.

Hopefully it will help you. If yes then Please don’t forget hit Like and Mark it as solution!

Best Regards

Sahil

Hi Sahil,

Thank you for your reply.

This option only works for prices after currency conversion. What I am looking for is a solution to align prices in euro’s across different countries.

To give an example:

  • The price of a product in our our home market (The Netherlands) is EUR 32,00 including 21% VAT.
  • The price for customers in Germany is € 31,47 including 19% VAT.
  • The price for customers in Ireland is € 32,53 including 23% VAT.

Is there a way to round these prices after VAT?

Hi @Olaf2 I got you so if you want this then there is a workaround from here you can achieve the same.

You need to include the VAT in the product price in Settings > Tax and duties

You can adjust the product price to account the inclusion of the VAT.

So if you have a product that is 100€ for example, the VAT is 20% then at the checkout the price will still be 100€ and you will have the info that 20€ from these 100€ are VAT.

Here is the live example what it will look like after you will enable this option.

Hopefully it will help you. If yes then Please don’t forget hit Like and Mark it as solution!

Best Regards

Sahil

We have this feature already switched on.

did you find a solution for this in the meantime?

I’m having the same issue

No - really disappointing.

Found a simple solution to this in a different thread, you need to change two settings:

  1. in Settings → Taxes you want “Include tax in prices” selected (you may already have this)

  2. In Settings → Markets → Preferences, you want “Include or exclude tax based on your customer’s country” deselected. This will ensure that no matter what country your customers are checking out from, the price is always same, but it will have a different tax amount included in it.

Hope this works for you!

Thanks for the reply, sadly this only works easily if you mainly sell in the EU, for my shop ~60% are outside of the EU and would therefore see 19% higher prices, reducing sales. Then I would again be at step one and need to adjust prices manually for customers outside of the EU.

True, but then you just need to maintain 2 sets of prices: EU and international via Markets settings. Though I understand, it might be a lot of work in case you sell many different products.

Hi, did you find a solution, selling from Belgium and having the same issue