Import shop reviews from a CSV file

Access the menu import reviews

From Doran dashboard, go to Import Shop Reviews from Spreadsheet

Go to Import Shop Review

Choose shop reviews from CSV

Prepare your CSV file

Make a copy from this example file

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:

  • Author name: Reviewer’s name in a review.
  • 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.

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

Important note: Doran needs to take about 10 - 20 minutes to publish all reviews after importing
If you have any issues relating to this, please contact us to get help.
Andrew Doan
Andrew Doan Founder at Doran

Hey! I'm Andrew Doan. I'm a founder at Doran. Let me help you.