Upload quiz questions, answers and product matching to Lantern using a CSV file.
You can include everything in one file, or upload your questions and answers first and add product matching separately. You can also export existing product matching, edit it in Excel or Google Sheets, and import your changes.
Step 1. Prepare your CSV file
The first row contains the column names. Each row below it contains one answer.
Questions and answers
Use these columns to create your questions:
Question: The question text. Repeat the same question text for each answer belonging to that question.
Type: The question type:
single,multiple,dropdownordropdown multiple.Answer: The answer text.
You can include product matching in the same file. If you prefer, upload your questions and answers first, then add product matching later.
Product matching
Product Matching controls which products, variants and collections each answer recommends or excludes.
Use these columns to include product matching:
Products: Product handles, such as
night-cream. A handle is the last part of a product’s URL. For example, the handle inhttps://yourstore.com/products/night-creamisnight-cream. You can also enter a SKU or a full product URL.Variants: Variant SKUs. For a variant without a SKU, use the product handle followed by
?variant=and the variant ID. For example:night-cream?variant=4412345678.Collections: Collection handles.
To enter several items in one cell, separate them with a vertical bar (|):
night-cream | day-cream
For more information, see How to Recommend the Correct Product Variant and Can I link entire collections to my quiz?.
Excluded products, variants and collections
Use Excluded products, Excluded variants and Excluded collections to list the items an answer excludes.
Enter them in the same format as the Products, Variants and Collections columns.
See What are Excluded Products? for more information.
Match All and Exclude All Other
Match all products: Use
yesto enable Match All, ornoto turn it off.Exclude all products: Use
yesto enable Exclude All Other, ornoto turn it off.
See How does the match all feature work? for more information.
Answer weights
The Weight column sets the answer’s weight. Enter a whole number from 0 to 10000. The default is 100.
See What are answer weights? for more information.
Step 2: Save the file as CSV
Excel: Go to File → Save As and select CSV UTF-8.
Google Sheets: Go to File → Download → Comma-separated values (.csv).
Step 3: Import your questions and answers
3.1 Open your quiz in the Quiz Builder.
3.2 Click Add Page and select Import from a Spreadsheet.
3.3 Choose your CSV file.
Lantern adds the questions and answers from the file. If you included product matching, it is added too.
If you uploaded only questions and answers, you can set up product matching in the Products step or import it separately.
The CSV file does not include the quiz’s design. You can customise this separately inside the quiz editor.
Step 4: Export existing product matching
Exporting gives you a spreadsheet of your quiz’s current product matching. You can edit the file or use it to copy product matching to another quiz.
4.1 Open your quiz in the Quiz Builder and go to the Products step.
4.2 In the Spreadsheet card on the left, click Export.
Lantern downloads a CSV file named after your quiz. It contains one row for each answer, with its product matching settings.
Products, variants or collections that no longer exist in your store are left out. Lantern shows a message with the number left out.
Please note: Separate recommendations for returning customers are not included.
Step 5: Add or edit product matching in your spreadsheet
5.1 Open your CSV file in Excel or Google Sheets.
When importing product matching into existing questions, Lantern uses the Question and Answer text to find each answer. Keep this text the same as it appears in your quiz. Capitalisation does't matter.
The Type column is only used when creating questions. It is not used when updating product matching.
5.2 Edit the cells for the items you want to change.
To remove all items from a list, clear its cell. For example, clearing an Excluded products cell removes all excluded products from that answer.
5.3 Keep existing settings that don't need modifying
Keep a setting unchanged: Delete its column from the file. For example, a file with only Question, Answer and Products updates only the matched products.
Keep an answer unchanged: Delete its row. Answers not included in the file keep their current product matching.
Keep an answer’s weight unchanged: Leave its Weight cell blank.
5.4 Save the edited file as CSV.
Step 6: Import new product matching into existing questions
6.1 Open your quiz in the Quiz Builder and go to the Products step.
6.2 In the Spreadsheet card, click Import.
6.3 Click Choose a CSV file, or drag the file into the upload box.
6.5 Review the preview and any warnings.
6.5 Click Update answers. The button shows how many answers will be updated.
This updates product matching for existing answers. To create new questions and answers, use Add Page → Import from a Spreadsheet instead.
Product matching changes are saved to the quiz’s draft. Publish the quiz to apply them to the live quiz.
Check the product matching import preview
The preview shows how many questions and answers will be updated. Nothing changes until you click Update answers.
You may see the following warnings.
Products, variants or collections were not found
Lantern could not find an item using the handle or SKU in your file. The answer will still be updated, but that item will not be included.
If two variants have the same SKU, use the product handle and variant ID instead:
night-cream?variant=4412345678
A question or answer was not found
The Question or Answer text does not match anything in the quiz. The warning shows the row number from your spreadsheet.
Check the text against your quiz before importing.
Questions have the same text
If two questions have identical text, Lantern cannot tell which question the row belongs to. Those rows are skipped.
Give the questions different text, or edit their product matching directly in the Products step.
A setting could not be read
The Match all products and Exclude all products columns must contain yes or no. Weight must be a whole number from 0 to 10000.
If a value is not valid, that setting keeps its current value.
Copy to another store
To copy an entire quiz, including its design, to another store, use Import-Export Quizzes.
You can also import a product matching CSV file into a quiz in another store. Products and collections must have matching handles. Variants identified by SKU must have matching SKUs.
Variants identified using ?variant= only work in the store they were exported from.
If you have any questions, contact our support team, and we’ll be happy to help!