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 Title

Description

Example

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.
email The 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_url Public URL(s) of review images (comma-separated for multiple images). cdn.shopify.com/photo.png
verified_purchase Enter 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 erors

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.

Error

Description

How to Fix

Product not found The 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 invalid The 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 future The date in the created_at field is set in the future. Adjust it to a past date.
Reviewer name is missing The author field is missing. Enter a reviewer name.
Review body is missing The body field is missing. Ensure that all reviews include text.
Rating invalid The 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 invalid The 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.

Error

Description

How to Fix

Missing columns One or more required columns are missing. Ensure all template columns are included.
Corrupted file The file is corrupted or unreadable. Try re-saving or exporting it again in CSV format.
File too heavy The file exceeds the maximum allowed size (15MB max). Reduce the number of reviews or optimize the file size before uploading.
Empty file The 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.

Learn more

If you have any questions, contact our Support team at [email protected]. We’re available 24/7 and happy to help!

Still need help? Contact Us Contact Us