Sales by Category breaks a date range’s sales down by item type and category so you can see your merchandising mix — which kinds of product are actually moving.
Summary view
One row per Stock Type + Category combination:
- Stock Type — Jewelry, Watch, Diamond, Colored Stone, Pearl.
- Category — the item’s category within that type.
- Line Items, Quantity — how many lines and units sold.
- Gross Sales / Voided Sales / Net Sales — Net = Gross − Voided.
- Average Line — Net ÷ line count.
Detail view
One row per sold line item (Inv #, Date, Stock Type, Category, Stock #, Description, Qty, Unit Price, Net, Status) — the individual sales behind each summary bucket.
Filters
- From / To — by invoice date.
- Store — limit to one store.
- Stock Type — narrow to one family (e.g. just Diamonds).
- View — Summary or Detail.
How it differs from related reports
- Top Sellers ranks individual styles by units/revenue — the buy-again list. Sales by Category steps back to the category level for mix analysis.
- Sales by Customer / Sales by Salesperson slice the same sales by those dimensions instead.
Tips
- Compare two equal periods (this quarter vs last) to spot a category trending up or down before it shows in the bank.
- Use the mix to guide open-to-buy: categories with high Net and high Average Line are where reinvestment pays off.