Overview
This article describes how to prepare questions and answers for importing by Yotpo.If you want to re-use existing Q&A when migrating to Yotpo, you can provide information from any platform.
Important
If you have more than one account, you need to create an import file for each account
You cannot import questions that do not have answers
How it Works
You can import questions and answers (Q&A) into Yotpo to preserve customer content when migrating from another platform.
Imports are handled by Yotpo Support and must be submitted in the correct file format.
Download the import template
Open the file using a spreadsheet tool such as LibreOffice or Google Sheets.
When you finish editing, export or save it as either CSV (UTF-8) or Excel (.xlsx) format.
Important
If you’re using Excel, don’t open a UTF-8 CSV file directly. Instead, import it to preserve special characters.
Complete the template with the appropriate information filled in according to the following guidelines:
All fields are mandatory.
Ensure that the product-id in your file matches the product-id on your website for every product.
Make sure the date format is consistent across the entire date column. The recommended format is YYYY-MM-DD, for example, 2016-03-21.
When you import Q&A to Yotpo, they are automatically published to your website. Edit the files before you send them to Yotpo to remove any Q&A you do not want to be published.
If a question has multiple answers, create a row for each answer with the same question_id, question poser and product data (see rows 1 and 2 of the template for an example).
You cannot have multiple answers for the same question from the same user email.
Save the file either as Excel (.xlsx) or a .csv file in UTF-8 encoding. Other formats, such as Apple Numbers, are not supported,
To save an Excel file in UTF-8 format:
Select Save As in the File menu.
Select Web Options in the Tools menu near the Save button.
Select Encoding.
Select Unicode (UTF-8) in the Save this document as: drop-down list.
Click OK.
Click Save.
Please note that these instructions depend on the version of Excel you're using.
To ensure the CSV File is in UTF-8 encoding:
Open the file in Windows Notepad.
Select Save As in the file menu.
Select UTF-8 encoding in the Encoding dropdown menu next to the Save button in the Save As dialog box. Make sure to only select the Tab and Comma Separator Options.
Save the file using a new name.
Go through the checklist below before you submit your files to Yotpo Support.
Selecting the Tab and Comma Separator Options:
Checklist:
Target account ID for the Q&A import: To find your account ID, click here
Verify product IDs
Remove any questions you do not want to be published
Verify that all the mandatory fields are filled
Remove invalid strings of characters that were converted from emoji into UTF-8
Verify the product URLs and product image URLs are valid - The URLs should open the product page.
Verify that the character encoding is UTF-8
Verify that the file format is Excel (.xlsx) or CSV (comma separated values) - commas between the data, and inverted commas as the text delimiters, for example:
question_id,question_content,question_user_email,question_user_name,question_created_at,product_sku,product_title,product_description6. Use the online support form to send the files and Yotpo will import the Q&A for you. Specify the Yotpo account ID for which to import the Q&A.
Note
Yotpo Support will contact you when the questions and answers have been imported.
Finding your account ID
To find your account ID, do the following:
Log into Yotpo Reviews.
Click
in the top right corner of your screen.Select the Account Settings tab.
Click the Store tab. Your Yotpo Account ID is shown at the top of the Store Settings tab.
Finding product IDs
To find your product IDs, please click here.
Import Q&A template
Field | Mandatory | Description | Example |
|---|---|---|---|
question_id | X | The unique id of the question. | 1 |
question_content | X | The content of the question | What colors does the T-shirt come in? |
question_user_email | X | The email of the user who asked the question | johndoe@email.com |
question_user_name | X | The name of the user who asked the question | John Doe |
question_created_at | X | The date the question was asked in YYYY-MM-DD format | 2016-03-21 |
product_sku | X | The sku (product ID) | 1 |
product_title | X | The name of the product | Yotpo T-shirt |
product_description | X | The description of the product on the store | Yotpo-branded T-shirt |
product_url | X | The url of the product on your store | http://magento.yotpo.com/index.php/yotpo-products/yotpo-t-shirt.html |
product_image_url | X | The url of the product image | http://magento.yotpo.com/media/catalog/product/cache/1/image/9df78eab33525d08d6e5fb8d27136e95/2/0/2011-12-19_15.13.05_large.jpeg |
answer_content | X | The answer added by a customer or the store owner | Only in a stylish blue at the moment |
answer_user_email | X | The email of the person who answered | jane_smith@domain.com |
answer_user_name | X | The name of the person who answered | Jane Smith |
answer_created_at | X | The date the answer was created | 2016-03-23 |
Note
All fields are mandatory
One product may have multiple questions
One question may have multiple answers
If a question has multiple answers, create a row for each answer with the same question_id, question poser and product data (see rows 1 and 2 of the template for an example)
You cannot have multiple answers for the same question from the same user email
product_sku is the product_id