Frequently asked questions, or FAQs, are a great way to improve your customer's knowledge of the products. With our Awesome plan, you can enable the Q&A badge and widget on your product page.
This article will show you how to import your questions and answers to show in this widget in 4 easy steps.
4 steps to import questions and answers via CSV
Step 1: Download the CSV template
You can download our sample CSV file for questions and answers using the link below.
To edit the file, you can:
- Login to Google Sheet and create a new sheet.
- Click File > Import > Upload and select the file CSV you downloaded above.
- In Import location, choose Replace current sheet and check the box Convert text to numbers, dates, and formulas.
- Click Import data.
Step 2: Fill in the questions and answers
Here's what each of the columns in the CSV file means:
|question_id||optional||the unique code of each question|
|question_content||required||the content of the question|
If left blank, the question will be published automatically upon import.
|source||optional||the source of the question|
|asker_email||optional||the email of the person who asked the question. If not provided, we will autogenerate a dummy email instead.|
|asker_name||optional||the name of the person who asked the question. If not provided, we will use "anonymous" instead.|
|either is required||You just need to fill in either the product_id or produt_handle. Here's how to find these values:|
|question_date||optional||the date when the question is submitted (in dd/mm/yyyy format). If not provided, the current date will be used.|
|answer_id||optional||the unique code of each answer|
|answer_content||optional||the content of the answer. If not provided, the question will be created without answers.|
|answerer_email||semi-optional||the email of the person who answered the question. Need to be provided together with the answerer_name. If not, the shop name and email will be used instead.|
|answerer_name||semi-optional||the name of the person who answered the question. Need to be provided together with the answerer_email. If not, the shop name and email will be used instead.|
|answer_date||optional||the date when the answer is submitted (in dd/mm/yyyy format). If not provided, the current date will be used.|
Step 4: Upload the file to Judge.me
- When you're done editing the Google Sheet, you can download it as a CSV file by choosing File > Download > Comma Separated Value (.csv).
- Then in Judge.me admin, click Import & Export.
- Then choose Import/Export Q&A > Import Q&A.
- Select Q&A Source as Direct.
- Choose your CSV file then click Import Q&A.
Step 4: Review the results
After you upload the CSV file, you'll be automatically redirected to the Questions and Answers dashboard. We will process the file in the background and send a notification email with the details to all email addresses listed in Settings > Review request > Admin Notifications.
In this email, you can check how many questions and answers have been imported, how many have failed and the reason they failed to import.
You will see the successfully imported questions and answers in the dashboard after a few minutes.