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 anOnline Store 2.0theme, then the Product Reviews app saves rating data inProduct RatingandProduct Rating Countstandard 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.
On this page
Product review CSV files
Imported and exported product reviews are formatted into aCSV 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 theproduct_handleisblue-t-shirt. |
| state | 复习的状态,如批准或出版ished. |
| 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. |
| 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 thisexample 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:
Make sure you have a CSV file of the reviews you want to import and that it's formatted correctly.
From your Shopify admin, clickSettings>Apps and sales channels.
From theApps and sales channelspage, clickProduct Reviews.
ClickOpen app.
ClickSettings.
ClickImport.
ClickChoose file, and then select your CSV file.
ClickImport.
Export reviews
To export your existing reviews from the Product Reviews app:
From your Shopify admin, clickSettings>Apps and sales channels.
From theApps and sales channelspage, clickProduct Reviews.
ClickOpen app.
ClickSettings.
ClickExport.
A CSV spreadsheet file downloads in your browser.