How do I import reviews from a spreadsheet?

To import reviews from external sources, 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, and note the following for each of the columns:
    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
  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 this errors click here

Related Articles