Importing Q&A into Yotpo
Importing Q&A into Yotpo
Article Summary
Share feedback
Thanks for sharing 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?