I built a tool for our merchandising team that tracked warehouse inventory no longer part of the current product lineup — flagging discontinued items so they moved quickly to retail stores for sale instead of aging in storage.
Inventory That Outlived the Lineup
Every product lineup change leaves stranded inventory — items still in the warehouse but no longer part of what’s actively sold. Left alone, they age in storage racking up cost. The merchandising team needed a way to catch those items automatically and get them onto a sales floor before they became dead stock.
What I Delivered
Lineup tracking tool
Built a system that monitored warehouse inventory against the current product lineup in real time.
Discontinued-item flagging
Automatically flagged phased-out and discontinued items the moment they fell off the lineup.
Routed to retail
Surfaced flagged stock for quick transfer to retail stores — turning stranded inventory into sellable product.
Faster turnover
Sped inventory turnover and cut storage costs while widening what stores could offer customers.
Skills & Tools
The stack behind this build — tap any to see related work.
The Impact
Stranded inventory caught automatically and routed to stores before it aged — faster turnover, lower storage costs, and a wider selection on the retail floor.
From Dead Stock to Sold
The best inventory tool is the one that never lets product sit forgotten. Automatically flagging off-lineup items and moving them to where they’d sell turned a quiet storage cost into recovered revenue.
Image credits: “Interior of The Warehouse 01 aisles” by Panamitsu (CC BY-SA 4.0) · “Forklift Operator Smile” by Marius140% (CC BY-SA 4.0) · “Customer lounge at Volvo showroom – geograph.org.uk – 7348013” by Jonathan Hutchins (CC BY-SA 2.0) · “Modern warehouse with pallet rack storage system” by Axisadman (CC BY-SA 3.0)
