Top Sellers answers the question you take into a vendor appointment: of everything I bought from this vendor, what moved, what didn’t, and how long did it take?
It is built from your inventory, not from your sales. That matters: a style that has never sold still appears, because those are the ones you most need to see before you reorder.
How it is laid out
Three levels, each collapsible:
- Vendor — with the total styles, pieces purchased, pieces still available, pieces sold and the sell total.
- Style number — the numbers you scan: Qty Purch · Available · Qty Sold · Days in Stock. Click it to open.
- The pieces — one row per piece, and a piece that sold more than once appears once per sale.
The report opens as a list of vendor names, everything closed. Click a vendor to pull in its styles — they load the moment you open it, which is why a shop with a hundred-odd vendors still opens instantly. Click a style to see the individual pieces.
If your filters narrow the report to a single vendor, that vendor opens by itself.
Collapse All / Expand All are above the table. Expand All opens every vendor at once — on a large inventory that is a few thousand rows, so it takes a moment; the pieces under each style stay closed.
Days in Stock
The rightmost column, and the reason the report is sorted the way it is:
- Sold: days from the purchase date to the day it sold.
- Still on hand: days from the purchase date to today — it keeps counting.
- Returned to the vendor: days up to the return, with a badge on the description saying when it went back.
Styles are listed slowest first, so the pieces that have been sitting longest are at the top of every vendor.
Filters
- From / To — both start blank, which means every sale ever. They narrow the sale, never the purchase, so an unsold piece is never filtered away by a date.
- Vendors — tick one or more. Most people look at one or two at a time. The list holds every vendor you have stock from; type in the box to search it.
- Groups — the item’s Group (Bracelet, Earrings, Necklace…).
- Search — style number, stock number, or words from the description.
- Type — Jewelry or Watches.
- Sold styles only — hides everything that has never sold, if you only want the ranking.
- Store.
The columns
Photo · Stock ID · Purchase Date · Qty Purch · Total Price · Group · Description · Available · Order No · Order Date · Qty Sold · Total Cost · Sell Total · GP Dollars · GP Pct · Days in Stock.
GP Dollars is the sell total less the cost, and on a partnership piece it is less the partner’s share of the profit too — so it is what the shop actually kept. GP Pct is capped at ±100%.
Total Cost is the live cost — the purchase price plus any additional costs added since (re-cert, repolish, sizing) — so it reflects what the piece really cost you by the time it sold.
Tips
- The fastest read of a vendor: pick them, leave the dates blank, and look down the Days in Stock column. Anything near the top with 0 sold is money sitting on the shelf.
- Excel / CSV come out flat — one row per piece-sale with the vendor and style repeated — so a pivot table can rebuild any grouping you like.
- Click an Order No to peek at that invoice without leaving the report.
- Consigned goods (on memo from a vendor) are included: they came from that vendor and are part of the conversation you have with them.
- A piece only groups under a style when it carries a style number — see Adding Inventory for where that is set.
How it differs from related reports
- Sales by Category is the category-level mix; this is the individual style, per vendor.
- Top Customers (RFM) ranks people, not product.