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- t-shirt.

Please check that the value mentioned is the product's handle only (not the product's title or the full URL) and matches the product you'd like to attribute the review to.

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.   field   does not exist or is in an incorrect date format.

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.   field is a future date. Please correct this field to match a date in the past.

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"  field  does not exist or is in an incorrect rating format. The correct format is all whole number between 1 and 5 (1, 2, 3, 4 or 5).

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!