Your Best-Selling Products Might Be Losing You Money [2026]

The Revenue Lie

Your sales dashboard looks healthy. Orders are flowing. Maybe you're even having a good quarter.

Then the accountant sends over the quarterly P&L, and the profit is... thin. Or flat. And you have no idea which part of your catalog is responsible.

Revenue is not profit. Everyone knows this in theory. But in practice, when you're managing dozens or hundreds of SKUs across multiple suppliers and price lists, it's extremely easy to focus on the top line and completely miss what's happening underneath.

Here's the question most product business owners genuinely cannot answer: which specific products are actually making you money?

Not your best sellers by volume. Not your "popular" lines. Which SKUs - after accounting for what you paid, what you paid to ship them, and what you actually sold them for - generate a healthy profit margin? And which ones are quietly working against you?

According to NYU Stern School of Business industry margin data, gross margins across wholesale and retail categories range from roughly 21% to 46% depending on the sector. (Source) That's a 25-point spread at the category level. Inside any individual product catalog, the range between your highest-margin and lowest-margin SKUs is often far wider. If you can't see that variation, you can't manage it.

Why Most Business Owners Can't Answer This

The problem isn't disorganization. It's tooling.

Most small product businesses run on some combination of sales software showing revenue, a spreadsheet tracking purchase costs, and an accounting tool showing overall P&L. None of these connect the dots at the product level, automatically, in real time.

To get actual per-SKU margin data manually, you'd need to export purchase orders, import selling prices, factor in freight and storage costs, calculate margin per SKU, and repeat that process for every product, every quarter. Nobody does it consistently. So decisions get made on revenue, volume, or instinct.

There's also the hidden trap of landed cost. The price you paid your supplier is not your real cost. Freight, customs duties, port handling, local delivery - for imported products, those extras can add 15-30% to your base cost. If your system only records the PO unit cost, your margin calculations are off before they even begin.

That's how you end up convinced a product is making 30% margin when the real number, after freight, is 14%.

This gap often goes unnoticed for months. In our post on supplier price drift and margin loss, we showed how similar erosion happens when supplier costs rise without your prices keeping up. The pattern is the same: the damage is real, it just doesn't appear until you go looking.

From the Founder

I ran my product company for 13 years. The honest truth is that for most of those years, I knew which products sold well. I did not know, with any precision, which products were actually profitable.

The moments I found out were almost always unpleasant - a freight cost jump, a supplier price increase, a deeper accounting review than usual. By then, I'd usually been running the product at a bad margin for six months or more.

As we scaled - more SKUs, more suppliers, multiple warehouses, more currency exposure - the complexity made the problem worse. The gap between what I assumed the margin was and what it actually was got wider, not narrower.

I built VNDLY specifically so margin data would be available every day, not just when something forces you to dig for it. The calculation I used to do manually every quarter is now three clicks away.

How VNDLY Shows You Which Products Make Money

VNDLY's Costing Report (navigate to Reports > Costing) has three tabs that work together to answer the margin question properly.

Margin Report

This tab pulls your actual purchase costs from your purchase order history and cross-references them against your selling price lists. For every SKU, you see:

• Average cost (from your PO records)
• Selling price per price list
• Margin in cash terms
• Margin as a percentage

Sort by margin ascending and your worst performers surface immediately. That's usually where the work is.

If you run multiple price lists - retail, wholesale, trade accounts, VIP - the report shows margin for each one separately. A product might have a healthy margin at retail and a razor-thin one at the wholesale rate you're offering a large account. Without this visibility, it's easy to grow your wholesale business while inadvertently shrinking your profits.

That pattern connects directly to a problem we've covered before: how overstocking slow movers while understocking your best sellers distorts your whole product mix. Bad margin visibility tends to make that worse - you invest in the wrong lines.

Supplier Comparison

This tab shows, for each SKU, what every supplier charges you - side by side. Unit cost, currency, minimum order quantity, lead time - all on one screen.

If you've been defaulting to one supplier because they're familiar, and a second supplier offers the same product at 16% less, you'll see it here. That kind of saving is often sitting in plain sight. It just doesn't surface unless you look.

Profitability Report

This is the closest thing VNDLY has to a real P&L by product. Set a date range, and the report calculates for each SKU:

• Total revenue generated
• Total cost of goods sold
• Total profit
• Quantity sold
• Profit margin as a percentage

Sort by profit margin ascending and you see your underperformers immediately. Sort by total profit descending and you see your most valuable SKUs - the ones worth protecting, promoting, and restocking aggressively.

The Landed Cost Report

