Google Local Product Inventory tab-delimited feed

Highlighted
New Member
2 0 0

I have my Shopify products feeding by API to Google Merchant Center, but I would really like to sign up for the Local Inventory Ads. 

To do so, I need a tab-delimited file with just a few product attributes included, to meet the qualifications for a Local Product Inventory feed. https://support.google.com/merchants/answer/3061342?hl=en&ref_topic=3052707

I have reviewed the process for creating a custom xml file but specificallly for the Local Product Inventory feed, Google requires it to be txt or tab-delimited. I have also found a github article for creating a tab-delimited file, but I don't know how to map the Shopify-defined attribute names to fit Google's requirements. More specifically I would need 

Columns:

store_code, populated by a static number

itemid, populated with ID

price populated with price
quantity populated with inventory-quantity
availability populated with stock_status

Then I need this file as a feed updated every 24 hours.

Thanks for your assistance.

 

0 Likes
Highlighted
Shopify Partner
223 6 38

The issue you will find is getting the item ID. Whith shopify it uses the variant ID and the parent ID.

So you will see something like this shopify_GB_0316546131123_13216546461

I have looked around in Shopify and can't see an easy way to get these values when you export the product data.

You could try and download data from Google Merchant, see if there is anything available.

Hope it helps.

Google Shopping Specialist - Data Feed Managment Tool
0 Likes
Highlighted
New Member
2 0 0

No I'm not having a hard time with finding the specific Shopify data tags, I can find those from the xml feed. What I'm hoping to find out is how to set up the code for the actual liquid file to create a tab delimited file with this information in it, with the column headers redefined with Google's tags. I see instructions on creating an xml file but not a tab delimited one. Also I need to know how to set it up so it updates every 24 hours.

Jenny

0 Likes