Generic CSV Import
CSV Format
Your CSV should include a header row. SimplerSuite Reviews auto-detects common column names:
Required Columns
| Column Name (any of these) | Description |
|---|---|
product_id, productid, shopify_product_id | Shopify product ID |
rating, score, stars | Rating (1-5) |
email, customer_email | Customer email |
Optional Columns
| Column Name (any of these) | Description |
|---|---|
name, customer_name, author | Customer name |
title, review_title, headline | Review title |
body, review, content, text, message | Review body |
date, created_at, timestamp | Creation date |
status, published | Status (approved/pending) |
reply, reply_body | Merchant reply |
Example CSV
product_id,name,email,rating,title,body,status7654321098,Jane D.,jane@example.com,5,Love it!,Great product,approved7654321098,John S.,john@example.com,4,Good quality,Would recommend,approvedImport Steps
- Go to Settings → Import
- Select CSV as the source
- Upload your file
- Review the auto-detected column mappings
- Adjust any incorrect mappings
- Click Start Import
Limits
- Max file size: 50MB
- Max rows: 50,000
- One import at a time per shop