Before any margin number is useful, you need accurate costs. For businesses that import goods, that means landed cost - the purchase price plus freight, duties, and handling that actually got the product to your door.

VNDLY's Landed Cost Report (Reports > Landed Cost) breaks this down per SKU from your actual shipment records:

• Unit cost (from the purchase order)
• Freight allocated per unit
• Total landed cost
• Freight as a percentage of unit cost
• Quantity received
• Total landed value for the selected date range

If freight is adding 24% to your unit cost, you need to know that before you set a selling price. If it's only 5%, you have more room. This report shows you exactly where each product stands - not as an estimate, but calculated from real PO and freight data.

---

---

What Changes When You Can See This Data

Margin visibility sounds like a reporting upgrade. It's actually a decision-making upgrade.

Pricing decisions get grounded. Instead of "this feels like a 30% margin product," you know it's 23% - and you know that's below your threshold. You raise the price, renegotiate with the supplier, or cut the line. None of those options are available if you don't have the number.

Promotions stop being dangerous. Before you run a 20% discount on a slow mover, you check the margin. If the margin is 17%, a 20% discount means you lose money on every unit. That's not a promotion, it's a give-away. VNDLY shows you this before you set the discount, not after you've already run it.

Supplier negotiations get sharper. When you know that landed cost is eating 26% of a product's margin, you walk into the supplier conversation with a specific number to work from - not a feeling. That's a very different conversation. We've seen how excess dead stock compounds this problem - the cash tied up in low-margin slow movers is cash you can't use to invest in better-performing lines.

Catalog decisions get easier. Which products to push for a seasonal campaign? Which to discontinue? Which to restock aggressively into Q3? The Profitability Report doesn't answer all of those questions, but it answers the financial one. And that filters the list fast.

For businesses that run multi-tier pricing - selling wholesale to distributors while also running retail - this visibility is even more critical. The margin math changes significantly by channel. The wholesale inventory management page covers the broader context of running a B2B product operation where price list discipline directly affects profitability.

The Real Goal: Margin and Velocity Together

Margin visibility doesn't exist in a vacuum. A low-margin product that sells fast is still a drag - it consumes cash, warehouse space, and restocking attention that could serve a higher-margin line. A high-margin product that sits still is also a problem.

The real target is understanding margin and velocity together: which products make the most money per unit AND sell at a pace that turns stock quickly? That's where your buying budget should go.

VNDLY's reports connect these dots. You can identify your best-margin SKUs in the Costing Report, check their stock movement, and build a clearer picture of where to focus your purchasing.

If you're also managing the timing side - making sure you reorder before you run out rather than after - our guide on preventing stockouts with demand planning software shows how those two pieces fit together.

And for the broader question of whether to trust your instincts or your data when it comes to product decisions, the story in inventory tracking over gut feel covers that honestly.

---

Frequently Asked Questions

How does VNDLY calculate product margin?

VNDLY calculates margin by comparing the cost recorded on your purchase orders against the selling prices in your price lists. The Costing Report (Reports > Costing > Margin tab) does this automatically for every active SKU. For businesses that import products, the Landed Cost Report adds freight costs per unit, giving you true landed margin rather than just PO-price margin.

What is the difference between the Margin Report and the Profitability Report?

The Margin Report is structural - it shows your cost-to-price relationship right now, across all your price lists. It doesn't require any sales history; you can see it from day one. The Profitability Report is historical - it calculates actual revenue, cost, and profit for each SKU over a date range you choose. Both matter: the Margin Report tells you how you're set up; the Profitability Report tells you how that played out in practice.

Can I see margin broken down by supplier as well as by SKU?

Yes. The Supplier Comparison tab in the Costing Report shows cost per SKU broken down by each supplier you've ordered from. You can see whether Supplier A gives you better unit economics than Supplier B on the same product. The Landed Cost Report can also be filtered by supplier, so you can compare the full landed picture across your supply base.

Will my margin data update automatically when supplier costs change?

Yes. When you receive a purchase order at a new price, VNDLY records the updated cost and uses it in subsequent margin calculations. The Profitability Report pulls from actual purchase order records, so it reflects what you really paid - not a static number entered manually. There's no reconciliation step needed; the data stays current as you work.

What if I sell the same product at different prices to different customers?

VNDLY supports multiple price lists, so you can maintain separate pricing for retail, wholesale, trade accounts, and any custom tier. The Margin Report shows margin for each price list separately. A product that looks healthy at your retail price might be thin at the distributor rate you've been offering a key account. That visibility often drives businesses to restructure their wholesale minimums or add MOQ requirements to protect margin.

---