Importing Reviews From a Spreadsheet

You can import reviews from any previous source using the Loox import spreadsheet.

In this article, we will detail how to import reviews via CSV file and how to fill in the reviews' information correctly.

IN THIS ARTICLE

Importing with Google Sheets

To import reviews using the free spreadsheet app Google Sheets:

  1. Open the link here

  2. Copy the file:

  3. Fill in the review data according to the instructions in the spreadsheet below.

  4. Download the spreadsheet as a CSV file.Click "File" > "Download" > "Comma-separated values (.csv, current sheet)"

  5. Upload the file in the Import reviews settings section tab on your Loox admin:

Loox will send an import summary email to the address listed on your Shopify account. This email specifies how many reviews were successfully imported.

Note: Our spreadsheet method is limited to 100,000 reviews per store. Once you have reached the 100,000 quota, you will no longer be able to import reviews using this method:

A CSV file that includes all the reviews that weren't uploaded will be attached to that email:

To fix these errors, click here.

Review data formatting

Important: Do not rename or remove any of the columns, including the column titles.


Column Title Description Example
product_handle (Required)  The handle is the last part of the product URL (after "/products/").For example, for this product: store.com/products/blue-t-shirt, the handle is blue-t-shirt.Please don't enter the product title or the full product URL. blue-t-shirt 
rating (Required)  Valid values are 1/2/3/4/5.Please use whole numbers only.  5 
author (Required)  Reviewer name.The name will appear on the review exactly as inserted here. John D. 
email   Reviewer's email address.You can leave this column empty if you don’t have the customer’s email address. [email protected] 
body (Required)  Review text.All Loox reviews have to include a review body. Great shirt, I loved it! 
created_at (Required)  Review submission\creation date.Must be in the following format: YYYY-MM-DD.The date must appear as Year-Month-Day. Loox will not accept other formats. 2020-01-09
photo_url  A public URL for the review photo. cdn.shopify.com/photo.png 
verified_purchase  Marking "TRUE" will add a "Verified purchase" badge to the review. Leaving the cell empty will not add the badge. TRUE 

If you don’t have a photo URL, you can create one by following these instructions:

  1. Save the relevant images to your computer.
  2. Go to your Shopify settings - Files.
  3. Click "Upload files".
  4. Choose one of the images and upload it.
  5. Copy its photo URL from the "URL" column once it has been uploaded.

Importing with Microsoft Excel

To import reviews using Microsoft Excel:

  1. Download the Loox Import File Template.

  2. Fill in the review data according to the instructions in the spreadsheet above:

  3. Save the file in a CSV UTF-8 supported file format (To save in UTF-8, click here):

  4. Upload the file in the "Import Reviews" settings section on your Loox app:

Loox will send an import summary email that specifies how many reviews were successfully imported.

A CSV file that includes all the reviews that weren't uploaded will be attached. To fix these errors, click here.

Importing reviews for inactive products on your store

To import a review to your account, that review must be linked to an active product on your store.

With that being said, if you have reviews that you cannot attribute to a specific product (the product no longer exists, store reviews, etc.), you can still display these reviews on pages where all reviews from all products appear (i.e. 'Happy Customers' page, homepage widget, etc.).You can do this by importing them to a new unavailable product.

To import reviews of products that don't exist on your store:

  1. Create a new product in your store (we suggest calling it "Reviews"):

  2. Mark the product as unavailable by removing it from all sales channels:

  3. Add your review data to a Loox import spreadsheet.

  4. In the "product_handle" column, please use the new, unavailable product's handle, which you can find within the "SEO" section of the product:

  5. Follow the import instructions as usual and import your file.
  6. Your reviews will now appear on all widgets that are set to display all reviews from all products.

If you have any questions regarding this workaround or need help importing your reviews, feel free to contact our Support team at [email protected], and we’d be more than happy to help!