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. GP Pct is capped at ±100%.
Staff who can’t view cost don’t see Total Price, Total Cost, GP Dollars or GP Pct, on screen or in the Excel/CSV download.
A partnership piece shows a P beside its stock number, and by default its row shows the full sale. Tick Show partnership sales at our share to switch sell total, cost and GP on those rows to your share. See Partnerships.
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.