Skip to main content

Fixing errors when importing reviews via CSV

A step-by-step guide to troubleshoot and fix CSV import errors with examples.

Updated over a month ago

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:

  1. Open the CSV file in Google Sheets.

  2. Delete the metaobject_handle column.

  3. 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 or product_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

Did this answer your question?