The most expensive inventory problem I’ve seen didn’t show up on any report. I spent years working with a premium food manufacturer that built its business as a luxury gift brand. For decades, their products moved through their own retail stores, department stores, and ecommerce—channels they had mastered. Here’s the thing about that model: they never printed a “best before” date on anything. Instead, each product carried an internal lot code using a Julian date format that only employees knew how to read. Customers shopping at department stores or on the company website had no idea whether a product was six months old or a year old. And since mostly the same SKUs were sold everywhere, product age rarely became a significant concern in that model.
With Growth Comes Consequence
Then the business decided to grow by entering food, drug, and mass retail channels. Suddenly, we weren’t just selling into a gifting model anymore. We were selling to major food retailers with strict requirements to print a “best before” date, and ensure the product has a certain percentage of shelf life remaining when it arrives at their warehouse. One customer might require 80% of shelf life left. Another would accept 70%. SKU proliferation limited by channel, forecast volatility, seasonal bursts, and production constraints only made things more complex.
The Problem?
Our 20 plus year old ERP system had no way to track any of this. We could see inventory, but we could not make confident decisions with it. We could tell we had 300 cases in stock but not tell how long they had been on the shelf. Worse we didn’t have the ability to make accurate decisions on production runs to fulfill orders. We built workarounds to try to manage the business – spreadsheets and phantom warehouse locations to track product aging, even though it physically never moved. If you didn’t know the unwritten rules behind which warehouse code meant what, you were lost. That’s not control. That’s duct tape.
And this is where the real risk lives. When your planning team thinks they have inventory—yet can’t see that only a portion meets customer shelf-life requirements—you’re flying blind. Without that visibility, you’re always reactive. Product ages past the point where any customer will accept it, and now you’re scrambling—offloading to discount outlets at reduced margin (and risking your brand image), donating for a tax write-off, or worse, scrapping it entirely. Every one of those outcomes represents preventable margin erosion.
“Without that visibility, you’re always reactive.”
If you’re a food and beverage manufacturer running on a legacy system, ask yourself: does your balance sheet say you have inventory, but your customers say you don’t? Can your ERP automatically match inventory to customer specific requirements? Can your planners see, in real time, what’s truly available versus what’s aging out? If the answer is no, you’re not alone—but you are exposed. Modern ERP platforms are designed to handle this complexity. They track shelf life at the lot level, enforce customer rules, and give your teams the visibility to be proactive instead of reactive.
The question isn’t whether you can afford to modernize.
It’s whether you can afford not to.
