Exporting reviews using Product Reviews
To keep displaying the reviews that you've collected using the Product Reviews app after May 6, 2024, you can export your reviews and then import your reviews to the app that you're migrating to.
From your Shopify admin, click Settings > Apps and sales channels.
From the Apps and sales channels page, click Product Reviews.
Click Open app.
A CSV spreadsheet file downloads in your browser.
Product review CSV files
Exported product reviews are formatted into a CSV spreadsheet file. The following table describes the headers of the spreadsheet and types of information that belong in each column:
|Product review information
|This is the tail end of your product's URL. For example, if your product displays on your online store at https://johns-apparel.com/products/blue-t-shirt, then the
product_handle is blue-t-shirt.
|The status of the review, such as approved or published.
|A score from 0-5, where 5 represents the most positive product review.
|A short, bolded title summarizing the customer's experience. For example, "Awesome!"
|The first and last name connected to the customer account that submitted the review.
|The customer's email address.
|The customer's address, such as their city and country.
|A longer description of the customer's experience. They can elaborate on what they liked or did not like about your product.
|An optional response to the review.
|The date and time when the product review was created by the customer.
|The date and time when the reply was created.