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
Important: Renaming column titles, as well as removing columns, will create errors in the import file.
Product not found:
The value mentioned in the "product_handle"/"handle"/"product_url" column is missing or does not relate to an active 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. Loox will not accept other formats.
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.
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"
Photo_url invalid:
The photo URL does not exist or is incorrect. The accepted image formats are JPG, JPEG & PNG. Please do not leave any trailing characters after the .jpg/jpeg/png ending.
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 our Support team at [email protected], and we’d be more than happy to help!