Google Shopping Data Feed Export from Shopify

You can export your store data as the Google Shopping Data Feed format – tab delimited .txt file. To do that, choose the “Google Shopping Data Feed” in the dropdown next to Export button.

Exported Columns

The exported fields will match Google Shopping Data Feed specification, with some special ways how to fill in fields that are not normally available in Shopify.

Each column will have described the source – from which Shopify field the data is being taken, and how you can impact the values.

Column Example Source Field in Shopify
id
SKU-123
Product Variant SKU, or SKU if product doesn’t have variants.
title
Shoe for mountains - Red
Product Title – Variant Title, or just Product Title if variant has no title.
description
Full description of the product.
Body HTML
link
https://yourstore.com/products/shoe-for-mountains
URL to the Product page in your store.
image link
https://yourstore.com/images/1.jpg
Product Variant image URL
additional image link
https://yourstore.com/images/2.jpg,
https:://yourstore.com/images/3.jpg
All product images, except the variant image, because it is already in image link.
availability
in stock
It will always show that product is in stock.
price
45.99 USD
Product variant price with your store currency. If this variant has compare at price, then price is set to compare at price.
sale price
30.99 USD
Product price, if variant has compare at price. Empty, if variant doesn’t have compare at price.
google product category
Apparel & Accessories > Shoes
Google requires this field to be filled in according to Google Product Taxonomy. The correct category is guessed from your Shopify store data.

  • If your Product Type will match deepest level of that classifier, then that will be used. In this example, if your Product Type will be “Shoes”, then the Google product category will be “Apparel & Accessories > Shoes”.
  • If any of your Product Tags will match the deepest level, then that will be used. In this example, if any of product tags will be “Shoes”, then the Google product category will be “Apparel & Accessories > Shoes”.
product type
Shoes
Product Type
brand
Evermountain
Product Vendor
gtin
3234567890126
Variant Barcode
mpn
SKU-123
Variant SKU
condition
new
Always “new”.
energy efficiency class
A+++
Guessed from different fields the following way. Big or small letters don’t matter. Also _ (underscore) can be used instead of space in the name.

  • If your variant Option Name is “Energy Efficiency Class”, then the Option Value will be used as value.
  • If any of product Tags will be like “Energy Efficiency Class:A+++”, then “A+++” will be taken from that.
age group
adult
Guessed from different fields the following way. Big or small letters don’t matter. Also _ (underscore) can be used instead of space in the name.

  • If your variant Option Name is “Age Group”, then the Option Value will be used as value.
  • If any of product Tags will be like “age_group:infant”, then “infant” will be taken from that.
color
red
Guessed from different fields the following way. Big or small letters don’t matter.

  • If your variant Option Name is “Color”, then the Option Value will be used as value.
  • If any of product Tags will be like “color:green”, then “green” will be taken from that.
gender
female
Guessed from different fields the following way. Big or small letters don’t matter.

  • If your variant Option Name is “Gender”, then the Option Value will be used as value.
  • If any of product Tags will be like “gender:male”, then “male” will be taken from that.
material
Nano-fiber
Guessed from different fields the following way. Big or small letters don’t matter.

  • If your variant Option Name is “Material”, then the Option Value will be used as value.
  • If any of product Tags will be like “material:gold”, then “gold” will be taken from that.
pattern
Waves
Guessed from different fields the following way. Big or small letters don’t matter.

  • If your variant Option Name is “Pattern”, then the Option Value will be used as value.
  • If any of product Tags will be like “pattern:dots”, then “dots” will be taken from that.
size
10½ M
Guessed from different fields the following way. Big or small letters don’t matter.

  • If your variant Option Name is “Size”, then the Option Value will be used as value.
  • If any of product Tags will be like “size:XS”, then “XS” will be taken from that.
size type
petite
Guessed from different fields the following way. Big or small letters don’t matter.  Also _ (underscore) can be used instead of space in the name.

  • If your variant Option Name is “Size type”, then the Option Value will be used as value.
  • If any of product Tags will be like “size type:regular”, then “regular” will be taken from that.
size system
US
Guessed from different fields the following way. Big or small letters don’t matter. Also _ (underscore) can be used instead of space in the name.

  • If your variant Option Name is “Size system”, then the Option Value will be used as value.
  • If any of product Tags will be like “size system:EU”, then “EU” will be taken from that.
item group id
23487623473
Product ID
shipping weight
500 g
Product Variant weight expressed in grams.

Good To Know

  • You don’t have to have all data filled in. If it will not find the appropriate value, it will just leave it empty.
  • To decide, what values are needed in which cases, please, consult the Google Shopping Data Feed format specification – there are detailed descriptions for each fields, and their allowed values.
  • To export only a portion of Products, you can apply product filters by pressing the filter button in the products row.
  • If any of this information is unclear, or you need it to be different, ask our Support, it’s quite easy customisable.