Finding Your Best and Worst Sellers: Using Item Sales Reports to Buy Smarter

The best-selling products report in most POS and retail systems ranks items by revenue, units sold, or gross margin over a chosen date range, and the honest answer is: you need to look at all three, because each one answers a different buying question. A report sorted by revenue alone can bury a high-margin item that quietly pays your rent, and a report sorted by units alone can make a $2 impulse buy look more important than it is. The fix is a short monthly routine that pulls all three rankings from the same item sales data and turns them into actual purchase orders.

What Is an Item Sales Report, and What Does It Actually Show?

An item sales report is a breakdown of every SKU sold in a given period, showing units sold, revenue, cost, and gross margin per item, usually filterable by location, category, or vendor. It is different from a sales summary, which totals the whole store, and different from an inventory turnover report, which measures how fast stock moves relative to what you're holding. The item sales report is the raw material for both your buying decisions and your clearance decisions — it tells you what sold, not just how much you made.

Revenue, Units, or Margin: Which Ranking Should You Trust?

Sort the same 30 days of data three different ways and you'll usually get three different lists. That's not a bug — each ranking is answering a different question:

• By revenue — which items generate the most sales dollars. Useful for deciding what deserves prime shelf space and what to feature in email campaigns, but it rewards expensive items even if they barely turn.
• By units — which items customers buy most often. This is your traffic-driver list: the products that bring people in the door or get added to every basket. High unit count with low revenue often means an underpriced item, not a weak one.
• By gross margin dollars (units × (price − cost)) — which items actually pay the bills. An item that ranks 20th in revenue can rank 3rd in margin dollars if its cost is low, and this is usually the list owners haven't looked at in months.

The item that shows up in the top 10 on all three lists is the one you never want to be out of stock on. The item that ranks high on units but low on margin is the one worth a small price test.

What Is the Long Tail, and Why Does It Matter for Buying?

The long tail is the large group of SKUs that each sell in small quantities but together account for a meaningful share of revenue — as distinct from your top sellers, which are few in number but high in volume. In most stores, a version of the 80/20 rule holds: roughly 20% of active SKUs generate 70-80% of revenue, and the remaining SKUs make up the long tail. Some of that tail is healthy — specialty items, gift purchases, one-off sizes. Some of it is just dead stock waiting to be noticed.

• It has sold zero or one unit in the last 90 days but you still have 8+ on hand
• It's a duplicate of a better-selling variant (same item, worse color or size run)
• It only sells when discounted, meaning its 'sales' are really clearance events
• Nobody has reordered it in over a year, and no one would notice if it disappeared

Items matching two or more of those are candidates to drop from your next order, not just mark down. The item sales report is how you find them before they turn into a stockroom full of things that don't sell.

How Do You Build a Monthly Buying Review From Item Sales Data?

A monthly buying review turns the report into decisions instead of a spreadsheet you glance at once. Here's a version that works for a single store or across locations:

• Step 1 — Pull the trailing 30 and trailing 90 days. One month alone is noisy; 90 days smooths out a slow week or a one-time promotion.
• Step 2 — Rank by revenue, units, and margin dollars separately. Export or view all three, not just one.
• Step 3 — Flag your top 10 by margin dollars. These are your must-never-be-out-of-stock items. Check their reorder points and raise them if lead times have grown.
• Step 4 — Flag anything in the bottom 10% by units with high on-hand. Cross-check against current stock levels, not just sales — a slow seller with zero stock left isn't a problem yet.
• Step 5 — Check sell-through rate on anything you're about to reorder. A fast seller with low margin might still be worth stocking; a slow seller eating shelf space usually isn't.
• Step 6 — Write the actual purchase order changes. Increase quantities on the top-margin list, hold or cut quantities on the long-tail list, and note any items to discontinue after current stock sells.

How Often Should You Run a Best-Sellers Report?

Weekly for a quick gut-check — did anything unusual spike or stall — and monthly for the actual buying review described above. Seasonal or fast-fashion categories should run this closer to biweekly, since a top-10 list from six weeks ago can already be stale. Multi-location retailers should run it at the location level too: a top seller at one store can be a slow mover at another, and buying centrally off a single blended report hides that.

How Does Retailer OS Turn Item Sales Into a Buying Decision?

Retailer OS keeps the item sales report and the inventory it's measuring in the same system, so the numbers you're ranking by are the numbers you're about to reorder against. Reports and dashboards can be filtered by item, category, vendor, or location, saved as views you reuse every month, and sent as a scheduled email digest so the review shows up in your inbox instead of requiring you to log in and pull it manually.

• Every sale, transfer, and adjustment writes to a per-item, per-location inventory ledger, so revenue, units, and current on-hand always line up — no separate spreadsheet to reconcile.
• Cost is tracked at the item level from purchase orders and receiving, so margin dollars in the report reflect actual landed cost, not a guessed markup.
• Saved report views let you keep a standing 'top 10 by margin' and a standing 'long tail' view side by side, rather than rebuilding filters every month.
• With an AI plan (from $19.99/month), Retailer OS adds demand forecasting and reorder suggestions on top of the same sales history — you still decide what to buy.
• Multi-location stores can pull the same report per store or across the account, so a slow seller at one location doesn't get buried in a blended total.

What Should You Do With Your Worst Sellers?

Don't reorder them, and don't let them sit either. Once an item is confirmed long-tail dead weight — low units, low margin contribution, no recent reorders — move it into a clearance cycle rather than letting it occupy shelf space and tie up cash. That's a separate decision from the buying review, but the two are connected: tracking dead stock closes the loop so this month's clearance doesn't become next year's long tail.