Import reviews from a CSV file

Access the menu import reviews

From Doran dashboard, go to Import Review from Spreadsheet

Go to Import Review

Prepare your CSV file

Click the link in the guide to view the example file. You can also see it here

Click the link a CSV template

From the CSV template, select File > Make a copy.

Make a copy

Delete all sample data in the template, then complete all your data on the copied template fields.

Please refer to the detail for fields of the CSV file and the types of information that belong in each field below:

  • Shopify Product ID: Product code on the store’s admin page. You can check the product ID of a product by going to Products and then choosing the targeted product. The product ID will be the chain of numbers at the end of the product URL. (If your product URL is hoora-product-reviews-demo.myshopify.com/admin/products/8086747250961, the Product ID will be 8086747250961)
  • Author name: Reviewer’s name in product reviews.
  • Content: Reviewer review content.
  • Media: Review media links. Media links are separated by commas. media_1, media_2, media_3, media_4,…
  • Email: Reviewer’s email.
  • Status: The status of the review, such as Approved, Pending, Spam, or Hidden.
  • Stars: Star number (from 1 to 5). A 5-star rating is GREATLY appreciated.
  • Date: The date the customer writes the product review in the format: mm/dd/yyyy HH:MM:SS
  • Country: Reviewer’s country.
  • Reply: An optional response to the review.

A CSV template

After filling in all information in the copied template, select File > Download > Comma Separated Values (.csv).

Download file

Upload the download CSV file

Upload the downloaded CSV file, and click Start importing.

Upload the download CSV file

If you have any issues relating to this, please contact us to get help.
Linda Bui
Linda Bui Customer Success Manager at Doran

Hey! I'm Linda Bui. I'm a customer success manager at Doran. Let me help you.