Inventory CONSUMPTION: Inventory Items, Products, Recipes, and Order Tags

To Auto-Tag Menu Items …

Manage > Products > Menu List > [Menu] > [Category] > Edit Product Properties

Use the Order Tag section as a comma-separated list of the Tags that are generally on a Pizza, such as:

  • Pizza Base
  • Pizza Sauce
  • Cheese

:warning: The Tags are case-sensitive, and there should be no spaces before or after a comma!

Then if there are other Tags for a certain type of Pizza, for example, Hawaiian, continue with the applicable Tags, like Ham and Pineapple. So your Order Tag list might look like this for the Hawaiian (again, note no spaces around the commas):

Pizza Base,Pizza Sauce,Cheese,Ham,Pineapple

4 Likes

FYI this is order tag mapping tricks reference.

!Meat     > Negating Match   > Not tagged as `Meat`
*Meat     > Ending Match     > Ends with `Meat`
* Meat    >   "    "         > Ends with ` Meat` (word)
?\bMeat^  > Regex Match      > Ends with or equals Meat
3 Likes

:slight_smile: @Flight52 last two answers to your question are different approaches to your issue. Q’s suggestion works great as it lists all optional (removable) indigents on kitchen print even they are default so kitchen staff does not need to remember if selected product does have mushroom by default or not. So I strongly suggest you to implement @QMcKay’s suggestion.

2 Likes

Thank you for the help, I’ve been without internet for 2 days, so a late reply.

I like this way.

If I understand it correctly ! -Mushroom will add mushroom to the inventory. So if a pizza has mushroom in the recipe, the recipe will consume 1 mushroom and the order tag will add 1, ending up with 0 consumption. correct?

So I create 1 Inventory Item called Mushroom, 1 Product that consumes 1 Mushroom, 1 Recipe for the Mushroom Product and 2 Order Tags. 1 called +Mushroom to add extra Mushroom to a pizza and 1 called ! -Mushroom to not use Mushroom on a pizza, both linked to the Product, Recipe, Inventory Item called Mushroom.

I then run a sale through, selling 1 P2 pizza (that normally consumes: 1 Pizza Base, 100 Marinara Sauce, 140 Mozzarella Cheese, 10 French Salami, 1 Mushroom and 1 Green Pepper), using the Order Tag ! -Mushroom.

And it consumes 2 Mushroom instead of 0

Where am I going wrong?

@QMcKay

Thank you for the information on how to Edit product properties, it is something I’ll definitely keep in mind, and I haven’t seen it anywhere else in the forums. In fact it could easily be part of the original tutorial.

For me unfortunately it won’t work.

My serving staff, speak English, my customers speak English, my kitchen staff neither speaks, reads or writes no English, only Thai. So in the kitchen we have a recipe for each pizza in Thai (and English for me) and codes for the pizza (P1, P2 etc). At the moment when we receive a modified order the serving staff will write on the orderpad:
P2
-เห็ด (Mushroom)
so that the kitchen staff can read it.

If they received an order for a P2 with only 4 ingredients listed instead of 5, they would have to exit the kitchen and ask which one it was. And even worse, if they received an order for a P2 with 5 ingredients listed (1 added, 1 removed) they would just assume it was a regular pizza and make that.

And unfortunately my printer cannot print Thai, only Chinese and English, that’s what I get for buying a cheep printer :frowning:

So I have to try the ! way.

You entirely misunderstood it… :slight_smile: I’m preparing some screenshots for you.

##No cheese

I created a pizza product.

This is the only product I need. For indigents like mushroom, cheese we don’t need products or recipes.

I created 3 order tags for Pizza. I only set prices and mapping. We’ll solve product mapping in recipe. Mapping an order tag to a product here useful for menu setups like mapping tags to menu products like Coke, Fanta, etc… So product Mapping should remain blank.

I created inventory items for 3 Pizza Indigents.

I created a default recipe for pizza.

When I sell 1 pizza it works as expected.

Now this is the important part. When I click on No Cheese order tag I want it not to decrease cheese. I don’t want it to add something back to inventory. I just won’t decrease cheese. Let’s update the recipe.

It means Unless (!) I tag order as No Cheese, decrease 30 gr cheese.

So .

When I sell one more pizza without any order tag selection it decreased 30gr cheese.

When I add 3rd pizza with no cheese…

Mushroom consumption increased to 90 but cheese remained 60.

More Cheese

:warning: I’m clearing past transactions to demonstrate it better.

So when we click on More Cheese we want to consume 20 gr More Cheese so it should consume 50 gr.

I added second recipe line for More Cheese Tag. That line will work when order tagged as More Cheese.

With that recipe selling Pizza with no modifications still consumes 30 gr cheese.

