Importing Reviews to Yotpo (Beta)

Goals and Outcomes

The self-service import feature allows eligible merchants to upload existing reviews into Yotpo. Merchants can migrate historical reviews, control how reviews are displayed, and validate imported data before it goes live.

In this article, you’ll learn how to import reviews, match file columns, review errors, and complete a self-service review import.

Feature Overview

The self-service import feature lets eligible merchants upload reviews using a CSV file. You can import up to 100,000 reviews at a time.

During the import process, merchants can map file columns to Yotpo fields, review validation results, fix errors, and complete the import directly from the Yotpo Admin. The feature supports flexible file structures and automatic column matching.

Getting Started

You can access the self-service import feature from your Yotpo Admin under the Reviews Moderation section.

Important
Before starting the import, make sure your product catalog is already imported into Yotpo. This is required because product reviews can only be associated with products that already exist in your catalog.

Feature Process

1. From your Yotpo Admin, go to Manage > Import Reviews.

2. Click on Request new import.

3. In the popup, select where the reviews were originally collected from.

   Select the most accurate source available. This helps Yotpo understand the origin of the reviews and apply the relevant authenticity policies.

4. Depending on the selected source category, choose the specific source from the dropdown.

5. Click Next.

Note

If you’re uploading custom question answers, make sure the custom questions are already created and published in Yotpo.

If the custom questions do not exist in Yotpo, you need to create and publish them before importing the file.

6. In the popup, select where the reviews were originally collected from.

   This helps Yotpo understand the origin of the reviews and apply the relevant authenticity policies.

7. Choose the specific source from the dropdown.

8. Click Next.

   

9. Upload your CSV file.

10. If you don’t have a file, download the template, fill in all required fields, and upload it.

11. Confirm that the imported reviews are genuine, accurate, and that you have permission to use them by selecting the checkbox.

12. Click Next.

Important

If the Product ID value is empty, the review is treated as a site review. If the review is a product review, the Product ID must be provided.

If you need help finding your Product IDs, see How to find your Product IDs.

Matching Your Columns

1. Match your file columns to Yotpo fields. Refer to the Column Definition section for more details about each column.

2. Columns are matched automatically when possible, even if column names or order differ.

   Note

   Column names in your file do not need to exactly match Yotpo’s column names. The system automatically detects and matches columns based on the data they contain. For example, a column named Product identification number can be automatically matched to Product ID.

   

   If a required column is missing, however, another column with similar name may be matched instead. Always review the matching results and adjust them if needed before proceeding.

   

   In addition, make sure the values within matched columns follow the expected format. For example, Review Score must contain numeric values from 1 to 5. If a matched column contains empty cells, you can set a default value to be applied for those rows before proceeding.

   • Required fields must be matched in order to proceed.

   • Required fields are listed at the bottom of the screen.

   • If any required field is grayed out, match it manually.

   • If all required fields are marked in green, you can proceed.

3. Click Next.

   

Reviewing and Fixing Errors

1. Review your file before submitting the import.

2. If a row shows an error, it will not be imported.

3. You can fix errors directly by editing the value inside the cell.

4. You can also reupload your CSV file and restart the import process.

5. Click Import.

6. Click Confirm import.

Note

After you confirm the import, it may take some time to process. The import will continue in the background.

Once processing is complete, the status in the Import History page will be updated, and you’ll receive an email notification.

Review Validation and Syndication Eligibility

Some reviews may be imported successfully but may not be eligible for syndication to external retailer or partner networks. This is because syndication eligibility is determined separately from import completion and is subject to platform and partner requirements. Reviews with proof of purchase or other qualifying validation signals may be eligible for syndication, depending on the review data and applicable requirements.

If imported reviews are not eligible for syndication, they may still be displayed on your direct-to-consumer site, depending on their review status and your display settings.

Viewing Import History

Go to Manage > Import Reviews.

In the Import History page, you can see the status of each import and how many reviews were submitted, imported successfully, or failed.

