Google Shopping Product Review Feed
The Google Product Review Feed allows online retailers to send product reviews to Google Shopping for inclusion in listings.
This guide explains how you can use Aurora to properly format your product review feed.
Overview
The Google Shopping Product Review Feed allows you to send product reviews to Google Shopping.
The feed can be found at /datafeeds/google-shopping-product-reviews.xml, e.g. if your domain name is www.auroracommerce.com, then the feed would be available at www.auroracommerce.com/datafeeds/google-shopping-product-reviews.xml.
The feed is automatically updated once per day, but you can refresh the feed manually at any time using the Products > Reviews > Update Google Shopping Feed button. Please note that this is also the recommended way to generate the initial feed, the first time the feature is being used.
Feed Template
Google provides detailed guidelines about how to format a product feed and which fields should be included.
You (or your design agency) can control exactly which fields are included in your feed by creating or editing a template file. Typically you would access this via FTP, and it can be found at /datafeeds/google-shopping-product-reviews.tpl.xml inside the relevant template directory for your domain name.
Example Template
An example template file is provided below, but please note that this file will require modification to suit your needs and to meet Google's guidelines.
<?xml version="1.0" encoding="UTF-8"?>
<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">
<reviews>
{foreach from=$reviews item=review}
<review>
<reviewer>
<name>{$review.reviewer_name}</name>
</reviewer>
<review_timestamp>{$review.review_timestamp}</review_timestamp>
<title>{$review.review_title}</title>
<content>{$review.review_description}</content>
<review_url type="group">http://{$domain_name}{$review.product.product_filename}</review_url>
<ratings>
<overall min="1" max="5">{$review.review_rating}</overall>
</ratings>
<products>
<product>
<product_url>http://{$domain_name}{$review.product.product_filename}</product_url>
</product>
</products>
</review>
{/foreach}
</reviews>
</feed>
Template Variables
A list of the available variables that can be used in the templates is given below. Please note that for both the product and additional fields sections, this list is not exhaustive:
Variable name | Notes |
---|---|
$domain_name | Your own website domain name, e.g. www.auroracommerce.com (see also $review.product.product_filename) |
$review.reviewer_name | The reviewer's name |
$review.date_created | e.g. 2014-12-28 18:11:54 (see also $review.review_timestamp) |
$review.review_title | e.g. "Quality Product" |
$review.review_description | The main content of the review |
$review.product_id | The numeric Aurora Product ID |
$review.review_rating | From 1 to 5, e.g. 4.75 |
$review.review_timestamp | ISO8601 format required by Google, e.g. 2014-12-28T18:11:54+00:00 |
$review.product ... | This gives access to full information about the product reviewed. Given below are some relevant examples from the full data available. |
$review.product.product_filename | The URL of the product, e.g. /category/product_title.html (see also $domain_name) |
$review.product.product_name | The product's name |
$review.product.product_reference | The product's reference number / code |
$review.product.product_ean | The product's barcode |
$review.product.product_description | The product's full description (may contain HTML) |
$review.product.product_price | The product's price |
$review.product.product_price_rrp | The product's RRP |
$review.product.product_rating | The average product rating across all reviews |
$review.product.total_reviews | The total number of reviews for this product |
$review.product.product_category_name | The name of the product's category |
$review.product.fields ... | This gives access to all product additional fields defined within Aurora. The exact fields available varies between installations, but some examples are given below. |
$review.product.fields.size | The product's size (example additional field) |
$review.product.fields.colour | The product's colour (example additional field) |
Updated over 2 years ago