The key idea

On hand stock is physically present. Available stock is the portion that can be assigned to a new order under the warehouse's rules. Reserved, damaged, quarantined or otherwise unavailable copies should not be promised again. A reliable dashboard explains these components rather than showing one ambiguous inventory number.

This is an original operational explainer. Its examples and decision rules are illustrations, not measured customer results or universal service commitments.

Make the stock states explicit

Start with counted units at a defined warehouse and location. Separate sellable copies from inspection, damage and other holds. Then subtract valid reservations from the sellable balance to determine what a new order can use. Incoming production belongs in another field until it is received and approved. Do not let a forecast or a printer status change physical stock directly. Each movement should represent a recorded event that operations can trace.

Reserve atomically when orders compete

Two customers can place orders at the same time. Both must not be promised the same final copy. The reservation process needs one consistent decision against the current balance, with a clear backorder outcome when supply is insufficient. Cancellations should release reservations once, and dispatch should consume the reserved units once. An interface refresh is not a substitute for these transaction controls on the server.

Worked example · illustrative assumptions

Assume a warehouse counts 40 books. Three are damaged and two await inspection, leaving 35 sellable copies. Twelve are reserved for existing orders. Available stock for a new order is therefore 23. Another ten books have shipped from the printer but are not yet received. Those ten may inform future planning, but they do not increase the 23 copies that can be promised from the shelf today.

Put it into practice

  • Display physical, sellable, reserved and available quantities separately.
  • Keep incoming books outside current available stock.
  • Make reservation, cancellation and dispatch changes traceable and duplicate safe.

Watch out for

Do not subtract the same reservation twice when an imported opening balance already excludes committed orders. Record what the supplied stock figure means before combining it with an order import.

Can available stock be lower than the number I see on the shelf?

Yes. Some visible copies may already belong to orders or be held for inspection. A physical count and a promiseable balance answer different questions.

AI assisted editorial content with original planning examples. Source links support the stated source notes; operational suggestions are guidance rather than guarantees. Provider rules and product coverage can change. Editorial approach · BooksAhead.ai connection status.