Import Product Reviews Using CSV in Rivyo • Rivyo Help Center – Reviews, Loyalty & Referral Program Setup Guides for Shopify

Overview

Rivyo lets you import product reviews in bulk using a spreadsheet file. This is ideal when you:

Are migrating from another review app
Already have reviews stored in a spreadsheet
Collected reviews outside your Shopify store and want them to display on product pages

After you upload your file, Rivyo matches each review to the correct product and adds the reviews to your store.

Imported reviews appear in your Rivyo reviews list and (depending on your approval settings) can be published to your storefront.

Supported file formats

Rivyo accepts the following file formats:

.csv
.xlsx
.xls

For the smoothest import, use .csv (CSV UTF-8) and keep your column names simple and consistent.

Import product reviews (CSV upload)

From your Shopify Admin, open the Rivyo app.

In Rivyo, go to Reviews → Import Reviews.

Make sure Product Reviews is selected.

Click Import from CSV or apps, then choose Import from CSV.

Upload your CSV file, then click Import Review.

Rivyo will process the file and add the reviews to the matching products.

After the import finishes, review the results in Import Review History (details below).

If Rivyo can’t match a row to a product (for example, the product handle is wrong or the product no longer exists), that review may be skipped or marked as failed in the import history.

CSV required fields

Your file must include the following fields (columns). If any required field is missing, reviews may not import correctly.

Field	What it means	Example
Product ID or Product Handle	Identifies which product the review belongs to.	`1234567890` or `classic-tshirt`
Name	Reviewer name shown on the review.	`Alex Johnson`
Email	Reviewer email address.	`[email protected]`
Rating	Star rating value from 1 to 5.	`5`
Date	Review date in `YYYY-MM-DD` format.	`2026-03-07`

Use Product Handle if you want your import to remain stable even if product IDs change due to migrations. You can find a product handle in Shopify by opening a product and checking the end of the product URL (the “handle”).

Optional fields (recommended)

You can include extra columns to create richer reviews. These fields are optional, but strongly recommended when available:

Review title (headline shown above the review)
Review body or description (the main written review)
Customer images (if your import format supports image links)
Verified purchase (if you want certain reviews labeled as verified)

If you’re migrating from another app, your exported CSV may include additional columns. That’s fine—keep them if you’d like, but make sure the required fields are present and correctly filled for every row.

Import options

When importing reviews, you can choose additional options:

Approve all reviews

Turn this on if you want imported reviews to be automatically approved and eligible to show on your store right away. If you leave it off, imported reviews may stay unpublished until you approve them.

Skip existing reviews

Turn this on to help prevent duplicates. Rivyo will skip reviews that already exist in your store.

If you’re doing multiple test imports, enable Skip existing reviews to avoid importing the same rows again.

CSV example (template)

Here’s a simple example you can copy into a CSV file. Your column names should match the fields you’re using.

Product Handle,Name,Email,Rating,Date,Review title,Review body
classic-tshirt,Alex Johnson,[email protected],5,2026-03-07,Perfect fit,"Great quality fabric and fast shipping."
classic-tshirt,Sam Lee,[email protected],4,2026-03-05,Good value,"Fits well. Color is slightly darker than photos."

Keep the Date format exactly as YYYY-MM-DD. Dates like 03/07/2026 may fail or import incorrectly depending on your spreadsheet settings.

Import review history

After importing, go to Import Review History to review what happened. This is the best place to confirm whether your file processed successfully.

You can typically see:

Import date
File name
Successful imports
Total rows
Status (completed, failed, or partially completed)

If some rows fail, you can usually fix the spreadsheet (for example, product handle or date formatting) and re-import. Use Skip existing reviews to avoid duplicating rows that already imported successfully.

Tips for successful imports

Use one product identifier consistently: choose either Product ID or Product Handle and ensure it’s filled in for every row.
Confirm product handles: a single typo in a handle can cause reviews to import without matching a product.
Keep ratings valid: ratings must be whole numbers from 1 to 5.
Standardize your dates: make sure every row uses YYYY-MM-DD.
Remove extra commas in CSV text: if your review body contains commas, ensure your spreadsheet exports proper quoted CSV (most do automatically).
Test with a small file first: import 5–10 rows to confirm formatting before importing thousands.

Troubleshooting

Check whether the reviews are approved. If you didn’t enable Approve all reviews, you may need to approve imported reviews before they publish.
Confirm your storefront review widget/blocks are enabled and placed on product pages (theme settings can affect visibility).

Make sure Product ID or Product Handle matches an existing product.
Check required fields for blanks (Name, Email, Rating, Date).
Verify the Date column uses YYYY-MM-DD.
If Skip existing reviews is enabled, duplicates may be skipped by design.

This is usually caused by spreadsheet auto-formatting. Set the date column to plain text before exporting, then re-export as CSV and import again.

Often yes. Exports vary between apps. Ensure your file contains all required fields and that each row includes a valid product identifier (Product ID or Product Handle) that matches your current Shopify catalog.

Import Product Reviews Using CSV