Fixing Errors on Spreadsheet Imports

Loox enables you to import reviews using 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).

You can read more about importing reviews from a spreadsheet here:
Importing Reviews From a Spreadsheet

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.

The 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 that it 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.
For example " 2020-01-09" for January 9th, 2020.

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.

If your review doesn't have any text, please fill in at least one character (can also be a space).

Rating invalid:

The value mentioned in the "rating"  field  does not exist or is in an incorrect rating format. The correct format is whole numbers between 1 and 5 (1, 2, 3, 4, 5).

You can download the original Loox import template here.