Importing Menus Using a CSV

updated 3 mths ago

Marqii allows you to export and import menus into your dashboard using a CSV file.

CSV's can contain multiple menus. (Click here for a CSV template).

Exporting Menus

To export menus:

Click on the Menus tab
From the Menus page, click on the boxes for the menu(s) you would like to export
Click on the Actions button
Click Export

Importing Menus

To import your CSV:

Click on the Menus tab
From the Menus page, click on Import Menu
A drawer will open with the file uploader
1. You can use the uploader to select a file from your computer
2. You can drag a file into the uploader
  Note: This file must be a CSV (comma-separated values) file.
Once your Menu is uploaded, you will see a confirmation showing how many new, edited, and removed menus, sections, or items will be imported into your account.
1. Click Save to complete the import into your account
2. Click Cancel to cancel the process.

CSV Menu Structure

How to setup your Menu CSV file

(Template here)

The column titles and breakdowns for columns should be as follows:

Column - id (the ID for your menu)
Column - name (the name of menu)
Column - description (the description for your menu)
Column - visible (the visibility setting for your menu, "TRUE" to make it visible, "FALSE" to make it hidden)
Column - sectionId (the ID for your section)
Column - sectionName (the name of your section)
Column - sectionDescription (the description of the section)
Column - cuisines (the type of food the Menu lists. must be one of "Cuisines" values listed below)
Column - itemId (the ID for your item)
Column - itemName (the name of your item)
Column - itemDescription (the description for your item)
Column - itemPrice (the price for your item)
Column - itemCalories (the total calories of your item)
Column - itemSpiciness (must be one of "Spiciness" values listed below)
Column - itemAllergens (may be one or many of the "Allergens" items listed below)
Column - itemDietaryRestrictions (may be one or many of the "Dietary Restrictions" items listed below)
Column - itemTotalFat (the total fat in grams of your item)
Column - itemCholesterol (the total cholesterol in milligrams of your item)
Column - itemSodium (the total sodium in milligrams of your item)
Column - itemTotalCarbohydrates (the total carbohydrates in grams of your item)
Column - itemIngredients (a list of ingredients separated by the "|" separator ie: Tumeric|Dill|Basil)
Column - itemServesNumPeople (the number of people the dish serves)
Column - itemPortionSizeValue (the amount of an item are included in an order, for "24 wings" this would be 24)
Column - itemPortionSizeLabel (kind of portion included in an order, for "24 wings" this would be wings)
Column - itemPreparationMethods (may be one or many of the "Preparation Methods" items listed below)
Column - itemChoices (the choices for your item)

Menu, Section, and Item IDs

New Menus, Sections, or Items

If you are creating new menus, sections, or items you need to leave the ID columns blank. These columns include:

the Menu ID column if you are adding a new menu
the Section ID column if you are adding a new section
the Item ID column if you are adding a new item

Doing this will allow the Marqii to create these IDs and assign them.

Existing Menus, Sections, or Items

If you are updating your existing menus, sections, or items, the IDs in the relevant columns must match the IDs already assigned to them.

For this reason we recommend exporting your menus first and then editing the exported CSV data.

Visibility

You can set the visibility for each of the menus you are uploading using the "Visible" column (column D). To set the visibility for your menu, you can enter TRUE for menus you would like to show, and FALSE for menus you would like to hide.

Note: TRUE and FALSE must be in all uppercase/capital letters when importing your CSV.

The value in the first row for your menu will dictate whether your menu will be hidden or shown.

Item Choices

To input Item choices into your CSV:

Each choice must be separated by a pipe "|" symbol with no spaces
ie: Small|Medium-2.5|Large-3
To input a price for your choice, add a dash with the choice price next to your choice without the dollar sign.
ie: Medium-2.5