Import Product Reviews from a CSV Spreadsheet
Prepare the product review import CSV
Click here to find 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, and we would be happy to help!
Import product reviews into Recenio
- In the Recenio app, go to "Reviews" (in the sidebar), then "Import & export", then scroll down to the "Import reviews" section. Select the "CSV spreadsheet" review provider and upload the exported CSV file.
- Press the "Import reviews" button. Recenio then will process your uploaded file and import valid reviews.
- Once the import is completed, you will be able to find it in the "Review import history" section.
- There you can see the status of your import as well as the button to download a detailed import report. If any reviews fail to import, the report will contain a reason why the reviews 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 formatting
| 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. 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, 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, 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; |