Skip to main content

Importing Q&A

Updated over a week ago

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.

To prepare your CSV to import Q&A:

  1. 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.

  2. Fill in your Q&A content with this format:

Column header

Required

Description

question_id

No

the unique ID of each question

  • If provided, answers can be grouped together under one question

  • If you group several rows under one question_id, we'll take the question_content from the first row in that group.

question_content

Yes

the content of the question

moderated

No

  • Write "ok" to publish the question.

  • Write "spam" to hide the question.

  • If left blank, the question will be published automatically upon import.

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
product_handle

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:

  1. From your Google Sheet screen, go to File > Download.

  2. Select Comma Separated Values (.csv).

Then upload the file you just downloaded to Judge.me:

  1. From your Judge.me admin, go to the Reviews section.

  2. Navigate to the Customer questions tab.

  3. In the top-right corner, click Import.

  4. Click Add files, then upload your file in .csv, .xls, or .xlsx format.

  5. 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.

Did this answer your question?