Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Aloha Menu item in database explanation

Status
Not open for further replies.

RitwickGupta

Programmer
Aug 21, 2014
96
CA
Hello.

I am trying to re-create menu on Aloha system outside it on my website through it's database. The following is a single row from the table "items_table"

{
"id": 20305.0,
"ownerid": 0.0,
"usernumber": 20305.0,
"shortname": "feta ",
"chitname": "feta ",
"longname": "feta ",
"longname2": " ",
"bohname": " ",
"abbrev": " ",
"taxid": 10.0,
"taxid2": 0.0,
"vtaxid": 0.0,
"priority": 255.0,
"routing": 0.0,
"printonchk": "N",
"combine": "N",
"highlight": "Y",
"surcharge": 0.0,
"surchrgmod": "N",
"cost": 0.0000,
"mod1": 0.0,
"mod2": 0.0,
"mod3": 0.0,
"mod4": 0.0,
"mod5": 0.0,
"mod6": 0.0,
"mod7": 0.0,
"mod8": 0.0,
"mod9": 0.0,
"mod10": 0.0,
"askdesc": "N",
"askprice": "N",
"isrefill": "N",
"vrouting": 0.0,
"is_kvi": 0.0,
"trackfoh": "N",
"price_id": 0.0,
"price": 0.000,
"slavetoitm": 0.0,
"defweight": 1.0,
"sku": " ",
"modprice": "N",
"itemmult": 0.0,
"itempercnt": 0.00,
"modpriceid": 0.0,
"mod_price": 0.00,
"ampri": 1.0,
"neverprint": "N",
"prtrecipe": 0.0,
"nogratuity": "N",
"compositid": 0.0,
"adisprecp": "N",
"independnt": "N",
"printheld": "N",
"donotshow": "N",
"donotshwm": "N",
"showndpnt": "N",
"giftcert": "N",
"itemhilite": "N",
"delaytime": 0.0,
"label": 0.0,
"guests": 0.00,
"siteflags": 0.0,
"flextax": 0.0,
"cashcard": "N",
"storeacc": 0.0,
"parentacc": 0.0,
"concept": 0.0,
"multiplier": 1.0,
"sku2": " ",
"sku3": " ",
"sku4": " ",
"sku5": " ",
"revitem": "N",
"con1stmod": "N",
"chitjust": 0.0,
"chitbold": "N",
"flextax2": 0.0,
"dntshwsm": "N",
"swtrcksm": "N",
"giftcard": "N",
"gcactivate": "Y",
"gcaddvalue": "N",
"tokenover": "N",
"tokenqty": 0.0,
"guestwght": 1.000,
"dntshwsmmd": "N",
"usebkclr": "N",
"bkred": 192.0,
"bkgreen": 192.0,
"bkblue": 192.0,
"usetxtclr": "N",
"txtred": 0.0,
"txtgreen": 0.0,
"txtblue": 0.0,
"dispbmp": "N",
"bitmapfile": " ",
"hidetxt": "N",
"chitname2": " ",
"ctxpnlid": 0.0,
"mdspctxpnl": "N",
"pizza": "N",
"topping": "N",
"inittop": 0.0,
"pizzasize": 0.0,
"mustbwhole": "N",
"fraction": "N",
"fractype": 0.0,
"fracprcovr": 0.0
}



Does anyone have a clue about what do these fields mean. Some are straight forward, but other's are a bit confusing
 
Every field is a part of the Item.dbf
some require text, some are from a dropdown menu and some are check boxes
id": 20305.0,

