IceBossPro Blog — Ice Inventory Management

Consignment Stock Tracking in Ice Software

A huge share of the ice business runs on consignment: you fill the store's merchandiser with your bags, the store sells them, and you only get paid for what actually rang up. The ice sitting in that box is still your inventory — your asset, your melt risk, your money — parked on someone else's property. If your system cannot see stock it no longer physically holds, consignment becomes a black hole where product and margin quietly disappear. Consignment tracking is one of the trickiest things ice inventory management software has to get right.

Consignment Stock Is Still Your Stock

The core mental shift is that a bag does not leave your inventory when it enters the customer's freezer — it moves from warehouse to truck to consignment location, but it is still yours until it sells. IceBossPro models this explicitly: real-time stock tracking follows a bag across warehouse, truck, and consignment freezer as three distinct locations you own. At any moment you can see how many of your bags sit in each store's box. That is inventory on your books, not a sale, and treating it that way is what keeps your asset count honest.

Billing on Sell-Through, Not Delivery

The whole point of consignment is that the customer pays for sales, not deliveries. So the number that matters is sell-through — how much moved out of the box since your last visit. In a consignment model, par-vs-actual reporting does double duty: the "actual" you find in the freezer, subtracted from the par you left last time, is both the restock quantity and the amount to bill. If you left the box at 60 and find 22, the store sold 38, so you invoice 38 and restock back to 60. Ice inventory management software that ties these together means the bill and the refill come from the same count, taken once.

The Melt Problem in Consignment

Here is the catch that trips up spreadsheets: not every missing bag was sold. Some melted, some split, some got damaged in the box. If you naively bill every missing bag as a sale, you overcharge the customer and they push back; if you write it all off, you eat losses that were never yours to eat. Shrink/melt tracking separates the two. The reconciliation is: bags left, minus bags found, equals bags gone — and bags gone splits into sold (billable) and shrink (loss). Getting that split right is the entire economics of a consignment account, and it is impossible to do reliably by hand across a whole route.

Scanning Keeps Consignment Honest

Consignment lives or dies on accurate counts, so barcode scanning at both ends of every visit is non-negotiable. The driver scans what remains in the box to establish the actual, then scans the bags added to bring it to par. Those two scans produce the sell-through, the shrink, and the restock in one pass. Because each SKU is tracked separately, a store consigning both 7lb and 20lb bags gets each line reconciled independently — you never bury a 20lb shortage under a 7lb surplus. That SKU discipline is exactly what makes consignment work, and it builds on SKU Management in Ice Inventory Software.

Reconciliation the Customer Trusts

Consignment relationships run on trust, and trust runs on a clear statement. Because every visit logs bags left, bags found, bags billed, and shrink per SKU, you can hand a store manager a reconciliation that shows exactly how the invoice was calculated. No arguments about whether you delivered 40 or 50 last week — the scan history and par-vs-actual reporting are right there. That transparency is often the difference between keeping a good consignment account and losing it to a competitor who cannot prove their numbers.

Seeing Consignment Across the Whole Route

Zoom out and consignment stock becomes a big number: the total value of your ice sitting in other people's freezers right now. Ice inventory management software rolls up consignment inventory across every account so you know how much product and cash is deployed on the street, which accounts turn it fastest, and where too many of your bags are sitting slow and melting. That view turns consignment from a liability you hope works out into a managed, measured part of the operation.

The Takeaway

Consignment is how ice gets into most retail freezers, and it is also where undisciplined distributors quietly lose the most money. Track the stock as yours, reconcile sell-through against shrink on every visit, scan both ends, and bill from the same count that refills the box. Done right inside a real ice inventory management software platform, consignment stops being a leak and becomes one of the most profitable, best-understood parts of the route.