You can import Q&A content into your store using our CSV template. This process works whether you're migrating Q&A from another app or manually creating your own set of questions and answers.
Before you import
To import Q&A into Judge.me, you’ll first need to prepare a CSV file containing your questions and answers in the correct format.
If you're importing Q&A from another app, you can copy-paste the data from your old app export into the corresponding columns.
If you're creating your own Q&A from scratch, you can manually enter your desired questions and answers into the relevant columns.
Importing Q&A via a CSV file does not trigger any notification emails to customers. The Q&A answer notification email is only sent when a question is answered manually through the Judge.me dashboard. You can safely import questions with pre-filled answers without any emails being sent to your customers.
To prepare your CSV to import Q&A:
Open our Q&A Google Sheet template and click Make a copy to start editing. This template includes all required columns and example values to guide you.
Fill in your Q&A content with this format:
Column header | Required | Description |
question_id | No | the unique ID of each question
|
question_content | Yes | the content of the question |
curated | No |
|
source | No | source of the question |
asker_email | No | email of the person who asked the question |
asker_name | No | name of the person who asked the question. If not provided, we will use "anonymous". |
product_id | either is required | You just need to fill in either the product_id or product_handle. |
question_date | No | the date the question is created (dd/mm/yyyy). If not provided, the current date will be used. |
answer_id | No | the unique ID of each answer |
answer_content | No | the content of the answer. If not provided, the question will be created without answers. |
answerer_email | No | 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 | No | 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 | No | the date the answer is created (dd/mm/yyyy). If not provided, the current date will be used. |
Import your Q&A to Judge.me
Once you've finished adding reviews to your file, download it to your computer:
From your Google Sheet screen, go to File > Download.
Select Comma Separated Values (.csv).
Then upload the file you just downloaded to Judge.me:
From your Judge.me admin, go to the Reviews section.
Navigate to the Customer questions tab.
In the top-right corner, click Import.
Click Add files, then upload your file in
.csv,.xls, or.xlsxformat.Once uploaded, click Import to complete the process.
After you import
The import will take around 5 minutes. Once it's finished, we will email you the results, including:
How many questions and answers were successfully imported
How many questions and answers failed to import, plus a CSV file of these failed reviews, and why they failed
You can find all your questions and answers in the Reviews section > Customer questions tab.
