A CSV (comma-separated values) file is a plain text file that contains data that are separated by commas. It allows data to be saved in a tabular format, so using Microsoft Excel or Google Sheets are both excellent ways to prepare it.

In this article:

Preparing the CSV file

Using a CSV file to import reviews

Common questions

Preparing the CSV file

To import reviews into our Rivo Product Reviews app, you will need to create a CSV file that follows our template or download our template here. Below is the list of what the fields in the template are for, and where you can find the data.

Header

Required

Description

state

Yes

The status of the review. It can either be published or unpublished

body

Yes

This is where the content of the review should be

stars

Yes

It indicates the number of stars and can be any number from 1 to 5

*email

Yes

The reviewer's email address

first_name

Yes

The first name of the reviewer

last_name

Optional

The last name of the reviewer

product_id

Yes

The unique identifier for your product

product_tile

Yes

The name of your product that is also displayed on your website for the customers to see

product_handle

Yes

The unique name given to your product in both Shopify Admin and the online store

**photo_url

Optional

The image URL for your review

rated_at

Yes

The date when the review was posted. The format to use here has to be YYYY-MM-DD

reply

Optional

The content of your reply to the customers' reviews

replied_at

Optional

The date when you replied to the review

*There cannot be multiple reviews from the same email for a single product

**Currently, Rivo only supports 1 image per review

💡 Pro Tip: You can find all the product ID, title, and handle in your Shopify admin > Products > select the product

Using a CSV file to import reviews

Once you have filled in all the fields, please go to your account and follow the steps below.

  1. From the Reviews dashboard, go to Settings.

  2. In the Import Reviews section, click Choose File.

  3. Select the file you wish to use and allow a few minutes for your reviews to appear.

Common questions

My reviews were not imported. Why?

This could be due to different reasons:

  • The date format was not correct. Please use YYYY-MM-DD

  • There were multiple reviews from the same email for a single product. Please use dummy email addresses if required

  • Required fields were not filled in:

    • state

    • body

    • stars

    • email

    • first_name

    • product_id

    • product_title

    • product_handle

    • rated_at.

I haven't completed all the details of my reviewers. What can I do?

  • email — If there are no email addresses available, you can use a dummy address

  • first_name — If the name is not available, it can be changed to something like Anonymous or A reviewer

  • last_name — This is optional. You can either use initials to hide sensitive information or leave it blank.

I can't successfully import my reviews or I need help migrating to Rivo Product Reviews. Can you assist me?

Please reach out to us via [email protected] to help you with your request!

Did this answer your question?