Creating a Google Shopping feed with Magento Product Feed extension

Amasty Product Feed Extension is a powerful and flexible solution for creating product feeds. The extension lets you create feeds for almost any feed processor which accepts XML or CSV feeds.

This article will guide you through creating a product feed for Google Shopping.

For doing that, you’ll need:

  1. Magento 1.4 and above
  2. Amasty Product Feed extension installed
  3. A Google account

Say, we have a Magento copy running on our server, and we have installed the Product Feed extension, so we’ll skip these details.

I used Product Feed 3.2.1 and Magento CE 1.9.1 when writing this article, so please take into consideration the fact that the screenshots may be slightly different if you use other versions of the software.

Briefing: what Google Shopping and Google Merchant center are

Google Merchant Center is a tool that helps you upload your store and product data to Google and make it available to Google Shopping and other Google services.

Google Shopping allows shoppers to quickly and easily find your product listings on Google by attracting more potential buyers and reaching shoppers while they are googling desired items. Also, it helps you control your product information. With Google Shopping, you can maintain the accuracy and freshness of your product information so your customers get what they want.

Google Shopping is currently available in the US, UK, Australia, Germany, France, Japan, Italy, the Netherlands, Brazil, Spain, Switzerland, and the Czech Republic.

Step 1. Creating a feed profile

Go to Catalog > Product Feeds > Feeds
Creating a feed profile

We created feed templates for some feed processors for your convenience, for Google Shopping as well, that’s why it takes just a couple of clicks to create a feed profile.
Create a feed profile

That’s how the feed profile looks like right after it has been created:
a created feed profile

It could be enough, but Google has certain requirements for categories naming. So, if we want our products to appear on Google Shopping, we should comply with these requirements.

Step 2. Setting categories for Google

Product Feed can change values of any product attribute. There are many ways you can make use of this feature, but in this article we’ll show an example of changing category name.

Let’s go to Custom Fields:
Go to custom fields

 

Create a new custom field:
Create a new custom field

 

Give it a desired name and set Code to “google_product_category”.

Note: in fact, you can add any Code you like.

Go to Transform tab and create a new condition for Category:
Create a new condition for category

Replace your shop’s categories with suitable ones from Google Taxonomy. For example, Shirts category on our test Magento shop suits the Apparel & Accessories > Clothing > Shirts & Tops category:
Google taxonomy choice

 

Repeat for all of your categories:
Repeat for all categories

Save and go to the feed profile again.

Now, we have this google_product_category field.
Google product category field

This particular field will be replaced by our newly set categories. It is done easily: click the field name (google_product_category in our case), and it will be added to feed editor below:
Add field to field aditor

Now, select Type = Custom Field, and Value is the name of the custom field with changed categories, Format = HTML Escape, as category names have special characters. Press Update, and google_product_category value will be replaced:
Replace custom field value

 

Step 3. Generating the feed file

Go to Feeds, click Generate for the selected Feed profile:
Generate feed

 

The generation process may take some time, especially if you have a significant number of products on your Magento store. Afterwards, we can download the generated file:
Download a generated product feed

Let’s save it – we’ll need the file later.

Step 4. Configuring Google Merchant account

Go to your Google Merchant account, choose Feeds menu and add a new Data Feed:
Add a new data feed

Here’s how the settings for my test case look like:
New data feed settings

 

New data feed settings

These settings are shown as an example, and you don’t have to copy the data.

Now, it’s time to upload the feed file:
Upload the Google product feed file

Tada. If your feed file is in order, it will be successfully imported to your Google Merchant. But it happens rarely because it’s time for…

Step 5. Getting rid of errors

Google has certain requirements for each product type. For example, if we’re trying to import apparel items, we must specify some required attributes, such as color, size, age group, and more. You can get details about these requirements here.

Feel free to browse through your feed errors in your Google Merchant account:
Google product feed errors

You can add attributes to your feed profile using the feed editor. For instance, if you need a Color attribute and you have it as an attribute in your Magento store, add it as well.
Color attribute

Act accordingly until all the errors are gone, and your file will be submitted successfully, and the products will appear in search.

Of course, each shop and product type have peculiarities that can’t be covered in a single article. My universal advice to all the shop owners is: carefully read error messages, they offer all the necessary information for their correction.
Carefully read error messages

I do hope this article was helpful for you and will be happy to answer questions. Do you use Google product feeds for boosting your business?