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

Magento Optional Fields in Google Shopping

In the first part of this article we described how to map the required fields for your Google Shopping data feed from Magento. In this part we will focus on the Optional Fields; even if they are not required, they can be very useful.

Shipping weight in Magento Shops

This attribute is especially useful if the shipping cost of your products depends on the weight. In that case you will need to create a weight-based shipping rates table in your Google Merchant Center Account.

Shipping weight will be used to calculate the shipping cost of the item automatically.


Google Merchant Center Shipping in Magento Shops

You can rename shipping weight from Magento field – weight. A small issue that remains to be solved, is that Google requires a weight unit (10 kg) while the weight attribute in Magento Shops is solely numeric (10).

To fix this, you will need to append a weight unit at the end of each value. If you are using data feed software like ours it can be easily done by clicking Edit Value and choosing “add suffix” from the actions dropdown:

Shipping Weight and Suffix in New Rules in DataFeedwatch

 Note that there needs to be a space before the unit (eg “ kg” and not “kg”).

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


Sale price and sale price effective date

These attributes can be used for products on sale. When a sale is active, the sale price will be shown as the current price in Google Shopping search results.

Sale price can be renamed from the Magento field – special price.

Sale price effective date allows you to accurately define times during which your sale is effective, while also communicating to Google that you have a sale.

The format is start and end dates separated by a forward slash (/): YYYY-MM-DDTHH:MM-TZ/ YYYY-MM-DDTHH:MM-TZ where TZ is a time zone. For example 2011-03-01T13:00-0800/2011-03-11T15:30-0800.

Sale price effective date can be created by combining two Magento fields – special from date and special to date. Due to format differences some additional rules need to be applied.

For example if you would like to set a sale price time between 10:00 and 16:00 of UTC-8 Time Zone the required set of rule would look like this: 

Magento Shops Sales Price in DataFeedWatch

Product type

This attribute is similar to google product categories but you can provide your own classification. It can also be used for creating product targets in your Adwords account.

Product type can be renamed from Magento field – category path.

Custom labels

Custom Labels on Google Shopping are basically offering you the opportunity to create groups of products based on conditions you are able to set your self. You can create up to 5 custom label fields and define your own values for every custom label.

Adding these values for every individual product allows you to segment the biddings on your Product Listing Ad’s within your Shopping Campaigns

Custom labels can be mapped from any Magento field. Common examples are Gross Margin, Season, Best Sellers, On sale, etc.

Item group id

In Magento you create one configurable product that contains all attributes that the variant-products have in common: category, description, etc).

You use this as a template to create simple products, being variants of this configurable product, and you provide values for the attributes that differentiate them (color, price, size etc).

So if you sell an office chair that comes in green and blue, you really create 3 products: one configurable product and two simple products, being variants of this configurable product.

Google wants you to upload each variant as a separate product. If you have variants, you should keep two things in mind:

  1. Make sure that your simple products (variants) are downloaded by DataFeedWatch. We will automatically add all attributes from your configurable products.  
  2. All variants of the same product must share the same item group id. The Item group id can be renamed from Magento field – parent id.

Read more about parents and variants here.



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:


Made with   by  DataFeedWatch

Write for Us