Importing Q&A into Yotpo
Importing Q&A into Yotpo
Article summary
Did you find this summary helpful?
Thank you for your feedback
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.
Please note:
- 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
Importing Q&A
Yotpo Support can assist with imports of Q&A. To import the questions and answers:
Download the template:
- Use a spreadsheet application such as LibreOffice or Google Sheets CSV file in UTF-8 encoding.Please note:If you are using Excel, you must import the CSV file to preserve the encoding. If you open it, any special characters will be lost. Click here for instructions.
- 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.
- 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 |
Please 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
Was this article helpful?