Introduction

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.

✨ Reviews import is available in all plans

In this article:

Preparing the CSV file
- Where to find the product ID, title, and handle?
Using a CSV file to import reviews
Common questions

Preparing the CSV File

To import reviews into our Rivo Product Reviews app, download our template here and make sure that it contains the fields required. Below is the list of what the headers 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`
title	Optional	The title of the review
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
verified	Optional	Should be either `TRUE` or `FALSE`
product_id	Yes	The unique identifier for your product
product_title	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
video_url	Optional	The video url for your video
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

Where to find the product ID, title, and handle?

This can be found in your Shopify admin.

Go to Shopify
Click Products in the sidebar menu
Select a product
Copy the number string at the end of the URL (Product ID)
Copy the name below Title (Product Title)
Scroll down to Search engine listing and copy the number string after /products in the URL (Product Handle). You can also click Edit to display the full URL handle.

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.

Click Settings in the sidebar menu
In the Import Reviews section, click Choose File
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 cannot complete my reviewer's details. 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!