Skip to main content
All CollectionsOkendo ReviewsGetting Started
Importing Reviews Using the Okendo Import Template
Importing Reviews Using the Okendo Import Template

Best practices and tips for importing reviews using the Okendo reviews import template

Jonathan Fulcher avatar
Written by Jonathan Fulcher
Updated over 2 months ago

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.

email

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:

  1. Confirm the exact attribute questions and answers.

  2. In Okendo, navigate to Attributes and build them to match what was set up with your previous review provider (case sensitive).

  3. Transfer the review export into the Okendo import template.

  4. 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.

Did this answer your question?