Any CSV that carries stars and review text can come in as a generic import. Judge.me, Okendo, and Loox files are detected automatically. This page is the generic path and the header checker.
Vendor-specific steps: Judge.me, Okendo, Loox. Export format is in Your reviews are yours.
1. Prepare the file
Use a header row. Headers are normalized by lowercasing and stripping non-alphanumeric characters, so Review_Date and review-date are the same column.
2. Known aliases
| Field | Aliases |
|---|---|
| Rating | rating, score, stars |
| Title | title, review_title, headline |
| Body | body, review, review_body, review_content, content |
| Author | reviewer_name, name, display_name, author, author_name |
| reviewer_email, email, customer_email, author_email | |
| Date | reviewed_at, review_date, date_created, created_at, date |
| Product | product_id, shopify_product_id, product_gid, product_handle, handle, product_url, url |
| Verified | is_verified_buyer, verified, verified_purchase |
| Reply | reply, merchant_reply, public_reply, response |
| Images | image_urls, picture_urls, images, photo_url, photos |
| Status | source_status, status, review_status, approval_status, is_approved, approved, published |
| External id | source_external_id, external_id, review_id, unique_hash, hash, id |
Rating is required. Title or body is required. A product column is required to match catalog products. Missing products go to the repair queue instead of disappearing.
3. Source detection
- Okendo:
dateCreated,isVerifiedBuyer, orokendoReviewImportStatus - Judge.me:
reviewer_name,reviewer_email,review_date, ormetaobject_handle - Loox:
photo_url,display_name, ororder_idplusreview - Generic: anything else
Source-rejected rows arrive unpublished. Re-imports are duplicate-safe.
4. Limits
25 MB and 50,000 rows per file.
Need a blank file? Download the generic template CSV from Reviews. It uses product_handle, product_gid, rating, title, body, author_name, and reviewed_at, plus one example row.
After import, download a per-row issue report for that batch if anything was skipped, unmatched, or invalid. Large publishes refresh storefront snapshots in the background so the theme blocks catch up after the file is in.
5. Revert a completed import
On a completed batch, choose Revert this import. That deletes that import's reviews and their hosted photos, then refreshes storefront snapshots. The import receipt stays in the list as reverted. The same file can be imported again.
Only a completed import can be reverted.
The matching export can be the full library or a filtered copy (status, reviewed-at date range, product handle, source). The filename names the filters you chose. See Export.
Check a CSV header row
Paste the first line of an export. This uses the same header fingerprints as the importer: Okendo, Judge.me, Loox, or generic.
Nothing to check until you paste a header.
Next
- Moderation
- Export so a round trip stays possible
- AgentReady Reviews