Getting the total for 1 product category

I had a party of 20 in last night and at the end of the night one of the customers wanted to pay for all the drinks. I had to scrol through the whole ticket selecting the drinks and then split them off the bill. Is there a way of either selecting all the drinks category in one go or getting the total amount for the drinks on that ticket?

I would probably want it so that when i press a button it shows or enters a ticket tag for the total for the drinks on that ticket.

I do this on my printed receipts.
I have a product/item tag which is wet/dry which relates to my PMS integration, part of this involves turning the item tag into a order state on order adding.
I then use;

<J00>Drinks:|£{TICKET ORDER TOTAL EXP:(ODI=True) AND (OS.NewBook GLA=2101)}
<J00>Food:|£{TICKET ORDER TOTAL EXP:(ODI=True) AND (OS.NewBook GLA=3101)}

ODI=True excluded voided orders.
OS.NewBook GLA is my PMS revenue code for wet and dry etc.

How would i go about doing this?

You could probably use item tags directly but to use states like I have you would have;

Product Tags;



Printer template tags as above.

If i replaced the ticket tag with FoodDrink and the numbers 2101 with drink and 3101 with food and updated the print template :
Drinks:|£{TICKET ORDER TOTAL EXP:(ODI=True) AND (ProductTag:FoodDrink=drink)}
Food:|£{TICKET ORDER TOTAL EXP:(ODI=True) AND (ProductTag:Food/Drink=food)}

would that work?

What ticket tag??? …

Sorry, meant Product tag.

(OS.NewBook GLA=2101)}
what is the OS for?

Its part of the report expression. OS = Order State, hence the rule to turn product tag into state on order added to ticket.

You may be able to use product tag directly, my setup uses states so I showed you that, you can by all means try and use the product tag directly. You will need to see if there is a valid expression usable in TICKET ORDER TOTAL EXP for item/product tag.

1 Like

Ill try it the way you have done it and see how it goes. Thanks @JTRTech

so im using FoodDrink as the product tag

-- General layout
<bmp>C:\epos pics\logo.bmp
<C00>Main Road, Dinnington, 
<C00>Newcastle Upon Tyne, NE13 7JS
<C01>01661 59 8181
<C01>01661 59 8484
<L12>Table:{ENTITY NAME:Table}
<J00>Drinks:|£{TICKET ORDER TOTAL EXP:(ODI=True) AND (OS.FoodDrink=Drink)}
<J00>Food:|£{TICKET ORDER TOTAL EXP:(ODI=True) AND (OS.FoodDrink=Food)}
[<J10>Total Gift:|{ORDER STATE TOTAL:Gift}]
<J10>Total:|{TICKET TOTAL}
<C11>T H A N K   Y O U
<C00>Vat No: 214987385

<C00>Like us on Facebook &
<C00> Please visit us again soon

[ORDERS GROUP|PRODUCT TAG:Kitchen Group:Drink,Special,Appetiser,Starter,Main,Sides,Rice,Nan,Sundries,Beverage,Special]




-- Default format for orders

-- Format for gifted orders

-- Nothing will print for void lines

-- Format for order tags

-- Table entity format
<L00>Table: {ENTITY NAME}

-- Customer entity format
<J00>Customer: {ENTITY NAME} | {ENTITY DATA:Phone}

all im getting on the print is

    Main Road, Dinnington,
      Newcastle Upon Tyne, NE13 7JS
              01661 59 8181
              01661 59 8484


- 1 Bhuna Prawn on Puri               3.95
- 1 Chicken Chatt                     3.95
- 1 Chicken Tikka Main                8.95
- 1 Lamb Korai                        8.95
- 1 Nut Pilau                         2.95
- 1 Peshwari Nan                      2.75
Drinks:                                 £-
Food:                                   £-
Total:                               31.50
            T H A N K   Y O U
            Vat No: 214987385

          Like us on Facebook &
        Please visit us again soon

Am i doing something wrong?

Open the action in the rule so can see your settings.

You might not need to deal with states. Can you check if it works or not?


Thanks @emre, this works great.

What is MT for?

MT.<tag name> Order Menu Item Custom tag Equals

From Here: