Issue

The value in the product_id or product_handle column does not match any product in your store.

Solution

Double-check the product_id and product_handle values.

Issue

The value in the body column is missing, which is a required field.

Solution

Fill in at least 1 character in the body column. When transferring reviews from a previous review application, ensure to check the relevant column in the file for review content, such as 'review_content' or 'review'.

Issue

This error happens when you export the reviews then reimport them. As all reviews are pushed to Metaobject, when you reimport, we will see the reviews as already existing.

Solution

Issue

The value in the rating column is either missing or in an incorrect format. Ratings must be whole numbers between 1 and 5 (1, 2, 3, 4, 5).

Solution

Make sure the rating values are whole numbers between 1 and 5.

Issue

The value in the reviewer_name column exceeds the character limit (100 characters).

Solution

Ensure that the reviewer_name column has a name within the character limit. If needed, you can leave it empty, and we will use "Anonymous" as the reviewer's name.

Issue

Required headers (e.g., title, body, rating, review_date, reviewer_name, reviewer_email, product_id, product_handle,...) are missing from the CSV.

Solution

Check the headers you're missing or use a fresh template available here.