Adding Menu Data
Utilize the Menu Maintenance page to create new menu items and map them to a menu set.
Preparing Your Menu Items and Menu Set Data
Before importing or adding menu items to Decision Logic, it's important to get a full data pull of all menu items in your Point of Sale database into an excel sheet so that you can correctly build menu sets and account for all of the following situations:
Duplicate Menu Item Descriptions with different POS IDs
Although a common occurrence in the point of sale, Decision Logic does not support having the same menu item description with 2 different POS IDs on the same Adding Menu Data Menu Sets in Decision Logic. To solve this, there are 2 options:
Rename one of the duplicates in Decision Logic prior to importing via excel or when manually creating the menu item.
When you build the recipes, you can build the recipe for 1 item and then copy the recipe into the duplicate item.
Create an additional Menu Set that could contain the same-named menu item description using the different point of sale, this solution will require maintaining an additional menu set long term.
Duplicate POS IDs with different Pricing
We cannot have the same object # with 2 different prices in Decision Logic. If we did, you would have double depletion on that item. To solve this please pick a price and delete the row that has the price that you don’t need.
Incorrect menu item category
If your Menu items have not been created with the correct category, fix this in the point of sale and then reassign the menu item to the correct category in Decision Logic via the User Interface or in the import template prior to importing.
Incorrect Menu Item pricing
If your Point of Sale menu item has the incorrect price, you should correct the price in your point of sale system first.
Collecting Menu Item Information from the Point of Sale
Micros
Ask a Point of Sale administrator to use the query below to return the information needed for Menu Item Import out of micros. Results will look like this Example Micros Menu Item Export.csv
Use the following information for the Bulk Import process when doing Creating Menu Items and Importing Menu Items to a Menu Set.
Micros | Decision Logic |
---|---|
Menu Item Description | Menu Item Description |
Object Number | Point of Sale (POS) ID |
Family Group Name | Menu Category.
|
Price | Price |
{code:sql}
SELECT
MD.name_1 AS 'Menu Item Description'
,MD.obj_num AS 'Object Number'
,FD.name AS 'Family Group Name'
,PD.preset_amt_1 'Menu Item Price'
FROM MICROS.mi_def MD
JOIN MICROS.fam_grp_def FD ON MD.fam_grp_seq = FD.fam_grp_seq
JOIN MICROS.mi_price_def PD ON MD.mi_seq = PD.mi_seq
{code}
Aloha
File Needed: ITM.DBF
This file can be retrieved from any Aloha Dated Subdirectory.
Use the following information for the Bulk Import process when Creating Menu Items and Import Menu Items to a Menu Set.
ITM.DBF Header | Decision Logic Value |
---|---|
ID | Menu Item POS ID |
Short Name/Longname/Chitname | Any of these can be used for Menu Item Description in Decision Logic based on your preference. |
PRICE | Menu Item Price |
******NAME****** | Most groupings labeled ******NAME****** should be used as Menu Item category in Decision Logic. |
Open Excel first, then look for the ITEM.DBF and open the file.
Sort by Item Number to see menu item categories
Use anything labeled ******NAME****** as your Menu Item category in Decision Logic.
In the example below, BREAKFAST would be the menu item category for anything after that row until the next *** row begins.
If the Family Group as Menu Category does not exist in Decision Logic, the menu item will import to Uncategorized, and you will need to manually update the category on an item by item basis.
Searching Menu Items and Recipes
Navigate to Maintenance > Product > Menu Maintenance
The Menu Maintenance page displays two tabs in the upper right corner, Menu Items and Menu Sets.
The Menu Items tab allows the user to create new Menu Items, attach recipes, and add recipes to Menu Sets.
The Menu Sets tab allows the user to add, edit, or create new Menu Sets.
Related Article: see Menu Maintenance
© 2023 Knowledge Management Systems, LLC. Decision Logic. All Rights Reserved.
Table of Contents
- 1 Preparing Your Menu Items and Menu Set Data
- 2 Duplicate Menu Item Descriptions with different POS IDs
- 3 Duplicate POS IDs with different Pricing
- 4 Incorrect menu item category
- 5 Incorrect Menu Item pricing
- 6 Collecting Menu Item Information from the Point of Sale
- 7 Micros
- 8 Aloha
- 9 Searching Menu Items and Recipes
For additional questions or assistance, please submit a support ticket by visiting the Decision Logic Service Center.
If you'd like to receive news on software releases and product updates, please sign up for our email list.