Importing Reviews with Yotpo Support
Import your existing reviews to Yotpo with the help of the Yotpo support team.
Use this workflow if all the following apply:
- Your current eCommerce platform is not Shopify, or you’re using Shopify on an annual plan
- You want to import product and/or site reviews you collected outside of Yotpo
- If this isn’t you, see Importing Reviews through the Yotpo Interface
Free and monthly Yotpo plans are limited to a certain number of imports per account:
- Free - 1 import
- Monthly - 5 imports
- Annual - Unlimited review imports
Legal disclaimer
When creating this import request, you re-affirm the representations, warranties, and covenants relating to all Imported Reviews in accordance with the Terms of Service in effect between Yotpo and you. Without limiting the foregoing, you hereby represent, warrant, and covenant that:
- The reviews and ratings that you import are and at all times will be bona fide reviews submitted to you by actual customers
- To the best of your knowledge, the information included within the imported reviews, including without limitation, customer email address, review rating, and review date, is accurate,
- You are using Yotpo's import feature to capture all bona fide reviews of which you are or reasonably should be aware and legally have the rights to use
- You will not otherwise use Yotpo's import feature for any deceptive purposes, including without limitation, to alter your average review score.
Failure to comply with the foregoing terms shall constitute a material breach of the Terms of Service and may result in the termination of your Yotpo account
Importing reviews directly from your platform
If you're using a native reviews solution for one of the following platforms, there's no need to create an import file.
Simply follow the relevant guide to easily import your reviews into your Yotpo account:
Shopify
Follow the instructions in the Shopify help center.
- If you are on the Platinum or Enterprise plans, please send the file over to our support team using the online form.
- If you are on the Free, Growth, or Prime plans, please see the see Importing Reviews through the Yotpo Interface article.
BigCommerce
You can import reviews directly from BigCommerce native reviews app. The import process is done via BigCommerce API, so there is no need to export or manually handle files.
To import the reviews you'll first need to install the BigCommerce native reviews app and Yotpo Reviews on your store:
Once you're done, submit a support ticket with the following text:
Please import my Bigcommerce reviews into Yotpo.
Send me a file with the data from BigCommerce to review before importing - Yes / No
Apply Verified Buyer badge - Yes / No
Thank You.
Please note:
Since BigCommerce reviews don't fully match Yotpo's format, certain types of data may be modified or lost.
Known Yotpo-BigCommerce format mismatches / limitations:
- Reviews with no content - Review will not be imported
- Reviews with no title - Title will be imported with the first 4 words of the content
- Reviews without a user display name - These reviews will be imported as "Anonymous"
- Reviews will be imported by default with an "Anonymous" badge. If you are importing reviews by Verified Buyers, please be sure to mention it in your ticket
Please note:
Since BigCommerce does not require a product image, products may be imported into Yotpo without an image. If you want to associate images to such reviews please let us know through the ticket. Some of our features utilize product images and we strongly recommend adding them.
WooCommerce
- Log into the Yotpo plugin within your Wordpress admin.
- Click Export Reviews in the bottom left hand corner of the Yotpo plugin.
- Once you have exported your reviews, send the files to Yotpo Support via the online support form, and Yotpo will import the reviews for you.
If you are unable to export your Yotpo reviews using this process, please open the following page in your Woocommerce FTP:
wp-content\plugins\yotpo-social-reviews-for-woocommerce\classes\class-wc-yotpo-export-reviews.php
Change the following in line 130:
$current_review['product_description'] = $this->cleanContent($product_instance->get_post_data()->post_excerpt);
into this line:$current_review['product_description'] = $this->cleanContent(get_post($value->product_id)->post_excerpt);
Try exporting the reviews again as you did before.
Volusion
Exporting reviews:
- From the header options, choose “Inventory”. Then click on “Import/Export”.
- Click on “Standard Export”
- Choose “Export from Reviews”
- Click “Check All”.
- Choose "CSV" as the File Format
- Click "Export"
- Download the file
Exporting product information:
- From the same screen, choose Export from Products.
- Make sure to check the following fields:
- ProductCode
- ProductName
- ProductDescription
- ProductDescriptionShort
- METATAG_Description
- From the "Virtual Columns" box, make sure to check the following fields:
- ProductURL
- PhotoURL
- Choose "CSV" as the File Format.
- Click Export.
- Download the file.
- Use the online support form to send the files and Yotpo will import the reviews for you.
Importing reviews using an import file
If you’re not using a native review solution from one of the platforms listed above, you’ll need to prepare an import file. An import file is just a detailed inventory list of your reviews.
Step 1: Prepare the import file
To create the file, you’ll need a standard spreadsheet application (like Excel or Google Sheets) and the correct information for each review.
Step 2: Create the import file
Download the relevant reviews template file and open it with your spreadsheet application of choice. The downloaded file contains an example of a filled-out review. Please make sure to erase it before sending us the file:
Fill the template with the relevant data. For a breakdown of the downloaded template, including column names, explanations, and examples of data per column and whether this data is required or optional in order to import the review, refer to the file guidelines.
Step 3: Submit reviews for import
Use the online support form to submit the file.
Make sure of the following:
- You review the legal disclaimer and include the message "I accept Yotpo's Terms of service" within the support form.
- You specify the Yotpo account ID for which to import the reviews.
Importing reviews from one Yotpo store to another
As a certified Google partner, Yotpo's internal policies don't allow importing reviews from one store to another (as they might be counted as duplicated content) and require the use of syndication. This feature is available on selected Yotpo plans only. For more information please contact us via the online support form.
Importing reviews with user-generated photos
Yotpo’s advanced plans include the User Generated Photos feature, which allows you to import images uploaded by your reviewers.
You can import up to three images per review.
Column name | Description |
---|---|
published_image_url(Required) | The URL of an image that has been published via the Moderation section of your Yotpo Admin. Multiple images must be separated by semicolons without any spaces (";") |
unpublished_image_url(Required) | The URL of an image that has not been published via the Moderation section of your Yotpo Admin. Multiple images must be separated by semicolons without any spaces (";") |
Importing reviews with custom review form questions
- Fill in the Custom Review Form data in the relevant column:
Column Name | Description | Examples of Column Titles |
---|---|---|
cf_Y__X | Y is the name of the form exactly as defined in the form. X is the question's display title exactly as defined in the form. | "cf_Shoes__Comfort" Or "cf_Form Name__Display Title" |
If your form name and display title consist of more than one word, there should be space between the words as such: cf_Form Name__Display Title
Filling in reviewers' answers to customer-related questions:
The answer should be the actual raw text of the answer, exactly as defined in the form. A customer-related question can receive:
Question Type | Description | Example |
---|---|---|
Radio Buttons | Single choice answers | |
Checkboxes | Multiple-choice answers Multiple answers must be separated by commas without any spaces (",") | |
Free-text answers | Free text with customizable min/max character limits | Purchase Experience How would you describe your overall purchase experience? |
Filling in reviewers' answers to product-related questions:
The answer should be a numerical value representing the answer (either 1 to 5, or 1 to 3), except for free text answers, which should be added exactly as written by the reviewer.
A product-related question can receive:
- Answers in the form of 1-5 rating
- Answers relating to fit in 1-3 rating
- Free-text answers (Free-text with customizable min/max character limits)
- Use the online support formto submit the file. Please make sure:
- You specify the Yotpo account ID for which to import the reviews
- Review the legal disclaimer and include the message "I accept Yotpo's Terms of service" within the support form
For more information on Custom Review Forms, visit our Custom Review Forms guide.
File guidelines
Review the guidelines below to help you prepare your import file.
Product review guidelines
Column Name | Description | Example |
---|---|---|
product_id (Required) | The product ID of the product on the store page. To learn how to find your product ID, refer to Finding Product IDs in Your E-Commerce Platform. The product ID may be shown as SKU in the file you export from your store platform. Please make sure you have the correct product ID in your import file. | 2134234 or BD1929 or BD-8383 |
product_title (Required) | The title/name of the product | T-shirt |
product_url (Required) | The URL of the product on your store | https://YOURSHOP.com/products/T-shirt |
date(Required) | The date the review was written. Make sure the date format is consistent across the entire date column. The review date must be within the past 15 years and cannot be a date in the future. | The recommended format isYYYY-MM-DD.Example: 2016-12-02 |
review_content(Required) | The content of the review as written by the customer | I just bought this T-shirt and I absolutely love the look! |
review_score(Required) | The star rating given by the customer (value between 1 and 5) | 5 |
review_title(Optional, but highly recommended) | The title of the review as written by the customer. If the review does not have a title, Yotpo will use the first four words of the review's content as its title. | My New T-shirt |
email(Required) | The email of the reviewer | mike@email.com |
display_name (Required) | The name provided by the reviewer | Mike Johnson |
md_customer_country(Required) | The two-letter abbreviation of the reviewer country used in the Google Seller Feed. If not provided, the default value will be US. | US |
product_image_url(Optional, but highly recommended) | The URL of the product image. This allows the review to display the product's image in the Reviews Carousel and when pushed to social media platforms. To find your product image URL: Right-click the product image while hovering over it and choose Copy image address. Then, paste the copied link into the corresponding box in your import file. | https://mystore.com/imagecatalog/RS2200/bicylce.jpg |
product_description(Optional) | The product description as it appears on your product page | The best, coolest T-shirt ever made. Made of 100% cotton and 110% love. |
metaobject_handle (Shopify only) | A Metaobject handle ID is a unique ID generated for a review in Shopify. The purpose of this field is to prevent duplicate reviews in Shopify Metaobjects. To learn more, see Shopify's help center | 12345-fe28285a-4b39-4993-8f57-db3cfbf53a95 |
Some reviews may have associated comments from the store owner, or other users. If you wish to import these comments, please fill out the following columns:
Column Name | Description | Example |
---|---|---|
comment_content (Optional) | The content of the comment associated with the review | Hey Mike! Glad to hear you're enjoying your new T-shirt! |
comment_public (Optional) | The comment is public (true) or private (false) | True |
comment_created_at (Optional) | The date the comment was created | The recommended format is YYYY-MM-DD For example, 2016-12-02 Make sure the date format is consistent across the entire date column. |
published_image_url | Only relevant to users with plans that include the User Generated Photos feature. Click here for more information on how to fill in these columns. | https://mystore.com/imagecatalog/RS2200/bicylce.jpg |
unpublished_image_url | Only relevant to users with plans that include the User Generated Photos feature. Click here for more information on how to fill in these columns. | https://mystore.com/imagecatalog/RS2200/bicylce.jpg |
published_video_url | Only relevant to users with plans that include the User Generated Videos feature. Click here for more information on how to fill in these columns. | |
unpublished_video_url | Only relevant to users with plans that include the User Generated Videos feature. Click here for more information on how to fill in these columns. | |
cf_Y__X | Only relevant to users with plans that include the Custom Reviews Form feature. Click here for more information on how to fill in these columns. |
Site review guidelines
Column name | Description | Example |
---|---|---|
review_content(Required | The content of the review as written by the customer | My package arrived super fast! Really happy with the shop! |
date(Required) | The date the review was written. Reviews submitted over 10 years ago will not be imported. | The recommended format is YYYY-MM-DD. Example: 2016-12-02 |
review_score (Required) | The star rating given by the customer (value between 1 and 5) | 5 |
review_title(Optional, but highly recommended) | The title of the review as written by the customer. If the review does not have a title, Yotpo will use the first four words from the review content as the title for that review. | Amazing shipping |
display_name(Required) | The name provided by the reviewer | Mike J. |
email(Required) | The email address of the reviewer | mike@email.com |
Some reviews may have associated comments from the store owner, or from other users. If you want to import these comments, you’ll need to fill out these columns:
Column Name | Description | Example |
---|---|---|
comment_content (Optional) | The content of the comment associated with the review | Hey Mike! Glad to hear you're enjoying your new T-shirt! |
comment_public (Optional) | The comment is public (true) or private (false) | True |
comment_created_at (Optional) | The date the comment was created. Make sure the date format is consistent across the entire date column. | The recommended format isYYYY-MM-DD. Example: 2016-12-02 |
published_image_url | Only relevant to users with plans that include the User Generated Photos feature. Click here for more information on how to fill in these columns. | https://mystore.com/imagecatalog/RS2200/bicylce.jpg |
unpublished_image_url | Only relevant to users with plans that include the User Generated Photos feature. Click here for more information on how to fill in these columns. | https://mystore.com/imagecatalog/RS2200/bicylce.jpg |
cf_Y__X | Only relevant to users with plans that include the Custom Reviews Form feature. Click here for more information on how to fill in these columns. | |
md_customer_country | The two-letter abbreviation of the reviewer country used in the Google Seller Feed. If not provided, the default value will be US. | US |
published(Optional) | The comment is published (true) or not published (false) | True |