Get Excelify now
Get Excelify now

Google Shopping Data Feed

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 Source Field in Shopify
id Whichever is found first:

  1. Metafield: mm-google-shopping.google-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.

SKU-123

or

shopify_CA_123123123_234234234
title Whichever is found first:

  1. Metafield: mm-google-shopping.title
  2. Product Title – Variant Title
  3. Product Title if variant has no title.
Shoe for mountains - Red
description Whichever is found first:

  1. Metafield: mm-google-shopping.description
  2. Body HTML
Full description of the product.
link >Whichever is found first:

  1. Metafield: mm-google-shopping.link
  2. URL to the Product variant page in your store.
https://yourstore.com/products/shoe-for-mountains?variant=123456
image link Whichever is found first:

  1. Metafield: mm-google-shopping.image_link
  2. Product Variant image URL
https://yourstore.com/images/1.jpg
additional image link 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.
https://yourstore.com/images/2.jpg, https:://yourstore.com/images/3.jpg
availability 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”.
in stock
price Product variant price with your store currency. If this variant has compare at price, then price is set to compare at price.

45.99 USD
sale price Product price, if variant has compare at price. Empty, if variant doesn’t have compare at price.

30.99 USD
google product category 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”.
Apparel & Accessories > Shoes
product type Whichever is found first:

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

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

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

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

  1. Metafield: mm-google-shopping.condition
  2. Constant “new”.
new
energy efficiency class 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.
A+++
age group 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.
adult
color 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.
red
gender 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.
female
material 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.
Nano-fiber
pattern 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.
Waves
size 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.
10½ M
size type 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.
petite
size system 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.
US
item group id Whichever is found first:

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

  1. Metafield: mm-google-shopping.shipping_weight
  2. Product Variant weight expressed in grams.
500 g
custom_label_0 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)

summer
custom_label_1 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)

best seller
custom_label_2 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)

0-5
custom_label_3 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)

low
custom_label_4
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)

2000

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 Metafields tutorial.
  • If any of this information is unclear, or you need it to be different, ask our Support, it’s quite easy customisable.