"ownerid": 0.0,
"usernumber": 20305.0, Item number in Aloha
"shortname": "feta ", What the servers and barteners see
"chitname": "feta ", What the Kitchen sees
"longname": "feta ", What the guest sees
"longname2": " ", Option name for reports
"bohname": " ",
"abbrev": " ",
"taxid": 10.0, First tax
"taxid2": 0.0, second tax if needed
"vtaxid": 0.0,
"priority": 255.0, Used to have items print higher on a chit no matter how ordered
"routing": 0.0, where does it need to print
"printonchk": "N", does the guest check need to see it
"combine": "N", If it were a modifier with a price should it add to the base amount
"highlight": "Y",
"surcharge": 0.0, If you use surchages on items
"surchrgmod": "N",
"cost": 0.0000, How much it cost to make
[highlight #FCE94F]"mod1": 0.0,
"mod2": 0.0,
"mod3": 0.0,
"mod4": 0.0,
"mod5": 0.0,
"mod6": 0.0,
"mod7": 0.0,
"mod8": 0.0,
"mod9": 0.0,[/highlight] All for modifiers drop down menu
"mod10": 0.0,
"askdesc": "N", Used for open items
"askprice": "N", Used for open price
"isrefill": "N", used for refills for sodas
"vrouting": 0.0,
"is_kvi": 0.0,
"trackfoh": "N",
"price_id": 0.0,
"price": 0.000, How much to charge guest
"slavetoitm": 0.0,
"defweight": 1.0, if using scales
"sku": " ", If using bar codes
"modprice": "N",
"itemmult": 0.0,
"itempercnt": 0.00,
"modpriceid": 0.0,
"mod_price": 0.00, Used if mod has price like add cheese
"ampri": 1.0,
"neverprint": "N",
"prtrecipe": 0.0,
"nogratuity": "N", if price is added but do not what to have grat added, thing corkage or door charge
"compositid": 0.0,
"adisprecp": "N",
"independnt": "N",
"printheld": "N",
"donotshow": "N",
"donotshwm": "N",
"showndpnt": "N",
"giftcert": "N", used for gift certs will not effect sales
"itemhilite": "N",
"delaytime": 0.0,
"label": 0.0,
"guests": 0.00,
"siteflags": 0.0,
"flextax": 0.0,
"cashcard": "N",
"storeacc": 0.0,
"parentacc": 0.0,
"concept": 0.0,
"multiplier": 1.0,
"sku2": " ",
"sku3": " ",
"sku4": " ",
"sku5": " ",
"revitem": "N",
"con1stmod": "N",
"chitjust": 0.0,
"chitbold": "N",
"flextax2": 0.0,
"dntshwsm": "N",
"swtrcksm": "N",
"giftcard": "N", is it gift card
"gcactivate": "Y", activate gift card
"gcaddvalue": "N", add value to already existing card
"tokenover": "N",
"tokenqty": 0.0,
"guestwght": 1.000,
"dntshwsmmd": "N",
"usebkclr": "N",
"bkred": 192.0,
"bkgreen": 192.0,
"bkblue": 192.0,
"usetxtclr": "N",
"txtred": 0.0,
"txtgreen": 0.0,
"txtblue": 0.0,
"dispbmp": "N",
"bitmapfile": " ",
"hidetxt": "N",
"chitname2": " ",
"ctxpnlid": 0.0,
"mdspctxpnl": "N",
"pizza": "N", Used for 1/2 1/2 pizza
"topping": "N",
"inittop": 0.0,
"pizzasize": 0.0,
"mustbwhole": "N",
"fraction": "N",
"fractype": 0.0,
"fracprcovr": 0.0
}

If you were going to build a menu outside of Aloha, the only fields you should touch are Shortname, chit name, long name, cost and price. All others should be done in aloha. DO NOT CHANGE the item numbers.
After you finish be sure to run dbconfig from the bin file before opening in Aloha.

AlohaRoss
 
I am not able to understand what are those mods pointing to?

mod1": 0.0,
"mod2": 0.0,
"mod3": 0.0,
"mod4": 0.0,
"mod5": 0.0,
"mod6": 0.0,
"mod7": 0.0,
"mod8": 0.0,
"mod9": 0.0, All for modifiers drop down menu

In my menu, Mod of French Toast points to A drink, which does not make sense.

Also, Steak has Modifiers on the terminal like Cooking temperature, but I can't see that relation on the JSON

