When importing product reviews into Judge.me using a CSV file, most reviews will upload smoothly. But sometimes, specific values or formats in your file might not meet our system’s requirements—causing some reviews to fail.
Don’t worry! Judge.me will email you a detailed error report if this happens. You can then fix the errors in your CSV and reimport only the failed reviews.
1. Product not found
Issue:
The value in the product_id
or product_handle
column doesn’t match any product in your Shopify store. Judge.me can’t attach the review to a product that doesn’t exist.
How to fix it:
Use either the correct product_id
or product_handle
. If you're unsure where to get these values, see our guide:
👉 How to find your product ID and product handle
Version | product_id | product_handle | title | body | rating |
❌ Incorrect |
| wrong-handle | Great shirt | Loved it! | 5 |
✅ Corrected | 8473829472384 | cool-shirt | Great shirt | Loved it! | 5 |
2. Review content not found
Issue:
The body
column is empty. This is a required field, so reviews without content will be rejected.
How to fix it:
Make sure each row has at least one character in the body
column. If you're importing from another app (like Loox or Yotpo), locate the column that contains the review text (e.g., review
, comments
, text
) and map it to body
.
Version | title | body | rating |
❌ Incorrect | Fits well |
| 5 |
✅ Corrected | Fits well | This shirt fits great! | 5 |
3. Review already exists in Metaobjects
Issue:
You exported reviews from Judge.me and tried to reimport them. These reviews already exist in Shopify’s Metaobjects, so duplicates are blocked.
How to fix it:
Open the CSV file in Google Sheets.
Delete the
metaobject_handle
column.Save as
.csv
and reimport it.
Version | product_handle | title | body | rating | metaobject_handle |
❌ Incorrect | cool-shirt | Love it! | Great quality! | 5 | review_12345 |
✅ Corrected | cool-shirt | Love it! | Great quality! | 5 | (column removed) |
4. Review rating invalid
Issue:
The rating
value is missing or not a valid whole number. Ratings must be 1, 2, 3, 4, or 5.
How to fix it:
Ensure all entries in the rating
column are whole numbers between 1 and 5.
Version | rating |
❌ Incorrect | 4.5 |
| five |
| (blank) |
✅ Corrected | 4 |
| 5 |
| 3 |
5. Reviewer name invalid
Issue:
The name in the reviewer_name
column exceeds 100 characters.
How to fix it:
Keep names under 100 characters. If you leave this field blank, we’ll use “Anonymous” by default.
Version | reviewer_name |
❌ Incorrect | This is a very long name that exceeds the maximum length... |
✅ Corrected | Alex Carter |
| (blank → will show as "Anonymous") |
6. Missing required headers
Issue:
Your CSV file is missing one or more required headers. Judge.me needs these to process each review correctly.
How to fix it:
Use our CSV import template to make sure all necessary headers are included. Required columns:
title
body
rating
review_date
reviewer_name
reviewer_email
product_id
orproduct_handle
❌ Missing headers
product_handle | title | reviewer_name |
cool-shirt | Great fit | Alex |
✅ Required headers added
product_handle | title | body | rating | review_date | reviewer_name | reviewer_email |
cool-shirt | Great fit | Fits perfectly! | 5 | 2024-03-20 | Alex Carter |