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.
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:
Note that there needs to be a space before the unit (eg “ kg” and not “kg”).
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:
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 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:
- Make sure that your simple products (variants) are downloaded by DataFeedWatch. We will automatically add all attributes from your configurable products.
- 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.
DataFeedWatch is data feed optimization and management software that enables merchants on Magento, Shopify, Volusion, 3Dcart, 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.