Shopify's reports can break sales down by product, quantity, and POS location, but there is no built-in filter that removes free or 100%-discounted line items on its own. The documented workaround is exporting the report to CSV and filtering the final price or net sales column to zero by hand.

Shopify's retail sales reports, filed under Analytics > Reports > Retail Sales, include a POS total sales by product view that groups sales by product and location together, which covers the "booth" side of the request since a pop-up or event register shows up as its own POS location. These reports only populate for stores that sell in person through Shopify POS. The Sales by discount default report is the closest built-in view for spotting fully-discounted orders, but it doesn't strip them out of a product/location report automatically. Shopify's filter system matches on exact values (for example, filtering a discount field to exactly $0), but there's no packaged "exclude 100% discount or free" toggle, so getting a clean report still means pulling the export and removing the zero-value rows manually.

This is where a reporting app that lets you filter directly on the sales value closes the gap. In Report Pundit, building this as a Sales-level report with Product Title, SKU, Variant, Net Quantity, Gross Sales, and Net Sales as columns, plus POS Location and Order Date/Number, and adding a filter for Net Sales is not $0 removes the free and fully-discounted line items inside the report itself, so the CSV cleanup step goes away and the report can still be scheduled to run automatically.