Updating Google Product Search Information

Updating the required content for Google Product Search can be a tedious task. Google may require almost a dozen items of additional information per item in order to list the item in their product search engine. There is a more efficient way of updating information than clicking on each item and updating the Google Product Search tab. This tutorial will cover using the batch item export and batch item import tools to quickly update the information. First we need to export our item database by going to:

Main Menu → Item Management → Batch Item Export

On the batch item export screen make sure to select "Google Product Search Columns" as the Export Contents as shown below.

This will download a spreadsheet file that has the item ID, description and all the Google Product Search columns. The spreadsheet should appear in your Excel and look like the screenshot below.

You can read more about the Google Product Search requirements by reading their feed specification.

After you have populated the information on the spreadsheet save it to your desktop or other location on your hard drive. Then navigate to the batch item import utility here.

Main Menu → Item Management → Batch Item Import

The first step is to click browse and locate the file on your computer. Then click Continue as shown in the screenshot below.

The batch item import utility is smart enough to identify the Google Product Search spreadsheet and automatically map all the columns out as shown below.

Just screen to the bottom of the page and click Continue. This will start the import process and update all your items.

Browser not supported