… but when I sell second pizza with More Cheese Option selected…

Cheese consumption becomes 80 instead of 60.

Finally I’m setting up No Mushroom tag for pizza so my recipe is done.

As Pizza Dough always decreases no order tag mapped to it.

PS: If you name the tag as -Mushroom instead of No Mushroom, please map it as !-Mushroom.

4 Likes

I’m happy about that, I thought I was going crazy :confounded:

@emre

So I should create an original pizza recipe, that contains every Pizza Inventory Item. Then clone it for all the different pizza, and order tag ! for all standard ingredients and “More” for the rest?

This works great !!!

I even got it to work with Order Tag Prefix, Except, when I add a Prefix, it ignores cost. Is there a way around this?

Think I sorted it. I add a new Order Tag: + Green Pepper with a price of 10. It doesn’t show up on the order screen (I guess because it has the Prefix written in the name?), But it modifies consumption and price!!!

Which gives me an idea.

Would it be possible to create a list of Order Tags, 2 for each Inventory Item, a NO and an ADD, add the Prefixes NO and ADD. And then the Order Tag would only appear on the order screen if the Prefix was selected?

Lke this:

Unfortunately at the moment that just hides both Order Tags

But if selecting the Prefix on the order screen made them appear, that would be soooooooooooooooooo cool!!!

Please :heart_eyes:

1 Like

Try setting up filter for order tags as * so they’ll appear only when a prefix button is selected.

Additionally you can set filter to ! to make an order tag appear when no prefix is selected or just write a prefix name to make it appear when that prefix is selected.

1 Like

Thanks for the great help so far, but with this one you lost me.

I’ve used the search function to find topics about how to use filters, but they all talk about it, asuming the reader knows how to use them already.

Can you point me in the right direction?

2 Likes

@emre

I tried doing as you said.

I made a list of Order Tags with + or - in front of each. I’ve add * to the filter and added 2 Prefix + and - .

When I come to the order screen, only the prefixes appear as they should, But selecting them doesnt make the Order Tags appear.

Am I missing a step?

@emre

I have tried to play around with it.

The only way I could get it to show the Order Tags, was to remove the space between the Prefix and the Order Tags name. (+ Cheese => +Cheese)

That makes the Order Tags appear only when the prefix is selected. As you said when * is selected as filter.

The problem now is, that when an Order Tag is selected, it adds the prefix before the Order Tags name which includes the Prefix already. (+ +Cheese instead of +Cheese) and it doesn’t use the price from the Order Tag either.

It also doesn’t modify consumption either.

Thank you for your help

Anders

No, don’t remove spaces. Configure them with space character. Try also adding non prefixed versions of buttons. So…

  • Mushroom will appear as button. Don’t forget to set filter for that button.
  • + Mushroom will be used to fetch + Mushroom price. You don’t need to define it if there is no special setting like price for that order tag.
  • - Mushroom will also be used if there is specific pricing.
3 Likes

Awesome!!!

Jobs a good one.

Thank you

Is it possible to report inventory by default transaction unit eg.case
My base unit is can but I would like to know how many cases should be in stock.

Yes, and it is mentioned above in this very Topic:

A quick search found this:

I followed the above tutorial and checked the box beside case but when i use the Inventory Report
[Inventory Report:1,1, 1]
{REPORT INVENTORY}

It shows stock by can not by case

Did you follow the tutorial or did you just follow the picture?[quote=“QMcKay, post:2, topic:8148”]
Your Consumption will be reported by Transaction Unit if you do not leave it blank. So if it is defined as Case with a Multiplier of 12, when you sell 1 Can, your consumption will report 1 of 12 = 0.833 of a Case Consumed, with Instock level reported as 0.916 of a Case left. This is not useful in scenarios such as this.

If you leave Transaction Unit blank, your Consumption will be reported by the Base Unit. Most of the time Base Unit Consumption makes more sense. So when you buy 1 Case (of 12), and sell 1 Can, you will see Consumption reported as 1 Can, and your InStock level will be reported as 11 Cans left.
[/quote]

That quote explains it pretty well.

The checkbox beside Additional Units makes it your default Transaction Unit for Purchasing. However, the Consumption will still be reported by the Base Unit unless you have the Transaction Unit defined.

Consumption is never reported by Additional Units, no matter if the box is checked or not. You must define the Transaction Unit.

To define the Transaction Unit as “Case” when you already have an Additional unit defined with the same name, you need to change the name of the Additional unit first (ie. rename it to “CaseA”), then save the Inventory Item, then re-open it, define the Transaction unit as “Case” with a non-zero multiplier, then save it again. Then you can go in one more time and delete the Additional Unit if you want.

2 Likes