Case 01
Ninety-six items that existed in the records but could not be promised
A September 2024 collection-service rehearsal examined 600 proposed orders across a defined store cohort. The recorded stock supported 504 allocations as expected. Ninety-six apparent availability results were wrong for the intended promise: fifty-four items were returns awaiting inspection and forty-two were already reserved elsewhere. The problem was not simply that one application refreshed too slowly. The systems were using availability to describe different operating states, and a customer-facing message could conceal that difference.
I brought store operations, supply owners and the channel team together to define the transition from counted item to confirmed reservation. Retail colleagues retained responsibility for whether a returned item was fit for sale and for the allocation policy. My team changed how the agreed status moved through the applications. We accepted a four-week controlled stage rather than widen the service on the strength of an apparently complete inventory view. The defined work cost ₹3.6 crore, including the interfaces, status review and store preparation.
The channel launch lead favoured keeping the announced date and funding exception handling. The alternative was to continue offering a firm collection promise and resolve the exceptions through customer service. That would have transferred a known internal ambiguity to the shopper and the colleague at the counter. We instead withheld the firm message until the reservation was confirmed under the agreed rules. Where an item was still under inspection or already allocated, the system needed to supply a clear status rather than a misleading affirmative answer.
At the end of the controlled stage, all 600 examined proposals carried the correct status for their scenario, including the ninety-six exceptions. That was rehearsal evidence, not a count of actual orders successfully collected. We still needed operating observation during introduction and a route for new exceptions. I reported the cost and the limited cohort alongside the result. The change made the promise more intelligible because we agreed what it meant before asking an interface to transmit it faster.
I would ask store teams to supply examples of unpromisable stock before approving the availability interface, ensuring the first specification distinguishes a recorded item from a customer commitment.