Google has made changes to the Google Shopping Data Feed. The product category from the Google Shopping website is now required for the feed.
This article covers:
Google have over 5,400 categories that can be assigned to your products. We have created a import file so you can import the complete list into your site.
The import process will take about 10 minutes. Once imported, you will find the categories by going to Content > Google Product Categories.
The import file sets all these categories so they do not appear appear in the sitemap or in a category menu.
To assign a Google Product Category to a product, go to Products > View All Products and select a product. Scroll down to the Categorisation section. Then select Google Product Categories under Add to category and select each level of the category. Click on the Add to category button to add it to the list on the right. Save the changes.
You can also add the Google Product Categories to products in bulk using the Import Wizard or using the Neto API. The next section covers assigning categories to products in bulk.
Using the Import Wizard or an import template, you can add an Google Product Category any many products at the same time.
The import CSV file will need at least two columns. One for the product SKU and the second Category Full Path List (Google Product Categories).
You can find a full listing of the product categories by going to this page on the Google Merchant website and click on Taxonomy without numeric IDs in Plain Text (.txt). This file has a complete list of the all the categories. You can copy the relevant category and paste it next to the correct SKU in the import file you are creating.
When importing, the map the SKU to SKU* and the Google Product Category to Category Full Path List (Google Product Categories).
For more information in using the Import Wizard check out:
To pass the Google Product Category for each product in the Google Shopping Data Feed will require two changes to the export template. You will need to add a column header and a tag that will be replaced with category when exported.
To make changes to the data feed, you will need a text editor like TextEdit on the Mac or Notepad in Windows.
To add the column, go to Marketing > Comparison Shopping Feeds and select Google Shopping Data Feed. Scroll down to the FILE HEADER field. Click on the field and press Command-A (Mac) or Ctrl-A (Windows) to select all the text in the field. Copy the contents and paste it into your text editor. Click at the end of the line and press the tab key and enter google product category. Select all text in the text editor. Copy and paste it into the field under FILE HEADER. Make sure it replaces the text already in the field.
To add the tag, scroll down to FILE BODY - body and click at the end of the text line. You may need to scroll to the right to see the end of the line. Then click on the drop down menu next to Insert Data Tag and select Category Table (Google Product Categories) and in the next drop down select Google Product Categories Full Path List and click Insert.
Select all the text in the field. Copy the contents and paste it into your text editor. Click just before the square bracket for the tag you just added and press the tab key. Then select the text, copy and paste it back into the field under FILE BODY - body. Make sure it replaces the text already in the field.
Save the changes to the template.
Next you will need to test the data feed to make sure the changes are correct.