1. Home
  2. Migrate From Other Review Apps
  3. How can I migrate reviews to Opinew from a custom CSV file?

How can I migrate reviews to Opinew from a custom CSV file?

If you used a different review system before installing Opinew, you can easily import your reviews from them to our dashboard. Using our custom csv importer you only need to follow our template file to start uploading past reviews without using the structure of another major Shopify review app.

How to import reviews from your old Shopify review system to Opinew:

1. Go to Get Reviews > Migrate Reviews and click the ‘Migrate Reviews’ button.

2. Pick the option ‘Custom’ from the dropdown menu.

3.- To properly create a valid custom CSV to upload you need to follow the structure as the one in this example file:

4. The csv file you choose must use the following structure:

The order of the columns is necessary to be exactly as follows, and every required value will be detailed in the list items; values without the ‘Required’ tag are optional and leaving them empty would be a valid value.

  • body (Required) : String of text with the body of the review
  • rating (Required): Number with the rating of the review
  • review_date (Required): Date with the following format: 2021-03-25 22:54:53 UTC
    (Single digits are also valid: 2021-3-25)
  • state (Required): It must be one of two valid values: published / unpublished
  • reviewer_name (Required): String of text with the name of the author
  • reviewer_email (Required): String of text with the email of the author
  • product_id (Required)*: Number with the Shopify id of the product
  • product_handle (Required)*: Shopify Product URL ending.
  • reply: String of text with the body of merchant resply to the review. It will show under the review.
  • reply_date: Date with the following format: 2021-03-25 22:54:53 UTC
  • (Single digits are also valid: 2021-3-25)
  • picture_urls: This cell can be filled in two ways:
  • 1.- One single url
  • 2.- Several urls separated by commas
  • sku (Required)*: Product’s sku code
  • barcode (Required)*: Product’s barcode
  • region: ISO 639-1 country code (eg. us, fr)

* At least one of the following values is required: product_id, product_handle, sku, barcode, having at least one the review will be imported; having more than one is not necessary but it doesn’t affect the import process.

Examples :

Example for product_ handle: 


The product handle is “mega-helmet”

Example for one image url : https://vrdev.storage.googleapis.com/Video/ba9268719cab777d36241ea87d843334.jpg

Example for several image urls : https://vrdev.storage.googleapis.com/Video/ba9268719cab777d36241ea87d843334.jpgExample,https://vrdev.storage.googleapis.com/Video/ba9268719cab777d36241ea87d843334.jpgExample,https://vrdev.storage.googleapis.com/Video/ba9268719cab777d36241ea87d843334.jpg

5. Click the ‘Upload CSV’ button.

If you cant’t find your previous review provider in the drop-down: that’s not a problem. Just reach out with the name of the provider & (if possible) a .csv file of your review data from them and your .myshopify.com domain name, for example: opinew.myshopify.com

You can contact us via email (support@opinew.com) or chat with us in the bottom right-hand side of your Opinew dashboard. We’ll get on processing your import right away & as long as you provide all the info we need, we try to get it done within 48 hours (though it’s often less).

When importing reviews into Opinew, we ask you to use only genuine reviews from your customers. People are quite good at spotting fake reviews and increasingly there are more consumer protection laws and court cases around those laws that may negatively impact your business:

US fake reviews court case news article, FTC case documents

Updated on December 1, 2022

Was this article helpful?

Related Articles

Leave a Comment