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 a week ago

Introduction

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.

Important: 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).

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

Understanding The Template Fields

Important: To import Site Reviews or Seller Ratings, 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 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

  • 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 (okendo_import_status), Okendo will identify the status of any included reviews.

For any issues with importing, contact your dedicated Onboarding/Customer Success Manager, or email support@okendo.io.

Did this answer your question?