The import can take up to several hours to complete. You’ll receive an email notification when the import is complete.

• If the import is successful, the status is Done.

• If some reviews fail, a warning icon appears next to the imported count.

• In some cases, an import may not pass the automatic checks and will be marked as In Review. This means Yotpo is reviewing the import before completing it. No action is needed from you while the review is in progress. You’ll receive an email notification once the import either passes or fails manual review.

Column Definitions

Below is an explanation of each column you may see during the mapping step.

Review Details

• Product ID - The unique identifier of the product the review belongs to. This is a required column.

  Example:

  SKU-12345

  Important

  The Product ID column is required, which means it must exist in your CSV file. If you are uploading site reviews, leave the Product ID value empty. The system will automatically treat the review as a site review.

• Date - when the review was created. This is a required column. Criteria to meet:

  • Supported formats include YYYY-MM-DD and YYYY-DD-MM.

  • If the date format cannot be detected, the system validates the value using YYYY-MM-DD.

  • Example:

    2025-06-25

• Review Title - A short headline summarizing the review.

• Review Content - The main text of the review. This is a required column.

• Review Score - The rating given by the reviewer. This is a required column. Criteria to meet:

  • Must be numeric.

  • Expected values: 1–5. 1 being lowest, 5 being highest.

  • Words like Excellent, Good, Bad will not work and should be corrected before import or via default values.

Reviewer Information

• Display Name - The public name of the person who submitted the review and the name shoppers see next to the review.

  Display name formatting:

  • If one word is provided, it is displayed as is.

    Example:

    Nickname456

  • If multiple words are provided, the first full word and the initial of the last word are displayed.

    John P.

  • If the cell is empty, the name is displayed as Anonymous.

• User Type - Determines how the review is labeled in Yotpo.

  Supported values:

  • Verified Buyer

  • Verified Reviewer

  • Anonymous

  Important

  This column applies only to supported Premium and Enterprise accounts. All other plans import reviews as Anonymous.

• Email - The reviewer’s email address. This is a required column.

• Customer Country - The reviewer’s country. This is a required column.

Review Status

• Published - Determines whether the review is published after import.

  Accepted values:

  • TRUE - published.

  • FALSE - not published.

Comments

• Comment Content - A merchant reply associated with the review.

• Comment Public - Determines whether the comment is visible.

  Accepted values:

  • TRUE - published.

  • FALSE - not published.

• Comment Created At - The date the comment was created.

Media Attachments

• Published Image URL - A link to an image that should be visible on the review.

• Unpublished Image URL - A link to an image that should not be visible.

• Published Video URL - A link to a video that should be visible on the review.

• Unpublished Video URL - A link to a video that should not be visible.

Custom Questions fields

• Default form Age - An answer to the Age custom question. This column is part of the custom questions import template.

• Default form Free Text - An answer to a free-text custom question. This column is part of the custom questions import template.

Important

Custom question columns must match custom questions that already exist and are published in Yotpo. If you import answers for custom questions that are not previously created in your admin store, the import will fail.

Additional Fields

• Metaobject Handle - An internal reference field. Leave this empty unless instructed otherwise.

• Incentive Type - Indicates whether the review was submitted in exchange for an incentive.

  Accepted values:

  • Free product.

  • Coupon.

  • Paid promotion.

  • Loyalty points.

  • Employee review.

  • Other.

  • Yotpo coupon.

  • Yotpo loyalty points.

  Note

  This column is optional. You can leave it empty.

  If the column contains empty cells, you can select a default value during the matching step. The selected value will be applied to all empty rows.

How to Select a Default Value

You select a default value during the Matching Your Columns step, after you match your file column to a Yotpo field.

When a column is matched:

• You’ll see a dropdown under the Yotpo column.

• This dropdown lets you select a value.

• Any rows in your file where that column is empty will automatically use the selected value.

This is useful when:

• A column is optional.

• Some rows have values and others don’t.

• You want all empty rows to default to the same value.

Troubleshooting