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 nameNotes
$domain_nameYour own website domain name, e.g. www.auroracommerce.com (see also $review.product.product_filename)
$review.reviewer_nameThe reviewer's name
$review.date_createde.g. 2014-12-28 18:11:54 (see also $review.review_timestamp)
$review.review_titlee.g. "Quality Product"
$review.review_descriptionThe main content of the review
$review.product_idThe numeric Aurora Product ID
$review.review_ratingFrom 1 to 5, e.g. 4.75
$review.review_timestampISO8601 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_filenameThe URL of the product, e.g. /category/product_title.html (see also $domain_name)
$review.product.product_nameThe product's name
$review.product.product_referenceThe product's reference number / code
$review.product.product_eanThe product's barcode
$review.product.product_descriptionThe product's full description (may contain HTML)
$review.product.product_priceThe product's price
$review.product.product_price_rrpThe product's RRP
$review.product.product_ratingThe average product rating across all reviews
$review.product.total_reviewsThe total number of reviews for this product
$review.product.product_category_nameThe 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.sizeThe product's size (example additional field)
$review.product.fields.colourThe product's colour (example additional field)