Import Product Reviews from a CSV Spreadsheet
Prepare the product review import CSV
Click here to copy the Recenio review import template. Fill out and export the 'Import template' worksheet by following the instructions in the 'Instructions' worksheet.
Do not modify the header columns in the 'Import template' worksheet, as this could prevent Recenio from importing your reviews.
If you need assistance filling out the import template, let us know. We would be happy to help!
Import product reviews into Recenio
- In the Recenio app, go to "Reviews" (in the sidebar), then "Import & export". Scroll to the "Import reviews from a spreadsheet" section and upload the CSV file.
- Press the "Import reviews" button. Recenio will then process your uploaded file and import valid reviews.
After importing product reviews
- The review import results are in the "Review import history" section. It contains the status of your import and a button to download the import report. If any reviews fail to import, the report will explain why they were rejected under the "importStatus" column.
- If you wish to retry importing reviews, you can delete reviews from a specific import by pressing the "Delete" button and confirming.
Import file format
| Column | Required | Description | Example |
|---|---|---|---|
| name | yes | The name of the reviewer. | Jane Doe |
| rating | yes | The star rating. Valid values are 1, 2, 3, 4, 5. | 5 |
| content | yes | The content of the review. Up to 10000 characters. | Great product, I loved it! |
| createdAt | yes | When the review was submitted. Must be in the following format: yyyy-mm-dd, where yyyy - year, mm - month, dd - day. |
2023-01-01 |
| productId | one of productId or productHandle is required | The Shopify product identifier. It can be found at the end of the URL when viewing a product in the Shopify admin area. For example, if the product URL ends with /store/demo/products/8572414918951, the productId would be 8572414918951 |
8572414918951 |
| productHandle | one of productId or productHandle is required | The productHandle is the last part of the product URL in your store. For example, in the URL https://demo.com/products/example-product, the productHandle is example-product. |
example-product |
| title | no | The title of the review. If not provided, the rating is used to set a title. | Amazing experience! |
| no | The email address of the reviewer. | janedoe@gmail.com | |
| recommended | no | Would the reviewer recommend the product. Valid values are "true" or "false". If not provided, then it will be set based on the rating. |
true |
| verifiedBuyer | no | Is the reviewer a verified buyer. Valid values are "true" and "false". If not provided, it will default to "false". |
true |
| publish | no | Should the review be immediately published after the import. Valid values are "true" and "false". If not provided, it will default to "false". |
true |
| reply | no | Your reply to the review. | Thanks for the review! |
| repliedAt | no | When you replied to the review. Must be in the following format: yyyy-mm-dd, where yyyy - year, mm - month, dd - day. |
2023-01-01 |
| imageUrls | no | The URLs of images submitted with the review. Multiple images can be imported by separating them with a semi-colon (;). |
cdn.demo.com/firstImage; cdn.demo.com/secondImage; |
| videoUrls | no | The URLs of videos submitted with the review. Multiple images can be imported by separating them with a semi-colon (;). |
cdn.demo.com/firstVideo; cdn.demo.com/secondVideo; |