Custom Reports with product tags

V5 Question
1

Hi , I have added custom product tags for identifying kitchens, and added reports also.
Now I want to add reports of items that categorized based on product tags.
Like items sales reports on each kitchen.
Help me please :cry::frowning:

2

Hello I created a tutorial to show how custom reports grouping / categorizing feature works. I hope it helps.

https://sambapos.com/wiki/doku.php/custom_report_examples

5 Likes
3

Hi, @emre
I am using custom product tags, for grouping items for kitchen
I need to filter or sort the item sales report based on custom tags .
I tried the tutorials but ,I couldn’t find.

4

Custom Report Tags in detail[quote=“emre, post:2, topic:2887”]
Supported by REPORT ORDER tags

OT.<tag name> Order Tagged With
OS.<state name> Order is in State
OU Order User Name Equals
MT.<tag name> Order Menu Item Custom tag Equals
MG Order Menu Item Group Equals
[/quote]

5 
[Sale Groups:2, 1, 1]
@{REPORT ORDER DETAILS:MT.KITCHEN GROUP,O.Quantity.Sum::{0}:,}
>>$1
{REPORT ORDER DETAILS:M.GroupCode,O.Quantity.Sum,O.ExactTotal.Sum:(MT.Group=$1)}
>Total:||{REPORT ORDER DETAILS:O.ExactTotal.Sum:(MT.Group=$1)}

I tried this but not working…
Kitchen group is the custom product tags

6

The report doesn’t see right to me, not sure why your defining a list then trying the display the group name and constrain with the group name aswell plus the constraint is Group not KITCHEN GROUP…
Maybe type out an example of how you expect/want the report to come out?

7

So which is it? KITCHEN GROUP or Kitchen group? Case sensitivity is critical here it will not work otherwise. If your wanting to filter by only that name then just directly put it in there like this:

[Sale Groups:2, 1, 1]
>>KITCHEN GROUP
{REPORT ORDER DETAILS:M.GroupCode,O.Quantity.Sum,O.ExactTotal.Sum:(MT.Group=KITCHEN GROUP)}
>Total:||{REPORT ORDER DETAILS:O.ExactTotal.Sum:(MT.Group=KITCHEN GROUP)}
3 Likes
8

I will try, and update u, thansk

9

when I tried this nothing coming @Jesse

10

I tried this coming like this.
I want to group it.

[Orders:1,1,2,1,1]

Kitchen|Item|Quantity|Total
{REPORT ORDER DETAILS:MT.KITCHEN GROUP.desc,O.MenuItemName,O.Quantity,O.ExactTotal.Sum}

11

Do you not see a difference here?
Your MT is called KITCHEN GROUP so the first example should be;

{REPORT ORDER DETAILS:M.GroupCode,O.Quantity.Sum,O.ExactTotal.Sum:(MT.KITCHEN GROUP=SHWARMA)}

Try this;

@{REPORT ORDER DETAILS:MT.KITCHEN GROUP.desc}
[Kitchen Group - $1:2, 1, 1]
{REPORT ORDER DETAILS:O.MenuItemName.desc,O.Quantity.Sum,O.ExactTotal.Sum:(MT.KITCHEN GROUP=$1)}
>$1 Total:||{REPORT ORDER DETAILS:O.ExactTotal.Sum:(MT.KITCHEN GROUP=$1)}
1 Like
12 
[Orders:1,1,2,1,1]
>>SHAWARMA
>>Item|Quantity|Total
{REPORT ORDER DETAILS:O.MenuItemName.desc,O.Quantity,O.ExactTotal.Sum:(MT.KITCHEN GROUP=SHAWARMA)}
13 
[Orders:1,1,2,1,1]
>>SHAWARMA
>>Item|Quantity|Total
{REPORT ORDER DETAILS:O.MenuItemName.desc,O.Quantity,O.ExactTotal.Sum:(MT.KITCHEN GROUP=SHAWARMA)}

I tried this now its coming but the problem is same item shows multiple times.

its not grouping,
See Meat Shawarma came around 5 times

14

This one came

15

Search for grouped item sales report.
I did a report template for what it sounds like your after.
Orders will repeat this way as your listing them, to consolidate you need to use an @ for order name list as well.

16

It won’t group unless you SUM all your fields:

O.MenuItemName.desc,O.Quantity.sum,O.ExactTotal.Sum
                               ^^^              ^^^
1 Like
17

I got it, its working now… thank u guyx

18

Hi QMcKay,

Just like we use a .Sum for number fields, how do I show the first string in a group of string

eg

O.Quantity.Sum, OSV.GStatus.First

Can I use the keyword First? Are there any other grouping keywords for strings?

Thanks,

Somil

19

https://sambapos.com/wiki/doku.php?id=custom_reporting_tags