How to create a user report for order tag sold?

Hi there,

After a bit of trial and error, I’ve been able to create a report for each user selling a particular group item (Desserts). This report helps us give staff extra incentive:

[Dessert Sales:1, 1, 1]
{REPORT ORDER DETAILS:O.User,O.Quantity.sum,O.Total.Sum:(MG=Dessert)}

I’m now in the process of creating a report that shows how much a staff member is able to upsell a particular order tag (“Add Buffalo”).

I’ve tried to use the custom reporting tags but I’m unable to retrieve a report for a specific order tag “Add Buffalo”

Could someone please point me in the right direction, perhaps it’s something to do with the syntax?

So far, I’ve tried the following but had no luck (comes with a blank screen):

[Buffalo Sales:1, 1, 1]
{REPORT ORDER DETAILS:O.User,O.Quantity.sum,O.Total.Sum:(OT=Add Buffalo)}

[Buffalo Sales:1, 1, 1]
{REPORT ORDER DETAILS:O.User,O.Quantity.sum,O.Total.Sum:(OT.Add Buffalo)}

Would really appreciate any help pointing me in the right direction!

Have you tried the REPORT ORDER TAG DETAILS tag?

REPORT ORDER TAG DETAILS

Reports details for order tags.

Field Description
T.Name Order Tag Name
T.Value Order Tag Value
T.Qty Order tag quantity
T.Price Order tag Price
T.Description Order tag description
O. Order reference
T. Ticket reference

Try something like

{REPORT ORDER TAG DETAILS:O.User,T.Name,T.Value,T.Qty.sum:T.Name="Add Buffalo"}

For reference:

9.1.4. Custom Reporting Tags for V5 – SambaPOS Knowledgebase

@{REPORT ORDER TAG DETAILS:T.Name:(ODI=True):{0}:,}
[$1 Tag Report:1,1,1,1]
{REPORT ORDER TAG DETAILS:T.Value,T.Qty,T.Price:OrderTag.TagName="$1"} 

No luck with this unfortunately, shows blank screen when click on Preview

I get the following report which seems close. However I need to find the sum of the order tag “Add Buffalo” for each user.

Seems that the order tag name parameter is for the name assigned to a group of order tags (Pizza in this case)?

Then at end try OrderTag.TagValue=“Add Buffalo”

It seems Emre added T.Name= but never added T.Value= so OrderTag.TagValue= is the long form

To help you out this report should get close to what you want.

@{REPORT ORDER TAG DETAILS:T.Value:(ODI=True):{0}:,}
[$1 Tag Report:1, 1, 1]
{REPORT ORDER TAG DETAILS:O.User.asc,T.Qty.sum,T.Price:OrderTag.TagValue="$1"} 

Thank you so much, I was able to modify it to the following to get exactly the information I was after.

Can’t thank you enough for helping point me in the right direction with the custom reporting tag values:

[Buffalo Sales:1, 1, 1]
{REPORT ORDER TAG DETAILS:O.User,T.Qty.sum,([T.Price]*[T.Qty]).sum:OrderTag.TagValue="Add Buffalo"}
1 Like

Try this too.

@{REPORT ORDER DETAILS:O.User:(ODI=True):{0}:,}
[$1 Tag Report:1, 1, 1]
{REPORT ORDER TAG DETAILS:T.Value,T.Qty.sum,T.Price:(OU=$1)} 

Another variation.

@{REPORT ORDER DETAILS:O.User:(ODI=True):{0}:,}
[$1 Tag Report:1, 1, 1]
{REPORT ORDER TAG DETAILS:T.Value,T.Qty.sum,T.Price.sum:OrderTag.TagValue="Add Buffalo" and (OU=$1)} 

Looks like you’re having quite the fun with these @Jesse :laughing:

I dont get much time to do this like I used too. I miss it. Now I’m focused mostly on the business side of SambaPOS.

Thank you for taking the time to help me out :slight_smile:

Hope the business side of things are going well!

Waiting on eftpos integrations in Aus, I think that will be a game changer for us here!

Here is another fancy way. I created a pivot table. Users on the left, then its orders, then order tags under those.

1 Like