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).
Understanding The Template Fields
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 eitherhandle
,productId
orsku
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 eitherhandle
,productId
orsku
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 eitherhandle
,productId
orsku
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 therating
.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, therating
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
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 to download a detailed version of your import report as a CSV by clicking the "Downloading Import Report" button.
In the last column of this CSV, Okendo will identify the status of any included reviews. If a review was rejected in the upload Okendo will identify the exact reason why it was rejected.