I received an error when importing. What does the error mean?

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:  www.store.com/products/blue-t-shirt the handle is blue- t-shirt.
    Please check that the value mentioned is the product's handle (not the product's title) and matches the product you'd like to attribute the review to.
    Also, please make sure to attribute reviews to an active product only (one that appears in your Shopify Product dashboard only).

    Note - this message might appear when the column name does not match the original template's column name.
    If you use the Loox template, it should be exactly "product_handle". Other apps export file may contain a different name - in any case, make sure not to remove or rename it.
  • 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.
    Please note - this message might also appear when the column name does not match the original template's column name.
  • 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.
    Please note - this message might also appear when the column name does not match the original template's column name.
  • Rating invalid: the value mentioned in the "created_at"/"review_date"/"reviewed_at"/etc.  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).
    Please note - this message might also appear when the column name does not match the original template's column name.
  • 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 in YYYY-MM-DD HH:mm :ss  UTC. 
    For example, "2016-02-09 08:54:01 UTC".

    Please note - this message might also appear when the column name does not match the original template's column name.
  • 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.

If you're still having trouble with importing your reviews, feel free to contact us!