Who Real-Time Inventory Data Is Actually For

About a third of the distributors who book a call with me shouldn’t build anything yet. I tell them that on the call. It costs me deals. It also saves both of us a six-figure project that was never going to land.

So before you read another word about real-time dashboards and exception alerts, here’s the honest version: this works for a specific kind of distributor. If you’re that kind, the upside is large and fast. If you’re not, you’d be buying a Ferrari to drive to the mailbox.

Here’s how I tell the two apart.

The Shape of the Business This Fits

The profile is narrow on purpose.

Two or more warehouses. A real ERP already in place, SAP or NetSuite or Dynamics or Sage or whatever the company bought five years ago. Somewhere between a thousand and a hundred thousand active SKUs. And a purchasing or operations team that, despite all of that, runs the actual day out of Excel.

That last part is the whole thing. The ERP holds the data. The team doesn’t trust it, can’t reach it fast enough, or both. So they export it, paste it into a spreadsheet, and the spreadsheet quietly becomes the real system of record. Three people keep three spreadsheets, and none of them agree.

If that sounds like your operation, keep reading. If it doesn’t, the rest of this might not be for you, and I’d rather you know now.

Five Signals You’re the One This Is Built For

You don’t need all five. Three is a strong sign.

One. You bought an ERP, and your buyers still live in Excel. You spent real money on SAP or NetSuite. The data is in there. And every Monday someone exports it into a workbook because that’s the only way the team knows how to act on it. The ERP became a database nobody opens.

Two. “It’s in the other branch” is a sentence people say out loud. To customers. With a straight face. You have inventory, you just can’t see it across locations in a way anyone trusts, so a stockout at one warehouse becomes a lost sale even when the unit was sitting two hundred miles away.

Three. Stockouts get discovered by a customer call, not by a buyer. The dashboard was open. The morning meeting happened. And the first anyone heard about the stockout was an angry email from a key account. That’s not a people problem. The buyer was watching 800 lines and the one that mattered didn’t stand out.

Four. Nobody trusts a number until finance closes the month. You run the business on a four-day delay. By the time the real picture shows up in a month-end report, the decisions that depended on it were made two weeks ago on a guess. I wrote about that gap in more detail in this piece on why month-end is the wrong time to learn what happened.

Five. Two or three people carry the operation in their heads. When the senior buyer takes a vacation, the place gets nervous. The knowledge that keeps fill rates up lives in one person’s instinct and one person’s spreadsheet, and both walk out the door at 5 PM.

If you’re nodding at most of these, the gap between “we monitor inventory” and “we manage exceptions” is probably where your margin is leaking.

Who It’s Not For

This is the part most vendors skip. I won’t.

Single-warehouse distributors. If everything is under one roof and a sharp ops manager can walk the floor, you don’t have the cross-branch visibility problem that drives most of the value here. Fix the small stuff in your ERP first.

A few hundred SKUs. If a good buyer can hold the whole catalog in their head, the exception math isn’t worth automating. Come back when the SKU count outgrows the human.

No ERP, or mid-migration. If you haven’t bought an ERP yet, or you’re in the middle of ripping one out for another, build the data layer after, not during. We sit on top of a stable system. A moving foundation isn’t one.

Anyone who wants to replace their ERP. We don’t do that. If your plan is to tear out SAP, this is the wrong conversation. We make the system you already own usable.

Anyone who wants an AI button on dirty data. This is the one I push back on hardest. You can’t bolt forecasting or recommendations onto numbers nobody trusts and expect magic. The foundation comes first. Skip it and you’ve automated your bad data, which is worse than doing nothing.

Why the Line Matters

There’s a temptation to sell to everyone. The reason I don’t is that the upside only shows up when the fit is real.

Gartner’s February 2025 survey of 579 supply chain leaders found that only 29% of supply chain organizations have built the capabilities they need to deliver on future performance, including the real-time visibility and integrated systems that catch problems before they break a workflow. Most distributors are in the other 71%. That’s the gap.

And the payoff for closing it is specific to distribution. Deloitte’s 2025 analysis of generative AI in wholesale distribution estimates that applying it across sales and customer service is worth 75 to 100 basis points of EBIT for the average distributor. That’s a real number. But it compounds on a clean, trusted data layer. It does not compound on a stack of spreadsheets that disagree.

So the question isn’t whether the technology works. It’s whether your operation is built to absorb it. A distributor with two warehouses, a real ERP, and a team stuck in Excel will feel the difference in a few weeks. A distributor missing those pieces will spend the money and wonder why nothing changed.

The Cheapest Way to Find Out

I’d rather you self-select honestly than buy something that doesn’t fit. So here’s a fast gut check. Ask your team three questions this week.

How often does a stockout get discovered by a customer instead of by a buyer? How long is the morning inventory review, and how many SKUs does the buyer scan to find the few that need action? When the senior buyer takes a week off, does the operation keep flagging exceptions, or does it go quiet?

If those answers make you uncomfortable, you’re probably the distributor this was built for. The next step is a paid audit. We map every flow into and out of your ERP, run the exception math against your last six months of transactions, and show you the actual SKUs that stocked out without warning and what catching them earlier would have been worth. You get a concrete report either way, whether you hire us to build or not.

If the answers were fine, you saved yourself a sales call, and I mean that.

Book a discovery call and we’ll figure out which one you are in 30 minutes.

---

Vinh Truong is the Co-Founder & AI Architect at zenprocess.ai, where he builds real-time operational dashboards and data pipelines for multi-warehouse distributors running SAP and similar ERPs. With 20+ years of enterprise IT and CTO leadership, he brings Fortune 500 data architecture to mid-market operations.