Product feed sending Pre Tax price to Merchant centre

[rashedethical]

Hi everyone,

Shopify is sending the 'excluding VAT' prices to Google Merchant Centre, and therefore Merchant Centre thinks the prices are lower than the ones on the website. I've received a notification from Google that my feed will be disapproved soon if I don't get this fixed.

Is there a way to tell the Shopify product feed to send the 'including VAT' prices, or to tell it to add on 20% to all product prices? I'm using the free Google Shopping plugin to the send the product data to Merchant Centre.  

Thankyou

[Salil1 · Accepted solution]

Hi @rashedethical 

One quick way to accomplish this is by adding a feed rule in Google Merchant Center: https://support.google.com/merchants/answer/7450276?hl=en

I am attaching a screenshot of the feed rule that can be used to achieve this behavior.

Feed rule in Google Merchant Center

[rashedethical]

Hi Salil,

Thankyou for this. I'll implement this and then hopefully the Google warning will go away.

Thankyou 

[EmmanuelFlossie]

Also make sure that the prices users see visually on the product landing page is including VAT.

Also make sure that the prices are inc VAT in the structured data and opengraph.

For structured data check using: https://search.google.com/test/rich-results

For opengraph check using view source  search for og:price

For the data feed, while the feed rule method is a solution, it does not work when you perform a two decimal rounding.

GMC does not have an option to round up or down, nor does it allow you to round to the closest .95 if that is what you have.

If you need these kind of functions, you can use: https://apps.shopify.com/multiple-google-shopping-feeds

[rashedethical]

Hi EmmanuelFlossie,

Thankyou for this. For the time being I've used the GMC method and have requested a review. If this does not work then I may look into using the Multiple Google Shopping Feeds p[lugin that you've mentioned. Thankyou

[MTNShop]

Hello -- I know some time has passed but I just wanted to see, did the GMC method end up working for you? I'm currently in this process, with inaccurate prices due to the VAT Tax issue, and have added the Multiplier to the feed but before I push it through I wanted to see if that was a long-term solution or a bandaid for a more permanent fix. Did you end up using a different method or stick with the GMC method? Thank you!

[brian_fedele]

Hi, I'm having similar problems. I have set up the feed rule in the GMC, but the JSON, obviously, is showing the "price" without taxes. How can I modify it? 

[EmmanuelFlossie]

For example use the tax line: https://shopify.dev/docs/api/liquid/objects/tax_line

Or for example, multiply the value by 1.2 if its 20% using filters https://www.shopify.com/partners/blog/shopify-filters

[brian_fedele]

where I can multiply the price to be shown VAT incl. in the .json file?

[EmmanuelFlossie]

Every theme is different, so check where you have added the structured data. It will not be a json file, but a liquid file.