Fixing errors on spreadsheet imports
Loox enables merchants to import reviews using a review export file/the Loox import template.
When a value of a certain field does not match the required criteria, a message error appears in the "Error" column that is added to your imported file (that is included in the review import summary email).
Here's a short explanation of what the error you've received might mean:
Product not found:
The value mentioned in the "product_handle"/"handle"/"product_url" column is either absent or does not correspond to a product in your store.
A product handle is the last part of the product URL (after the last "/"): For example, for this product: store.com/products/blue-t-shirt the handle is blue-
Also, make sure to attribute reviews to an active product only (one that appears in your Shopify Product dashboard only).
Review date invalid:
The value mentioned in the "created_at"/"review_date"/"reviewed_at"/etc.
The correct date format for Loox reviews is YYYY-MM-DD HH:MM:SS UTC.
For example, " 2020-01-09 08:54:01 UTC".
The date must appear as Year-Month-Day, other formats will not be accepted.
Review date cannot be in the future:
The value that is mentioned in the "created_at"/"review_date"/"reviewed_at"/etc.
Reviewer name is missing:
The value mentioned in the "author"/"nickname"/"reviewer_name"/etc. field does not exist. Since this is a required field, please fill in this data.
Review body is missing:
The value mentioned in the "body"/"review_body"/"review"/etc. field does not exist. Since this is a required field, please fill in this data.
Rating invalid:
The value mentioned in the "rating"
Note - these messages might appear when the column's header does not match the original template's column name.
You can download the original Loox import template here.
If you're still having trouble with importing your reviews, feel free to contact us, we'd be happy to help!