Importing Reviews through the Yotpo Interface
Importing Reviews through the Yotpo Interface
Article Summary
Share feedback
Thanks for sharing your feedback!
Import your existing product reviews to Yotpo directly through the Yotpo interface.
Use this workflow if all of the following apply:
- Your current eCommerce platform is Shopify
- You’re on a Yotpo Free, Growth, or Prime plan
- You want to import product reviews you collected outside of Yotpo
If any of the below applies, please import your reviews using Yotpo Support:
- You’re using a different e-commerce provider
- You’re on a Yotpo annual plan
- You want to import site reviews
- You want to import answers to custom questions
Getting started
Follow the steps below to import your product reviews to Yotpo.
- In your Yotpo Reviews menu, go to Settings > Import Reviews.
- Identify the relevant solution for your needs:
- If you collected the reviews using any of the providers below, you should skip to Importing from a supported provider.
- Shopify Reviews
- Loox
- Judge.me
- Okendo
- Stamped.io
- Junip
- Feefo
- If you collected the reviews from a different provider, you should skip to Importing reviews using our template.
- If you collected the reviews using any of the providers below, you should skip to Importing from a supported provider.
Good to know
- Reviews that are imported to Yotpo will automatically be treated as anonymous reviews. Learn more about reviewer badges
- You can import comments and images with your reviews. You’ll see the reviews right away in the moderation panel but pictures and comments can take up to 3 hours to appear. If you don't see them right away, please check back later.
Importing from a supported provider
Import reviews you collected using Shopify Reviews, Loox, or Judge.me quickly and easily.
Do the following:
- From your relevant provider, export the reviews you want to import to Yotpo. Make sure your reviews file is saved in CSV format. For further guidance, refer to the help center for your provider:
- Click Upload from provider. A popup displays, requesting you to verify that your reviews are genuine.
- Check the box to confirm, and then click Import reviews.
- Navigate to the location where you saved your file, and double-click the file. Your file will now be uploaded to Yotpo.
If your upload is completed successfully, you’re done! You can view your imported reviews in the Yotpo moderation panel by clicking See imported reviews.
If the import did not complete successfully, we recommend you try importing your reviews using our template instead.
Importing reviews using our template
Prerequisites
Before you begin, you’ll need the following:
| Prerequisite | Description |
|---|---|
| Shopify product handle | A product handle is a unique name for each product and is found in the product page URL. For example, for a product with the page URL https://yourstore.myshopify.com/products/minimal-surfboard, the product handle will be minimal-surfboard. How to find the product handle:
|
| Standard spreadsheet application | If you’re importing from a reviews provider other than Shopify Reviews, Loox, or Judge.me, you’ll need a spreadsheet application to open our template file. Either Excel or Google Sheets will work great. |
Importing your reviews
To import reviews you collected using our template, do the following:
- In your Yotpo Reviews menu, go to Settings > Import Reviews.
- Select Other from the dropdown menu.
- Download the CSV template file to your computer.
- Once downloaded, open the file with a spreadsheet application of your choice.
- Add the existing reviews to your file. To avoid any errors, make sure you closely follow our file guidelines.
- Save the CSV file to your computer.
- Once the file is complete, go to Settings > Import Reviews and click Upload file.
Fixing errors
If your upload is completed successfully, you’re done! You can view your imported reviews in the Yotpo moderation panel by clicking See imported reviews.
If the import fails, we’ll help you fix any errors so you can import your file successfully. To help you successfully complete your import, we’ll prepare a file containing only the reviews that failed to upload, along with instructions on how to fix the errors. The reviews that were uploaded successfully are already waiting for you in the Yotpo moderation panel.
To complete the import:
- Click Download report. A CSV file will be downloaded to your computer.
- Use the Error column on the left to identify what caused the error and fix it. When you’re done, you can delete this column or leave it as it is - either way, we’ll be able to read your file.
- Save the file in CSV format.
- Click Upload file to try the upload again.
File guidelines
Before you upload your file, please verify the following:
- Your file must not contain more than 5,000 reviews. If you need to import more, we suggest you perform the import in batches.
- Your file size must be no larger than 25 MB.
- The column names must be written exactly as displayed in the table below.
- Your file must include all of the required column headers.
Importing using Excel?
To avoid experiencing any formatting issues, please follow our guidelines for Importing CSV Files Into Excel. The table below contains a breakdown of the downloaded template, including column names, explanations, and examples of data per column. Use it to help you fill out the template.
| Column Header Name | Required? | Description | Example |
|---|---|---|---|
| Shopify Product Handle | Required | The unique name for your product, found at the end of the product page URL. It can contain letters, dashes, and numbers, but no spaces, accents, or other characters, including periods. | bike-storage-hoist |
| Review Creation Date | Required | The date the review was left by the reviewer. Valid formats: YYYY-MM-DD, MM-DD-YYYY, MM-DD-YY | 2021-01-31 |
| Review Content | Required | The text of the review, as submitted by the shopper. | I love the way this bicycle hoist works and am very happy with it. |
| Review Score | Required | The review score left by the shopper. Can be any whole number between 1 and 5. | 4 |
| Review Title | Optional | The title of the review, as submitted by the shopper. | Xtreme Bicycle Ceiling Hoist |
| Reviewer Display Name | Required | The name of the shopper, as it is displayed on-site. | Carol S |
| Reviewer Email | Required | The email address of the shopper. This won’t display on-site but it’s required for commenting, re-sending review requests, and integrations. | carol@email.com |
| Publish Review | Required | Indicates if the review is published to your site. Valid values:- TRUE- FALSE | TRUE |
| Comment Content | Optional | The shop owner’s response to the review content. | Thank you for your kind words! |
| Comment Date | Optional | The date the shop owner responded to the review. Valid formats: YYYY-MM-DD, MM-DD-YYYY, MM-DD-YY | 2020-02-01 |
| Review Image URLs | Optional | The URL(s) for the image(s) uploaded by the shopper. | https://yotpo-production.s3.amazonaws.com/self-service-reviews-import/example_file/Shoes1.png, https://yotpo-production.s3.amazonaws.com/self-service-reviews-import/example_file/Shoes2.png,https://yotpo-production.s3.amazonaws.com/self-service-reviews-import/example_file/Shoes3.png |
Was this article helpful?