{
"id": 4010.0,
"ownerid": 0.0,
"usernumber": 4010.0,
"shortname": "Steak Sand ",
"chitname": "Steak Sand ",
"longname": "Steak Sand ",
"longname2": " ",
"bohname": " ",
"abbrev": " ",
"taxid": 10.0,
"taxid2": 0.0,
"vtaxid": 0.0,
"priority": 255.0,
"routing": 1.0,
"printonchk": "N",
"combine": "N",
"highlight": "N",
"surcharge": 0.0,
"surchrgmod": "N",
"cost": 0.0000,
"mod1": 10005.0,
"mod2": 0.0,
"mod3": 0.0,
"mod4": 0.0,
"mod5": 0.0,
"mod6": 0.0,
"mod7": 0.0,
"mod8": 0.0,
"mod9": 0.0,
"mod10": 0.0,
"askdesc": "N",
"askprice": "N",
"isrefill": "N",
"vrouting": 0.0,
"is_kvi": 0.0,
"trackfoh": "N",
"price_id": 0.0,
"price": 12.000,
"slavetoitm": 0.0,
"defweight": 1.0,
"sku": " ",
"modprice": "N",
"itemmult": 0.0,
"itempercnt": 0.00,
"modpriceid": 0.0,
"mod_price": 0.00,
"ampri": 1.0,
"neverprint": "N",
"prtrecipe": 0.0,
"nogratuity": "N",
"compositid": 0.0,
"adisprecp": "N",
"independnt": "N",
"printheld": "N",
"donotshow": "N",
"donotshwm": "N",
"showndpnt": "N",
"giftcert": "N",
"itemhilite": "N",
"delaytime": 0.0,
"label": 0.0,
"guests": 0.00,
"siteflags": 0.0,
"flextax": 0.0,
"cashcard": "N",
"storeacc": 0.0,
"parentacc": 0.0,
"concept": 0.0,
"multiplier": 1.0,
"sku2": " ",
"sku3": " ",
"sku4": " ",
"sku5": " ",
"revitem": "N",
"con1stmod": "N",
"chitjust": 0.0,
"chitbold": "N",
"flextax2": 0.0,
"dntshwsm": "N",
"swtrcksm": "N",
"giftcard": "N",
"gcactivate": "Y",
"gcaddvalue": "N",
"tokenover": "N",
"tokenqty": 0.0,
"guestwght": 1.000,
"dntshwsmmd": "N",
"usebkclr": "N",
"bkred": 0.0,
"bkgreen": 0.0,
"bkblue": 0.0,
"usetxtclr": "N",
"txtred": 0.0,
"txtgreen": 0.0,
"txtblue": 0.0,
"dispbmp": "N",
"bitmapfile": " ",
"hidetxt": "N",
"chitname2": " ",
"ctxpnlid": 0.0,
"mdspctxpnl": "N",
"pizza": "N",
"topping": "N",
"inittop": 0.0,
"pizzasize": 0.0,
"mustbwhole": "N",
"fraction": "N",
"fractype": 0.0,
"fracprcovr": 0.0
}
 
Each item can have up to 9 modifier groups associated with it. Mod1 just means the first modifier group and Mod9 is the last group. All modifier groups are 5 digits, and contain items that would modify the parent item. For example, if I ring in a burger, I would have a mod group for temp that would prompt for Rare, Med Rare, Medium, Med Well, and Done. If you open up the modifier groups in Aloha, and look at mod group 10005, you would find the temp mods for your steak.

A quick google search will find you some websites that will give you detail on what dbf does what. There are quite a few. To save you some time, I included a dbf link here. Their list contains what each dbf is named, what it contains, and where it is used ( quick serv, table serv, or CDM ) Click here for the dbf list.

I agree with AlohaRoss. Depending on versions, sometimes editing an item in Aloha Manager can affect multiple databases. You should only touch Short, Chit, and Long names, plus Cost and Price. Aloha can and is finiky with its databases.

Please note:
If you are using regular Aloha Manager, you can edit the DBF's in NewData to your hearts content.
If you are using the New Aloha Manager ( standalone Configuration Center ), it is a SQL database that changes are committed to, not directly to DBF's. Any changes to DBF's will be lost at end of day
If you are using the hosted Configuration Center, all changes are committed to the cloud, downloaded to SQL, then converted at end of day.
 
Hey

That was very helpful. Thanks for the link.

Also how does aloha store different variants or sizes? Is that maintained by price levels?
 
Can you describe what you want to do?

In a previous life, we had multiple beer sizes. You could order, lets say, a Bud Light. If you were a loyalty member, the bartender/server modified the item with a mug modifier. If you wanted a pitcher, you could push the pitcher modifier. This way we did not have 3 Bud Light items. It allowed us to also assign the same modifier group to every draught beer that was not an 11oz pour. Same pitcher up charge across the board. Made things easy.

Some Aloha databases I have seen have had one item per size. So you had 1 button for 16oz Bud Light, 1 button for a 20oz Bud Light, and 1 button for a 64oz Bud Light. Depending on database setup and how the restaurant wants to operate, this is always an option.

Price levels are at the users discretion. We used price levels for certain modifiers like liquor mixes or non alcohol drinks. This allowed us to change 1 price and affect all the items, as opposed to changing 20+ item prices.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top