Using Okendo's review import functionality you are able to retain reviews and content that you have previously collected using either your own internal solution or competitor products.
Supported Imports
Okendo's review importer can automatically detect and import review exports from the following services:
Yotpo
Stamped
Loox
Junip
Shopify
TrustPilot
JudgeMe
Kudo Buzz
Social Shopwave
Orankl
If you are not migrating from one of the services above, please follow the steps below.
Getting started
To begin, download the Okendo Import Template CSV. Each row in this document represents a single review. Fill out the template by entering the relevant details under each header. Our example import file demonstrates how to import a review using the template.
βοΈDo not alter or delete the header columns in the template file, as this can prevent Okendo from recognizing the import. Leave fields blank for reviews that do not require certain information.
Once completed, save the document and export it as a CSV file, ensuring 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
π To import Site Reviews or Seller Ratings, use the ProductID column with the cell data 'site_review'. Please refer to Collecting Site Reviews.
Required fields
Field | Description |
name | The reviewer's name. |
body | The body of the review. |
handle | The Shopify product handle of the reviewed product. This is often found at the end of the URL when viewing a product page on your site. (At least one of handle, productId, or sku is required). |
productId | The Shopify product ID for the reviewed product, found at the end of the URL when viewing a product in the Shopify admin area. This is the recommended method for matching reviews to products. (At least one of handle, productId, or sku is required). |
rating | The star rating (values of 1-5 are supported). |
sku | The SKU (Stock Keeping Unit) of the reviewed product. (At least one of handle, productId, or sku is required). |
dateCreated | The date the review was written. For best results, see the Formatting Dates section. |
Additional Fields
Field | Description |
countryCode | The two-letter country code representing the reviewer's location (e.g., 'us' for the United States, 'au' for Australia). For the full list of country codes, click here. |
The email address of the reviewer. | |
imageUrls | URLs of images associated with the review. Separate multiple URLs with a comma (,). |
isApproved | Indicates if the review should be shown on your live site. Use "true" to display the review or "false" if it requires further moderation. If not provided, "false" will be used. |
isRecommended | Indicates if the reviewer recommends the product to a friend. Use "true" for recommendation or "false" otherwise. If not provided, the value will be inferred from the rating. |
rejectedImageUrls | URLs of unpublished images associated with the review. Separate multiple URLs 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 | Indicates if the reply should be shown on your live site. Use "true" to display the reply or "false" otherwise. 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 (e.g., 5 Stars). |
videoUrls | URLs of videos associated with the review. Separate multiple URLs with a comma (,). |
isVerifiedBuyer | Indicates if the reviewer ordered the product directly from your store. Use "true" if they did, otherwise use "false". If not provided, "false" will be used. |
variantId | The Shopify variant ID of the reviewed product. |
Formatting dates
The importer works best with the following date formats:
Dates: Use the format yyyy-MM-dd where yyyy is the year, MM is the two-digit month, and dd is the two-digit day (e.g., 2018-06-08 for June 8, 2018).
Times: Use the format HH:mm:ss. HH is the hours in 24-hour time, mm is the two-digit minutes, and ss is the two-digit seconds (e.g., 16:25:48 for 4:25:48 PM).
Join both the date and time in a single field using a space or 'T' character (e.g., 2018-06-08 16:25:48).
Importing attributes with reviews
To import reviews with Attributes, follow these steps:
Confirm the exact attribute questions and answers.
In Okendo, navigate to Attributes and build them to match what was set up with your previous review provider (case sensitive).
Transfer the review export into the Okendo import template.
For each attribute, create a new column at the end of the Okendo template (example below):
Range Attributes: Use numbers on a scale of 1 - 5 (e.g., 5 for "Excellent").
Center Range Attributes: Use a -1, 0, 1 scale (e.g., -1 for "Runs Small", 0 for "True to Size", 1 for "Runs Large").
Select Attributes: These must match exactly as created in Okendo.
Separate more than one attribute with a comma (e.g., attribute 1, attribute 2, attribute 3).
Import report
After submitting your import, our system will process the file and email the account owner a short summary of the import.
You can also download a detailed version of your import report as a CSV by clicking the "Downloading Import Report" button. Alternatively, go to Settings > Import/Export and click the download button beside the import.
In the last column of this CSV (okendoReviewImportStatus), Okendo will identify the status of any included reviews.
FAQs
My review import keeps failing. What should I do?
If your import is failing make sure to download the the import report CSV. The furthest column to the right will provide information for any rows that failed to import. Fix all issues noted in that column and try importing again. Most common are formatting issues or blank required fields. If the import continues to fail, please contact our support team
I deleted products in Shopify but added them back. Okendo import tool will not allow me to reimport the reviews to the new products.
Any reviews for deleted products will remain in Okendo, so there is no need to reimport. Please follow the steps in Moving Reviews to Another Product to restore reviews to products that were deleted and then added back to Shopify.
I have a newer version of a product. Can I export all reviews from the old version and import them to the new one?
As suggested above, we do not support the importing of existing reviews and therefore recommend simply moving your existing reviews. Another option is to create a product Group and share reviews between both products. This is a good option if you do not plan to delete the old version of the product from your store.
I have photo/video files I need to import, but not photo/video URLs. How do I get URLs?
If trying to import reviews with media, any images or videos need to be hosted online at a publicly accessible URL. You can use any hosting or file sharing service of your choice. We recommend using Files within Shopify: Shopify Settings > Content > Files. Once uploaded you can retrieve the URL of each photo/video. After your reviews have successfully been imported to Okendo, the media no longer needs to be hosted elsewhere.
My reviews import was successful but I don't see the reviews appearing on my store. How do I get them to appear?
Ensure that your review widgets are correctly installed on your store. For more information, reference our Widget Installation documentation.
β οΈ Rarely, there may be delays in the import process. If your import was successful and your widgets are properly configured, but you still do not see any imported reviews in the Okendo Admin or on your store, contact our support team.
How do I import reviews from other marketplaces such as Amazon or Etsy?
We do not recommend importing reviews from other marketplaces unless their terms & conditions explicitly allow you to do so. Amazon, for example, maintains all rights to any reviews and media submitted to their marketplace. Manually importing reviews from Amazon to Okendo may be a violation of their terms & conditions, which may lead to penalties or suspension of your Amazon Seller account.