Skip to content

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_idShopify product ID
rating, score, starsRating (1-5)
email, customer_emailCustomer email

Optional Columns

Column Name (any of these)Description
name, customer_name, authorCustomer name
title, review_title, headlineReview title
body, review, content, text, messageReview body
date, created_at, timestampCreation date
status, publishedStatus (approved/pending)
reply, reply_bodyMerchant reply

Example CSV

product_id,name,email,rating,title,body,status
7654321098,Jane D.,[email protected],5,Love it!,Great product,approved
7654321098,John S.,[email protected],4,Good quality,Would recommend,approved

Import Steps

  1. Go to Settings → Import
  2. Select CSV as the source
  3. Upload your file
  4. Review the auto-detected column mappings
  5. Adjust any incorrect mappings
  6. Click Start Import

Limits

  • Max file size: 50MB
  • Max rows: 50,000
  • One import at a time per shop