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!
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"}
@{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)}