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, as well as 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 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.
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 the last "/").

For example, for this product: store.com/products/blue-t-shirt the handle is blue-t-shirt.

Please make sure not to 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. 
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 HH:mm:ss UTC. Must at least include a date.

The date must appear as Year-Month-Day, other formats will not be accepted.
2020-01-09 08:45:00 UTC 
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 tab, on your Loox admin:
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

In order 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 can be found within the "SEO" section of the product:

  5. Continue following 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 if you need help importing your reviews, please contact our Support team and we'll gladly advise!