Skip to main content

Quick Menu Setup with CSV Files

Build your whole menu yourself from two CSV files

L
Written by Lucien Hopkinson

The quickest way to load a full menu is with two CSV files: one for products and one for product variants (modifiers). You can import them yourself in Nomni Console.

Before you start

  • Who: a Nomni Console user whose role can edit products.

  • Device: a computer with a spreadsheet program and Nomni Console open in a browser.

  • Save both files as .csv, not .xlsx.

1. Create the Products CSV file

Fill in one row per product with these columns:

  • Product Code: a unique code for each item.

  • Product Name: the name shown on the POS.

  • Product Category: the group it belongs to, for example Lunch or Tea.

  • Taxable: TRUE or FALSE.

  • Price Including Tax: the full price.

2. Create the Product Variants CSV file

First add a row for the variant group (the parent):

  • Name: the group name, for example Coffee modifiers.

  • Include Qty: TRUE to allow a value more than once, for example 2 × cheese.

  • Force Selection: TRUE if staff must pick at least one option.

  • Auto Selection: TRUE if the values start selected.

  • Single Selection: TRUE if only one option can be picked.

  • Max Selection: the most values that can be picked. 0 means no limit.

  • Product Code: the products that use this group. Separate several codes with a semicolon (;) and no spaces.

Then add one row for each value under it:

  • Parent: the group name the value belongs to.

  • Value Name: for example Almond milk.

  • Value Code: a unique code.

  • Price: the extra charge for that value, for example 0.50.

3. Import your files

  1. Go to POS > POS Settings > Bulk Import.

  2. Under Import To, click Products, then Select CSV File. Choose your Products file and click Import.

  3. Under Import To, click Product Variants, then Select CSV File. Choose your Product Variants file and click Import.

What you should see: your products in Products > Products and your groups in Products > Product Variants.

4. Create a default menu

  1. Go to iPad Menu > POS Menu.

  2. Click Add POS Menu and give it a name.

  3. Click the Edit (pencil) button.

  4. Click Create Default Menu. A menu is built from your products.

  5. Click Publish.

  6. On your Master POS, run a Master Sync.

What you should see: your menu buttons on the POS after the Master Sync.

If something goes wrong

  • Import failed: open the DataNotImport file that downloads. It shows the row, field and reason. See Bulk Import.

  • You don't have a Nomni Console account yet: send us both files and we will load them for you.

Need help?

Email support@nomni.ai or message us from the chat in Nomni Console. Tell us your venue name, the device and what you have already tried.

Did this answer your question?