Overview
Keep the reviews you've already collected when you move to Okendo. The review importer brings in reviews, photos and videos from another review platform or from your own system.
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
Moving from a service that isn't listed? Use the Okendo import template 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.
When you're done, export the file as a CSV with UTF-8 text encoding, then upload it in Okendo Admin > Settings > Import/Export.
💡 Use Google Sheets to avoid formatting issues.
Understanding the template fields
💡 To import site reviews or seller ratings, enter site_review in the productId column. See Collecting site reviews with Okendo.
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 Formatting dates below. |
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). See the Review import country code list. |
The email address of the reviewer. | |
imageUrls | URLs of images associated with the review. Separate multiple URLs with a comma (,). Supported image formats include: JPEG, PNG and HEIC. |
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. |
isIncentivized | Indicates whether an incentive was offered to the reviewer in exchange for writing this review. Use "true" to indicate that an incentive was offered or "false" if no incentive was offered. 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 Formatting dates below. |
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 (,). Supported video formats include: MP4, MOV (including HEVC videos from iPhones), M4V, WebM, MKV and AVI. |
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. |
status | Sets the status of imported reviews: pending: Reviews will appear in the moderation screen to be reviewed manually. approved: Reviews will be visible on site. rejected: Reviews will not be visible on site. |
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, go to Okendo Admin > Reviews > Attributes and create attributes that exactly match the ones from 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.
Example:
1
2
3
4
5
Centre Range Attributes: Use a -1, 0, 1 scale.
Example
-1
-0.5
0
0.5
1: Runs Large
Select Attributes: These must match exactly as created in Okendo, including punctuation and capitalization.
Separate more than one attribute with a comma (e.g., attribute 1, attribute 2, attribute 3).
Import report
After you submit your import, Okendo processes the file and emails the account owner a short summary.
To download a detailed import report as a CSV, click Downloading Import Report, or go to Okendo Admin > Settings > Import/Export and click the download button beside the import.
The last column of the CSV, okendoReviewImportStatus, shows the status of each review.
FAQs & Troubleshooting
Q: My review import keeps failing. What should I do?
A: Download the import report CSV. The last column on the right explains why any rows failed. Fix those issues and import again; the most common causes are formatting issues and blank required fields. If the import still fails, contact our support team.
Q: I deleted products in Shopify and added them back. Why can't I reimport their reviews?
A: Any reviews for deleted products will remain in Okendo, so there is no need to reimport. Follow the steps in Moving Reviews to Another Product to restore reviews to products that were deleted and then added back to Shopify.
Q: I have a newer version of a product. Can I export all reviews from the old version and import them to the new one?
A: Okendo doesn't support re-importing existing reviews, so we recommend moving your existing reviews instead. 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.
Q: I have photo/video files I need to import, but not photo/video URLs. How do I get URLs?
A: Host each photo or video at a publicly accessible URL. You can use any hosting or file sharing service; we recommend Files in Shopify: Shopify Settings > Content > Files. After you upload a file, copy its URL into the template. Once your reviews are imported, the media no longer needs to be hosted elsewhere. Photos in HEIC format and videos in HEVC format, the defaults on iPhones, can be imported as they are; you don't need to convert them first.
Q: My reviews import was successful but I don't see the reviews appearing on my store. How do I get them to appear?
A: Check that your review widgets are installed correctly on your store. See Installing Okendo on Shopify Online Store 2.0.
⚠️ 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.
Q: How do I import reviews from other marketplaces such as Amazon or Etsy?
A: 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.