Importing Reviews Using a Custom File

Import reviews collected from any previous source using a custom review template file. 

In this article, we will cover the process of importing reviews to Loox using a custom file, how to format your review data correctly, and how to troubleshoot common import errors to ensure a smooth process.


Importing reviews using a custom file

To Import reviews using a custom file:

  1. Go to “Import Reviews” within your Loox admin.
  2. Click Custom File.

  1. Make a copy of the import template and add your review data following the template format (see Review formatting guidelines below).

Having trouble copying the template? Download as a CSV file.

  1. Download your completed file in CSV format.
  2. Go back to the Loox app and upload your file.
  3. Once the import is complete, you will receive a review import summary email specifying the number of successfully imported reviews. The email will be sent to the address listed on your Shopify account.
  • If any reviews fail to import, the email will also include a CSV file listing errors that need to be corrected before re-importing.
  • Imported reviews will appear in your “Manage Review” settings section.

Note: You can import up to 100,000 reviews per store using a custom file. After reaching this limit, additional imports will not be possible using this method.


Review formatting guidelines

To ensure a successful import, your review data must match the template’s format. Below are the required fields and formatting guidelines:

Column TitleDescriptionExample
product_handle (Required)The handle is the last part of the product URL (after /products/).blue-t-shirt
rating (Required)Whole number between 1 and 5.5
author (Required)The reviewer's name. This will appear exactly as listed.John D.
emailThe reviewer's email address (optional).[email protected]
body (Required)The review text. Must contain at least one character.Great shirt, I loved it!
created_at (Required)The date the review was submitted, in YYYY-MM-DD format.2020-01-09
photo_urlPublic URL(s) of review images (comma-separated for multiple images).cdn.shopify.com/photo.png
verified_purchaseEnter TRUE to display the “Verified Purchase” label. Leave blank otherwise.TRUE
  • To upload multiple photos (up to 5 per review), separate image URLs with commas under the photo_url column.

Note: Image files must be in JPG, JPEG, or PNG format. Make sure URLs do not include trailing characters after .jpg, .jpeg, or .png.


Fixing Review Import errors

If some reviews fail to import, a CSV file containing errors will be sent to you by email. This file will indicate the reason each review failed, categorized into two types: File Formatting Errors and File Processing Errors.

Please update the CSV file based on the descriptions below and re-upload it following the same import process.

File Formatting Errors

These errors occur when the review data does not meet the required format.

ErrorDescriptionHow to fix
Product not foundThe value in the product_handle column is missing or does not match an active product in your store.Ensure it matches the last part of the product URL and is linked to an active product.
Review date invalidThe created_at field is missing or incorrectly formatted.Use the YYYY-MM-DD format (e.g., 2020-01-09).
Review date cannot be in the futureThe date in the created_at field is set in the future.Adjust it to a past date.
Reviewer name is missingThe author field is missing.Enter a reviewer name.
Review body is missingThe body field is missing.Ensure that all reviews include text.
Rating invalidThe rating field is missing or is not a whole number between 1 and 5.Use whole numbers only (1, 2, 3, 4, 5).
Photo URL invalidThe photo_url field is missing or incorrectly formatted.Ensure URLs link to valid JPG, JPEG, or PNG images.

File Processing Errors

These errors occur due to issues with the file itself.

ErrorDescriptionHow to fix
Missing columnsOne or more required columns are missing.Ensure all template columns are included.
Corrupted fileThe file is corrupted or unreadable.Try re-saving or exporting it again in CSV format.
File too heavyThe file exceeds the maximum allowed size (15MB max).Reduce the number of reviews or optimize the file size before uploading.
Empty fileThe file has no content or rows of data.Ensure it contains valid review information before uploading.

FAQs

Q: What is the maximum number of reviews I can import?

A: You can import up to 100,000 reviews per store using a custom file. After reaching this limit, additional imports will not be possible using this method. For assistance, contact support.

Q: How do I generate a photo URL?

  1. Save the relevant image to your computer.
  2. Go to your Shopify ״Files״ menu within "Content".
  3. Click "Upload files".
  4. Upload your image.
  5. Copy the photo link.

Related Articles

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article