When importing a menu, you may receive an error that needs to be fixed in the spreadsheet before it can be successfully imported into the BOHA! portal
“Please export the menu before importing again, check menu page, rows X, they are available in the menu but not available in the spreadsheet”
What it means: The item(s) in the specified row(s) are already available in the products list of the Menu Manager with the same name in that category
How to fix:
- If you do not want to share this menu item between menus, change the Button Label of the item so it is unique.
- If you do not want to share this menu item between menus, create a different category for this item to reside. This allows you to keep the Button Label the same and allows you to differentiate between the new item and the existing item.
- If you want to share this menu item between menus, delete the entire row from the spreadsheet and then import your menu. Then, in the Menu Manager, select the blue dot and then Manage Menu Items. From there, select the category and find the existing menu item. Check the box to enable the menu item on your menu and save your changes.
“A shelf life was not associated with its unit of measure”
What it means: The shelf life was not entered for an item, entered incorrectly, or the unit of measure was entered incorrectly.
How to fix:
- Make sure the shelf life column is filled out using only numbers
- Make sure that the Unit of Measure column contains only an “m” for minutes, “h” for hours, “d” for days, or “month” for months. These fields must be lowercase
“Column DisplayOrder not found”
What it means: A product in the menu was not assigned a Button ID.
How to fix:
- Make sure all products have a unique Button ID entered in the Button ID column. Ingredients do not require a Button ID
“ButtonLabel for product must be unique”
What it means: Two unique menu items (with different Button Labels) have been assigned the same Button ID
How to fix:
- Change the button ID of one or both items to a unique Button ID; this tells the portal the item is unique and that the menu items are not linked in any way
“Column Label Id not found”
What it means: A Label ID was not defined for the menu item.
How to fix:
- Enter a label ID using the “Labels” tab on the spreadsheet to specify what template the item should print on
“Please export the menu before importing again, check category page, category IDs 4, they are available in the menu but not available in the spreadsheet”
What it means: There is already a category in the same location with the same name.
How to fix:
- Delete the row of the new category and use the category ID of the existing category
- Slightly change the name of the new category. You can always edit the name of the category after importing the menu back into the portal
“Column: X needs to integer greater than or equal to 0.”
What it means: One or more cells in the nutritional data section contains something other than a number.
How to fix:
- Remove any characters from the nutritional data cells leaving only numeric values in these fields
Other/Not specified above
How to fix:
- Check that that cells containing Button Labels, Modifier Labels, Captions, or custom fields exceed 100 characters
- Check that all items have been added to the table on the spreadsheet. They have been successfully added if the rows alternate between blue and white
- Check that the table has not been moved down in the spreadsheet. If a row was added above the headers, delete the blank row
- Make sure that no manual changes have been made in the portal (Menu Manager, Label Designer, Settings) since the menu was exported and that no new label templates, styles or categories have been created. If one of these has happened, you will need to export the menu again to reflect these additions then you may proceed with your menu edits