Creating a Google Product Ratings Feed
Before starting on the Product Review feed…
make sure that the client is approved for product ratings in the Merchant Center. There should be a “Product Reviews” option present in the client’s Merchant Center sidebar if they are already approved.
If not, the client needs to use the following link to sign up for Product Ratings: https://support.google.com/merchants/answer/7050198?hl=en&ref_topic=7307120
Building a Product Review Feed
The Product Feed Specs are referenced from the following link: https://developers.google.com/product-review-feeds/
The minimum required fields for a Product Rating Feed are:
The name of the reviewer<review_url>
URL of the review
Timestamp of when review took place. Needs to be a standard unix timestamp
Content of review
Rating of the product. The min and max rating rule of each product must be defined in the export
URL of product
<gtin> (optional, but highly recommended)
Having GTINs present in each review increases the quality score of the review significantly. Some products may require GTINs anyway
Here are other optional fields that can be added that may be useful as well:
Creating the Export
Product Ratings require to be submitted using an xml file. A custom xml file must be created in order to send to Google.
The following steps for creating the custom xml file need to be done:
- Copy and paste the following into the File Header field under options (insert the name of the client in the <name> tag:
<feed xmlns:vc="http://www.w3.org/2007/XMLSchema-versioning" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation= "http://www.google.com/shopping/reviews/schema/product/2.1/product_reviews.xsd"> <publisher> <name>Client Name</name> </publisher>
- Copy and paste the following in the File Footer:
- Check off “Put column names in first row” and “XML Write Document Tag”
- Set the Export format to “Custom XML”
- Add the necessary fields in the Export map and make sure that the fields in the Export name are correctly built out (link to KB article with XML guide)
Once the export is created, it can be submitted to Google using FTP within Product Reviews, just like for Google Shopping.
Brian oversees all of Feedonomics’ Automation Processes. He loves taking the most annoying manual tasks and automating them. Brian received both a Bachelor’s and Master’s degree in Mechanical Engineering from UCLA, where he graduated summa cum laude.