Import guide
Pattern Owl imports reviews from any platform via CSV - Shopify, BigCommerce, WooCommerce, Magento, Volusion, Yotpo, Judge.me, Stamped, or your own export. Here's what the file needs to look like.
Your CSV needs these five columns. The column names don't have to match exactly - the import wizard will help you map them.
| Column | What it is | Example |
|---|---|---|
| product_name | The product being reviewed | "Wireless Bluetooth Speaker" |
| product_id | A product ID or SKU | "WBS-2024" |
| rating | A score from 1 to 5 | 4 |
| review_date | When the review was posted (YYYY-MM-DD) | 2025-11-15 |
| review_text | The review content | "Great sound quality, compact size..." |
These are nice to have but not required:
review_title - The review headlinecustomer_name - Reviewer's nameorder_id - Order or transaction IDemail - Reviewer's emailproduct_name,product_id,rating,review_date,review_text,review_title,customer_name Wireless Bluetooth Speaker,WBS-2024,5,2025-11-15,"Amazing sound quality for the price. Battery lasts all day.",Best speaker I've owned,Sarah M. Wireless Bluetooth Speaker,WBS-2024,3,2025-11-20,"Sound is decent but the Bluetooth range is shorter than expected.",Good but not great,Mike T. Leather Wallet - Brown,LW-BRN-01,4,2025-12-01,"Nice quality leather. Slim enough for front pocket. Wish it had more card slots.",Solid wallet,James R. Organic Face Cream,OFC-50ML,5,2025-12-05,"My skin has never felt better. No irritation at all. Will definitely reorder.",Life changing!,Amy L. Organic Face Cream,OFC-50ML,2,2025-12-10,"The cream is too thick and has a strong scent. Not for sensitive skin despite the label.",Disappointing,Karen W.
Most review platforms let you export to CSV. Here's the general approach:
Yes. The first row should contain column names. They don't need to match Pattern Owl's exact names - the import wizard auto-detects common variations (Review Score, SKU, Rating, etc.) and lets you map anything that doesn't match automatically.
The import wizard detects common formats including YYYY-MM-DD, MM/DD/YYYY, DD/MM/YYYY, and ISO 8601 timestamps. You can confirm the detected format before import.
Pattern Owl CSV uploads are capped at 1,000 rows per file during early access. For larger datasets, split into multiple files and upload them sequentially.
No. Support tickets need the helpdesk-style schema (subject, messages, status, CSAT) which differs from the review schema. Connect a helpdesk integration (Gorgias, eDesk, Zendesk) for tickets, or upload them as a separate CSV with the ticket schema.
That is fine. The import wizard auto-detects common variations (Review Score, Stars, SKU, Product Code, etc.) and shows you the proposed mapping. You can override any mapping manually before confirming the upload.
Yes. Any platform that exports reviews to CSV works - Shopify's built-in reviews, BigCommerce, WooCommerce, Magento, Volusion, Yotpo, Judge.me, Stamped, or your own database export. If your platform supports CSV export, Pattern Owl can import it.
Once your data is imported, these guides cover what to do with it:
Sign up free and start analyzing your customer feedback in minutes.