Importing reviews from a spreadsheet

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 it as CSV before import to Loox.

    1. Click "File" > "Download" > "Comma-separated values (.csv, current sheet)".
    06.04.2020-09.26.png
  5. Upload the file in your "Import Reviews" tab:

Fill in the review data according to these instructions:

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.

5
author (Required)
The name of the customer

(The name will appear on the review exactly as inserted here)

John D.
email 
You can leave this column empty if you don’t have the customer’s email address

[email protected]
body (Required)
The text of the review

Great shirt, I loved it!
created_at (Required)
Must be in the following format: YYYY-MM-DD HH:mm:ss UTC.

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/example_photo_url.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 
Copy its photo URL from the "URL" column once it has been uploaded 

To import reviews using the downloaded CSV file, please follow these instructions:

  1. Download the Loox Import File Template

    Please insert all review data below the existing column headers in the file: 2929c2d85be4773b39c02caa92dfa396.png

  2. Fill in the data of reviews you’d like to import acording to the instructions listed 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 your "Import reviews" tab:

You will receive an import summary email which includes a drill-down of how many reviews were imported successfully and how many were not imported due to errors. 

Attached to this email will be a CSV file which includes all of the errors that have stopped your reviews from uploading as expected.

To fix these errors click here

Related Articles