Importing and exporting reviews using Product Reviews

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

If you're using an Online Store 2.0 theme, then the Product Reviews app saves rating data in Product Rating and Product Rating Count standard metafields. This means that your rating data is stored as additional data with your product. Because this data is stored in standard metafields, it might be compatible with other apps. Other apps can also contribute to your product rating data by writing to these metafields.

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:

Product review spreadsheet headers
Header nameProduct review information
product_handleThis is the tail end of your product's URL. For example, if your product appears on your online store at, then the product_handle is blue-t-shirt.
stateThe status of the review, such as approved or published.
ratingA score from 0-5, where 5 represents the most positive product review.
titleA short, bolded title summarizing the customer's experience. For example, "Awesome!"
authorThe first and last name connected to the customer account that submitted the review.
emailThe customer's email address.
locationThe customer's address, such as their city and country.
bodyA longer description of the customer's experience. They can elaborate on what they liked or did not like about your product.
replyAn optional response to the review.
created_atThe date and time when the product review was created by the customer.
replied_atThe 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 receive 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's formatted correctly.

  2. From your Shopify admin, click Settings > Apps and sales channels.

  3. From the Apps and sales channels page, click Product Reviews.

  4. Click Open app.

  5. Click Settings.

  6. Click Import.

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

  8. Click Import.

Export reviews

To export your existing reviews from the Product Reviews app:

  1. From your Shopify admin, click Settings > Apps and sales channels.

  2. From the Apps and sales channels page, click Product Reviews.

  3. Click Open app.

  4. Click Settings.

  5. Click Export.

A CSV spreadsheet file downloads in your browser.

Ready to start selling with Shopify?Try it free