Google Shopping Data Feed for Shopify shops – Part 2: Optional Fields

Posted on February 3, 2014 by Jacques van der Wilt

Shopify Optional Fields in Google Shopping

Shopify customers, who have read the first part of this post probably already know how to map the required fields to create an excellent data feed for Google Shopping.

Today we are going to give you some additional advice about mapping the Optional Fields in your Shopify Shop. They may be underrated but we will show you that they might be quite useful.

 

Shipping weight

Your shipping cost in Google Shopping may be dependent on the weight or price of your products. Hence, it is a good idea to provide the shipping weight field in your data feed.

Shipping weight can be renamed from the Shopify field – grams. You need to be aware of the fact, that Google requires not only a numerical value but also a weight unit, while this attribute in Shopify only provides a numerical value. You can fix it using DataFeedWatch. The only thing you need to do is add a suffix to each value. Note that a weight unit should be preceded by a space. Hence, you need to  enter “ g” instead of “g”. Below you can see an example of mapping shipping weight from grams:


Shopify Shipping Weight

 

Get our guide to Double your Google Shopping Sales in an hour

 

 

Product type

This field can be really useful when you create your product targets in your AdWords account since it enables you to provide your own classification of products.

Product type can be mapped from your Shopify field – product type.

 

Adwords labels

This is another attribute that can be useful when you create your product targets. It is important that Adwords labels can hold multiple values. In this way you can tag your products with multiple labels.

You can use many Shopify fields to map your Adwords labels. You only need to be aware of the fact, that your products should be grouped in an arbitrary way. For example you can use the color option or the size option field.

 

Item group id

Shopify merchants who sell many color/size/material variants of the same products should be aware of the fact that Google requires the item group id field which has to be the same for all variants of one product.

The good news is that item group id can be simply renamed from your Shopify field – id.

 

Sale price and sale price effective date

These fields are really useful when you have your products on sale. Note, that the sale price will be shown as the current price in Google Shopping search results when the sale is active.

Sale price effective date allows you to accurately specify the period when your sale is effective.

Providing these fields in the Google Shopping data feed may be a bit tricky for Shopify customers. This is due to the fact that there is no exact equivalent of a sale price in Shopify. Instead there is a filed called compare at price. When you add this field in Shopify a regular price field becomes a sale price.


Compare Price with Shopify Shops Data Feed

 

To reflect this in your Google feed you first need to map Google price field from compare at price if it is provided or from a regular Shopify price in case compare at price is empty.

A mapping covering all the conditions mentioned above could look like this:

 

Product Status Shopify Data Feed

 

Next you can simply map sale price from price.

When it comes to sale price effective date there is no suitable Shopify field to map if from.

Sale price will work without sale price effective date but if you wish to specify exact times when your products are on sale you can do this by adding a static value.

Note, that Google requires the specific format of your sale price effective date: YYYY-MM-DDTHH:MM-TZ/ YYYY-MM-DDTHH:MM-TZ. The first date is a date when the promotion starts and the second when it ends. TZ signifies a time zone.

For example if you would like to set a sale price time between 10:00 and 16:00 of UTC-8 Time Zone an example of mapping covering all the conditions mentioned above could look like this:


Shopify Sale Time

 

 
Shopify Merchants can use DataFeedWatch to optimize data feeds for:

  1. Google
  2. Amazon Product Ads
  3. Become.com
  4. Bing
  5. Nextag
  6. Pricegrabber
  7. Pronto
  8. Shopping.com
  9. Shopzilla
  10. TheFind
  11. and many more

 

Download

 

About DataFeedWatch

DataFeedWatch is data feed optimization and management software that enables merchants on Magento, Shopify, Volusion3Dcart, BigCommerce, WooCommerce, OpenCart, VersaCommerce, and numerous other shopping carts to optimize their product data feed for Google and 1000+ Shopping Channels in 50 countries. The most intuitive and easy data feed management and optimization tool on the market. Free trial and live demo available.

Posted in: Google Shopping, Shopping Carts

Written by Jacques van der Wilt

Jacques van der Wilt, Founder & CEO at DataFeedWatch is an eCommerce industry leader specialized in online marketing.
Find me on:

Related posts

Shopify customers, who have read the first part of this post probably already know how to map the required fields to create an excellent data feed ...
Shopify customers, who have read the first part of this post probably already know how to map the required fields to create an excellent data feed ...
Shopify customers, who have read the first part of this post probably already know how to map the required fields to create an excellent data feed ...
Shopify customers, who have read the first part of this post probably already know how to map the required fields to create an excellent data feed ...

Follow Us!

Subscribe to Email Updates