Gross and net sales for modifiers in sale report show $0

[aleim343]

Hi, I sell a few products which comes from different suppliers so I use modifiers to track which ones sold the most.

When looking at the sales report, I can only see the quantity sold. Gross and net sales show $0.

Is there a way to rectify this?

[ryanwanner · Accepted solution]

Your modifiers must have a price associated with them in order to show sales on the modifier reports.

If you have Item at $3.00 with a Modifier 1 with no price then the modifier report will show no sales.

If you change your Item to be $0.00 with Modifier 1 being $3.00 then the modifier report will show $3.00 with one sale.

Example:

I run a restaurant. One of my items is Biscuits and Gravy. On the menu, it is priced at $9.00 with two eggs. Since I have people not wanting eggs (and since Square doesn't allow for negative priced modifiers), I have the B&G ring up at $7.75. All my egg modifiers have the pricing at $1.25 per modifier item. On my modifier report, I can see the total $ sales of eggs on the B&G item. Other items don't have pricing on the modifiers and all those modifiers show with $0 in sales.

[aleim343]

Hi Ryan,

Thanks for the prompt reply and very good explanation. I now know how the modifiers are calculated in the reports.

It's just that I use my modifiers differently (tracking source of product rather than the addition of items).

Appreciate it

[brendanc]

I share the same question: is there a way to group ITEM gross sales amount based on MODIFIER grouping, in a world where all modifiers have zero-dollar values?  For example, if we have a modifier for "Gift Wrapping" with Zero dollar cost, how do I make a report that shows me the ITEM gross dollar amount transacted, grouped by those With Gift Wrapping selected and those with "Without Gift Wrapping" selected as a modifier?

[brendanc]

Searching around, I see this post:

https://www.sellercommunity.com/t5/Questions-How-To/Can-I-generate-a-report-that-includes-item-modif...

It suggests: "

One way would be Dashboard>Sales>Transactions>Export Drop down menu>Select:Item Detail CSV.

"

I did that, and was able to bring that CSV into google sheets and then run a pivot table that groups by modifier.  We only use one modifier concept, so the modifier column is clean enough for us, but I imagine that if there are multiple modifiers it may be a pain as you'd have to parse that somehow in the spreadsheet program you use.