Skip to main content

How to bulk import and export your menu with CSV files (Nomni Ordering console)

Download your menu, edit it in a spreadsheet and import it back

L
Written by Lucien Hopkinson

Quick answer: Log in to your Nomni Ordering console, go to Menu > Bulk Import/Export and click Export Data to download your current menu first. Then follow the steps below.

In the Nomni Ordering console you can download your whole menu as CSV files, edit products and prices in a spreadsheet, and import the files back. This saves editing products one by one.

Before you start

  • POS-integrated stores (for example Lightspeed or Nomni POS): change products and prices in your POS, then re-import and sync. See Adding / Editing a Product & Price.

  • Who: a console user with the Bulk Import permission (Admin > Users > the user > permissions).

  • Device: a computer.

  • Download your current files first so you have a backup.

Download your current menu

  1. Log in to your Nomni Ordering console.

  2. Go to Menu > Bulk Import/Export.

  3. Click Export Data.

  4. Click Download Product File and Download Attribute File.

What you should see: two CSV files with your current products and attributes.

Import products

  1. On Menu > Bulk Import/Export, open Import Product CSV.

  2. If you are starting from scratch, click Download Templete for the template.

  3. Keep the columns in this order: id, name, active, plu, category, description, size group, size, price, deal surcharge, free, topping group, included ingredients, extra ingredients, other options.

  4. Save the file as .csv.

  5. Drop the file onto Drop Product file here or click to upload.

Import attributes (extras and options)

  1. Open Import Attribute CSV.

  2. Keep the columns in this order: id, name, active, plu, group, price.

  3. Don't include toppings that are already in the product file as included or extra ingredients.

  4. Drop the file onto Drop Attribute file here or click to upload.

If something goes wrong

  • You don't see Bulk Import/Export: ask your console admin to give you the Bulk Import permission.

  • The upload is rejected: only .csv files are accepted. Check the columns are in the order above.

  • Prices look wrong online: open one product in Menu > Menu Categories and check its sizes and prices.

Need help?

Email [email protected] or message us from the chat. Tell us your store name, your console address and what you have already tried.

You can also call 1300 445 483.

Related Articles
Did this answer your question?