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 “Variant Metafields” and/or “Metafields” checkbox, then the values will try to be set firstly from the “mm-google-shopping” Variant Metafields, then from the Metafields – whichever exist first.

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. Variant Metafield: mm-google-shopping.google-id
  2. Metafield: mm-google-shopping.google-id
  3. Product Variant SKU, or SKU if product doesn’t have variants
SKU-123

An alternative is to ask Excelify to generate id is following long format:

shopify_<country>_<Product ID>_<Variant ID>

For example:

shopify_CA_123123123_234234234

To switch to long ID format, ask Support.

title Whichever is found first:

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

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

  1. Variant Metafield: mm-google-shopping.link
  2. Metafield: mm-google-shopping.link
  3. 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. Variant Metafield: mm-google-shopping.image_link
  2. Metafield: mm-google-shopping.image_link
  3. Product Variant image URL
https://yourstore.com/images/1.jpg
additional image link Whichever is found first:

  1. Variant Metafield: mm-google-shopping.additional_image_link
  2. Metafield: mm-google-shopping.additional_image_link
  3. 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. Variant Metafield: mm-google-shopping.availability
  2. Metafield: mm-google-shopping.availability
  3. 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. Variant Metafield: mm-google-shopping.google_product_category
  2. Metafield: mm-google-shopping.google_product_category
  3. 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. Variant Metafield: mm-google-shopping.product_type
  2. Metafield: mm-google-shopping.product_type
  3. Product Type
Shoes
brand Whichever is found first:

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

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

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

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

  1. Variant Metafield: mm-google-shopping.energy_efficiency_class
  2. Metafield: mm-google-shopping.energy_efficiency_class
  3. 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. Variant Metafield: mm-google-shopping.age_group
  2. Metafield: mm-google-shopping.age_group
  3. 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. Variant Metafield: mm-google-shopping.color
  2. Metafield: mm-google-shopping.color
  3. 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. Variant Metafield: mm-google-shopping.gender
  2. Metafield: mm-google-shopping.gender
  3. 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. Variant Metafield: mm-google-shopping.material
  2. Metafield: mm-google-shopping.material
  3. 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. Variant Metafield: mm-google-shopping.pattern
  2. Metafield: mm-google-shopping.pattern
  3. 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. Variant Metafield: mm-google-shopping.size
  2. Metafield: mm-google-shopping.size
  3. 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. Variant Metafield: mm-google-shopping.size_type
  2. Metafield: mm-google-shopping.size_type
  3. 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. Variant Metafield: mm-google-shopping.size_system
  2. Metafield: mm-google-shopping.size_system
  3. 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. Variant Metafield: mm-google-shopping.item_group_id
  2. Metafield: mm-google-shopping.item_group_id
  3. Product ID
23487623473
shipping weight Whichever is found first:

  1. Variant Metafield: mm-google-shopping.shipping_weight
  2. Metafield: mm-google-shopping.shipping_weight
  3. Product Variant weight expressed in grams.
500 g
custom_label_0 Whichever is found first:

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

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

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

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

  1. Variant Metafield: mm-google-shopping.custom_label_4
  2. 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 Variant Metafields or Metafields, but store those values in Tags and Options.
  • You can update the Variant Metafields and 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.