Importing and exporting reviews using Product Reviews

You can use the Product Reviews app to import and export product reviews from other review services.

Product review CSV files

Imported and exported product reviews are formatted into a CSV spreadsheet file. The table below describes the headers of the spreadsheet (the top row) and types of information that belong in each column:

Header name Product review information
product_handle This is the tail end of your product's URL. For example, if your product appears on your online store at https://johns-apparel.com/products/blue-t-shirt, then the product_handle is blue-t-shirt.
state The status of the review, such as approved or published.
rating A score from 0-5, where 5 represents the most positive product review.
title A short, bolded title summarizing the customer's experience. For example, "Awesome!"
author The first and last name connected to the customer account that submitted the review.
email The customer's email address.
location The customer's address, such as their city and country.
body A longer description of the customer's experience. They can elaborate on what they liked or did not like about your product.
reply An optional response to the review.
created_at The date and time when the product review was created by the customer.
replied_at The date and time when the reply was created.

Import reviews

Before you begin, download a CSV file of your review data from the review service that you want to migrate from. Most review services let you export your data to a CSV file.

The CSV importer should work automatically for popular review services, however you might need to format your CSV file to match the format of this example CSV file. Make sure you remove the example product from the CSV template, or you will see an error when you import the CSV file.

To import reviews into the Product Reviews app:

  1. Make sure you have a CSV file of the reviews you want to import and that it is formatted correctly.

  2. From your Shopify admin, go to Apps > Product Reviews.

  3. Click Settings.

  4. Click Import.

  5. Click Choose file, and then select your CSV file.

  6. Click Import.

Export reviews

To export your existing reviews from the Product Reviews app:

  1. From your Shopify admin, go to Apps > Product Reviews.

  2. Click Settings.

  3. Click Export.

A CSV spreadsheet file will download in your browser.

Ready to start selling with Shopify?

Try it free