I’m using custom tags for my MenuItems for reporting purpose, but what I didn’t think about and just paid attention is that if we delete the MenuItem we lose is custom tag.
I would like to save those tags in Order records and I’m wondering what is the [Tag] column in [Orders] database table?
I use these for all sorts of order added rules for states however beleive you can report orders based on them using expression;
(MT.TagCaption=TagValue)
Hi I’m already using Product Tag Captions.
Everything is working well, the only problem in my case is, I use those custom tags to make FNB reporting, but if I delete my Product (MenuItem) later because I don’t sell it anymore, when you generate your report, you have all informations about the order (price, quantity, etc…) but not anymore about the item’s custom tag.
So my Idea is to save my FNB custom tag in the order line information.
So my first question was: there is a sql column named [Tag] in the table [Orders] that is always null, what is the real purpose of this column and can it be edited from one Action?
Convert it to order state on order added and report on order state rather than item tag
Thats what I do to enable me to itemize my charges on my PMS integration.
Order states are on the order not the menu item so will not be effected if you delete a product.
BE SURE TO MAKE OWN STATE ACTION NOT USE STATUS AS YOU WILL MESS UP OTHER RULES IF INTERFERE WITH STATUS STATE FLOW
States are extremely powerful once you get to grips with them.