The import process is straightforward; however, there may be cases where certain values in the CSV file don't meet our criteria, causing the reviews to fail to import.
When this happens, don't worry! We'll send you an email with the errors and the affected reviews. Then, you can make the necessary changes and reimport the failed reviews.
1. Product not found
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. |
2. Review content not found
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. Or if you import from a previous review app, check the file corresponding column for review content (e.g., review_content, review). |
3. Review already exists in metaobjects
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 |
|
4. Review rating invalid
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. |
5. Reviewer name invalid
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. |
6. Missing params
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. |