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
Go to Import Shop Review
Choose shop reviews from CSV
Choose shop reviews from CSV

Prepare your CSV file

Make a copy from this example 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:

  • 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, … If you don't have any media files, leave this cell empty
  • Email: Reviewer's email. If you don't have the email, use the email username@domain.com
  • 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. If you don't have the country, leave this cell empty
  • Reply: An optional response to the review. If you don't have the country, leave this cell empty

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

Download file
Download file

Upload the download CSV file

Upload the downloaded CSV file, and click Start importing.

Upload the download CSV file
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

Hey! I'm Andrew Doan. Together, we'll build the foundation for a successful store and ensure it thrives! Let grow together!


Andrew Doan

Boost Sales & Efficiency with Doran

Boost customer satisfaction, streamline operations, and maximize sales with our Shopify apps. From managing reviews to seamless order printing, our solutions are designed to help your store thrive.

Explore Our Apps