Bulk CSV Import

Importing Reviews from a CSV File

You can import hundreds of reviews at once using a CSV file. This is useful when migrating from another review app or adding reviews for new products.

CSV Format

Your CSV file needs these columns:

| Column | Required | Description | |--------|----------|-------------| | product_id | Yes | The Shopify product ID | | rating | No | A number from 1 to 5 | | comment | No | The review text | | user_id | No | A customer ID | | user_display_name | No | The reviewer's name |

Each row must have at least a rating or a comment (or both).

You can download a CSV template to get started.

Migrating from Other Review Apps

Most review apps let you export your reviews as a CSV file. After exporting, rename the columns to match the format above and you're ready to import.

Judge.me: Export from Judge.me dashboard, then rename product_external_id to product_id, reviewer_name to user_display_name, and body to comment.

Yotpo: Export reviews from the Yotpo admin. Rename external_product_id to product_id, display_name to user_display_name, and content to comment.

Stamped.io: Export from the Stamped dashboard. Rename productId to product_id, author to user_display_name, and body to comment.

How to Import

1. Go to the Bulk Upload page in your admin panel
2. Drop your CSV file (or click to browse)
3. Review Nova checks your file and shows how many valid rows it found, along with any errors
4. Click Import to start the upload
5. A progress bar shows you how the import is going. You can cancel at any time.
6. When the import finishes, you'll see a summary of how many reviews were imported and any rows that had errors

What Happens After Import

• All imported reviews are automatically approved and visible on your storefront right away
• Review stats (average rating, total count) are recalculated for each product
• Star ratings in Google search results are updated automatically
• You can find imported reviews in the Reviews page, filtered by source

Troubleshooting

"Must have a rating or a comment" — Each row needs at least one of these fields filled in.

"Missing product_id" — Every row must have a product ID. You can find product IDs in your Shopify admin under Products.

"Invalid rating" — Ratings must be a whole number from 1 to 5.

Some rows failed but others imported — Review Nova imports each row independently. Successfully imported reviews stay in your store even if other rows had errors. Fix the errors in your CSV and re-import just the failed rows.