Template Introduction

To get started, download the Okendo Import Template CSV. Within this document, each row represents a single review. To fill out the template, simply enter the relevant details under the correct header for each row. Our example import file shows how a single review could be imported using the template.

Important: Do not modify the header columns in the template file as this could prevent Okendo from recognizing the import. For reviews which do not require certain fields, leave them blank.

Once completed, save the document and export it as a CSV file making sure the text encoding is UTF-8. The exported file is then ready to be uploaded to your store in the Okendo admin (Settings > Import/Export).

To avoid formatting issues, it is recommended to use Google Sheets.

Understanding The Template Fields

Important: If you are looking to import Site Reviews or Seller Ratings, please use the ProductID column with the cell data 'site_review'

Required Fields

name : The reviewer's name.
body : The body of the review.
handle : The Shopify product handle of the product for which the review was written. Can most often be found at the end of the URL when viewing a product page on your site. (At least one of either handle , productId or sku is required).
productId : The Shopify product ID for which the review was written. Can most often be found at the end of the URL when viewing a product in the Shopify admin area. This is the recommended way to match reviews to products. (At least one of either handle , productId or sku is required).
rating : The star rating. Values of 1-5 are supported.
sku : The SKU (Stock Keeping Unit) of the product for which the review was written. (At least one of either handle , productId or sku is required).
dateCreated : The date when the review was written. For best results, see the Formatting Dates section.

Additional Fields

countryCode : The two letter country code representing the location of the reviewer. For example, use us to represent a reviewer from the United States or au for reviewers from Australia. To see our full list of country codes click here.
email : The email address of the reviewer.
imageUrls : The urls of any images associated with the review. Multiple images can be imported by separating each url with a comma (,).
isApproved : Should the review be shown on your live site. Use "true" if the review should be shown on your store website or "false" if it requires further moderation before being shown on your store website. If not provided, "false" will be used.
isRecommended : Would the reviewer recommend the product to a friend. Use "true" if they recommend the product or "false" if they don't. If not provided, the value will be inferred from the rating.
rejectedImageUrls : The urls of any unpublished images associated with the review. Multiple images can be imported by separating each url with a comma (,).
reply : The reply to the review.
replyDateCreated : The date the reply was written. For best results, see the Formatting Dates section.
replyIsPublic : Should the reply be shown on your live site. Use "true" if the reply should be shown on your live site, otherwise use "false". If not specified, "true" will be used.
title : The title of the review. If not provided, the rating is used to build a default title (eg. 5 Stars).
videoUrls : The urls of any videos associated with the review. Multiple videos can be imported by separating each url with a comma (,).
isVerifiedBuyer : Did the reviewer order the product from your store directly. Use "true" if the reviewer ordered the product from your store directly, otherwise use "false". If not provided, "false" will be used.
variantId : The Shopify variant ID of the product for which the review was written.

Formatting Dates

The importer works best when dates are formatted using the following formats:

Dates should by yyyy-MM-dd where yyyy represents the year, MM the two digit month and dd the two digit day. For example, 8th June 2018 would be represented as 2018-06-08.
Times should be HH:mm:ss where HH represents the hours in 24 hour time, mm the two-digit minutes and ss the two digit seconds. For example, 48 seconds past 4:25pm would be represented as 16:25:48.

Both the date and time for each review should be joined together using a space or a 'T' character and be contained within a single field of the template. A joined date-time field could look like this: 2018-06-08 16:25:48

Importing Attributes with Reviews

If you need to import reviews with Attributes, action the following:

Confirm the exact attribute questions and answers
In Okendo, head to Attributes and build the attributes to match exactly what was set up with your previous review provider (case sensitive).
Re-map/transfer the review export into the Okendo import template
For each attribute asked, make a new column at the end of the Okendo template (example below)
- Range Attributes: Numbers are on a scale of 1 - 5. For example, if it says "Excellent" you would put 5 (column Y).
- Center Range Attributes: Numbers are on a -1, 0, 1 scale. For example, "Runs Small" would be -1, "True to Size" would be 0 and "Runs Large" would be 1 (column X).
- Select Attributes: These must match exactly as they are created in Okendo (columns Z and AA).
  - More than one attribute should be separated by a comma. For example attribute 1, attribute 2, attribute 3

Import Report

After you have successfully submitted your import, our system will process the file and send the account owner an email with a short summary of the import.

You will also be able to download a detailed version of your import report as a CSV by clicking the "Downloading Import Report" button.

An alternative way to download the import report is to go to Settings > Import/Export > clicking on the download button beside the import (see screenshot below):

In the last column of this CSV (okendo_import_status), Okendo will identify the status of any included reviews. See the screenshot below for an example: