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.

If you export Products with “Metafields” checkbox, then the values will try to be set firstly from the “mm-google-shopping” Metafields. If you want to gain export speed, especially for large stores with around million of Products, then set up your data so that you don’t have to rely on those Metafields – for the fastest export.

Column Example Source Field in Shopify
id
SKU-123

or

shopify_CA_123123123_234234234
Whichever is found first:

  1. Metafield: mm-google-shopping.id
  2. Product Variant SKU, or SKU if product doesn’t have variants
  3. The id in the format: shopify_<country>_<Product ID>_<Variant ID>

To switch to long ID format, ask Support.

title
Shoe for mountains - Red
Whichever is found first:

  1. Metafield: mm-google-shopping.title
  2. Product Title – Variant Title
  3. Product Title if variant has no title.
description
Full description of the product.
Whichever is found first:

  1. Metafield: mm-google-shopping.description
  2. Body HTML
link
https://yourstore.com/products/shoe-for-mountains?variant=123456
Whichever is found first:

  1. Metafield: mm-google-shopping.link
  2. URL to the Product variant page in your store.
image link
https://yourstore.com/images/1.jpg
Whichever is found first:

  1. Metafield: mm-google-shopping.image_link
  2. Product Variant image URL
additional image link
https://yourstore.com/images/2.jpg,
https:://yourstore.com/images/3.jpg
Whichever is found first:

  1. Metafield: mm-google-shopping.additional_image_link
  2. All product images, except the variant image because it is already in the image link.
availability
in stock
Whichever is found first:

  1. Metafield: mm-google-shopping.availability
  2. Will show “in stock” if variant inventory quantity >0, otherwise will show “out of 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.

Whichever is found first:

  1. Metafield: mm-google-shopping.google_product_category
  2. The correct category is guessed from your Shopify store data:
    • If your Product Type will match the 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
Whichever is found first:

  1. Metafield: mm-google-shopping.product_type
  2. Product Type
brand
Evermountain
Whichever is found first:

  1. Metafield: mm-google-shopping.brand
  2. Product Vendor
gtin
3234567890126
Whichever is found first:

  1. Metafield: mm-google-shopping.gtin
  2. Variant Barcode
mpn
SKU-123
Whichever is found first:

  1. Metafield: mm-google-shopping.mpn
  2. Variant SKU
condition
new
Whichever is found first:

  1. Metafield: mm-google-shopping.condition
  2. Constant “new”.
energy efficiency class
A+++
Whichever is found first:

  1. Metafield: mm-google-shopping.energy_efficiency_class
  2. 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
Whichever is found first:

  1. Metafield: mm-google-shopping.age_group
  2. 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
Whichever is found first:

  1. Metafield: mm-google-shopping.color
  2. 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
Whichever is found first:

  1. Metafield: mm-google-shopping.gender
  2. 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
Whichever is found first:

  1. Metafield: mm-google-shopping.material
  2. 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
Whichever is found first:

  1. Metafield: mm-google-shopping.pattern
  2. 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
Whichever is found first:

  1. Metafield: mm-google-shopping.size
  2. 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
Whichever is found first:

  1. Metafield: mm-google-shopping.size_type
  2. 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
Whichever is found first:

  1. Metafield: mm-google-shopping.size_system
  2. 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.
    1. If your variant Option Name is “Size system”, then the Option Value will be used as value;
    2. If any of product Tags will be like “size system:EU”, then “EU” will be taken from that.
item group id
23487623473
Whichever is found first:

  1. Metafield: mm-google-shopping.item_group_id
  2. Product ID
shipping weight
500 g
Whichever is found first:

  1. Metafield: mm-google-shopping.shipping_weight
  2. Product Variant weight expressed in grams.
custom_label_0
summer
Taken from Product Metafield “Metafield: mm-google-shopping.custom_label_0”.

Type: String (Unicode characters. Recommended: ASCII only), not case sensitive

Limits: 1–100 characters, up to 1,000 unique values account-wide for each custom label attribute (up to 5,000 labels total)

custom_label_1
best seller
Taken from Product Metafield “Metafield: mm-google-shopping.custom_label_1”

Type: String (Unicode characters. Recommended: ASCII only), not case sensitive

Limits: 1–100 characters, up to 1,000 unique values account-wide for each custom label attribute (up to 5,000 labels total)

custom_label_2
0-5
Taken from Product Metafield “Metafield: mm-google-shopping.custom_label_2”

Type: String (Unicode characters. Recommended: ASCII only), not case sensitive

Limits: 1–100 characters, up to 1,000 unique values account-wide for each custom label attribute (up to 5,000 labels total)

custom_label_3
low
Taken from Product Metafield “Metafield: mm-google-shopping.custom_label_3”

Type: String (Unicode characters. Recommended: ASCII only), not case sensitive

Limits: 1–100 characters, up to 1,000 unique values account-wide for each custom label attribute (up to 5,000 labels total)

custom_label_4
2000
Taken from Product Metafield “Metafield: mm-google-shopping.custom_label_4”

Type: String (Unicode characters. Recommended: ASCII only), not case sensitive

Limits: 1–100 characters, up to 1,000 unique values account-wide for each custom label attribute (up to 5,000 labels total)

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.
  • To make export run very fast for large stores, don’t rely on Metafields, but store those values in Tags and Options.
  • You can update the Metafields by importing with Excelify those values, as explained in this tutorial.
  • If any of this information is unclear, or you need it to be different, ask our Support, it’s quite easy customisable.