Available-to-Sell Vs On-Hand Inventory: What Fulfillment Managers Need To Know

Inventory available for new orders after accounting for reservations, holds, buffers, and allocations.

Available-to-Sell Inventory available for new orders after accounting for reservations, holds, buffers, and allocations. The distinction between ATS and raw on-hand inventory is critical for fulfillment teams: on-hand tells you what physically exists in a facility, while ATS tells you what you can actually promise to new customers without breaking existing commitments or safety rules.

Confusing these two numbers is a frequent source of oversells and mis-allocated stock. A warehouse might show a large on-hand figure for a SKU, but if most of that quantity is reserved for pending orders, tied up in returns inspections, or assigned as safety buffers, the true sellable inventory — the ATS — is much lower. Systems that expose both figures and keep them in sync reduce errors and speed decision-making for sales, customer service, and replenishment teams.

Key Differences Between ATS And On-Hand

Understanding the operational meaning of each term helps when setting policies or configuring systems:

• On-Hand: Physical count of units in the warehouse. It is the inventory book number before factoring in commitments or restrictions.
• Available-to-Sell: Portion of on-hand that is free to be allocated to new orders after subtracting reservations, holds, and buffers.
• Committed/Reserved: Quantity already promised to specific orders or transfers; reduces ATS but not necessarily the on-hand count until picked.
• Backorder/Inbound Considerations: On-hand is indifferent to inbound receipts; ATS may be configured to include inbound that will be available within a lead-time window.

Why The Distinction Matters For Fulfillment Operations

Several operational outcomes hinge on treating ATS and on-hand separately:

• Order Promises: Customer-facing inventory must be based on ATS to avoid overselling items already allocated to other channels.
• Pick Planning: Pick waves should rely on committed quantities but reference ATS for available pool planning and capacity management.
• Replenishment Decisions: Buyers should use a mix of ATS and forecasted demand; on-hand alone can mask unavailable stock locked in returns or quality holds.
• Performance Metrics: Fill rate and perfect order metrics are better correlated with ATS accuracy than with raw on-hand counts.

System Behavior And Synchronization Issues

Most WMS and OMS platforms distinguish ATS and on-hand in their data models, but synchronization gaps create problems:

• Latency: If reservations or order cancellations don't sync instantly, ATS shown to sales channels can be stale.
• Double Reservations: Poor integration can allow multiple systems to reserve the same stock, reducing ATS inaccurately.
• Manual Overrides: Operators sometimes manually adjust on-hand counts without adjusting reservations, leading to mismatches between the two figures.

Practical Example To Illustrate The Difference

Warehouse A shows 500 units on hand for SKU-101. Of those, 300 are already committed to outbound orders, 50 are on hold for quality inspection, and 50 are kept as a safety buffer for retail replenishment. The ATS calculation yields:

ATS = 500 – 300 – 50 – 50 = 100 units available for new orders.

If the sales channel lists inventory using on-hand (500) rather than ATS (100), multiple customers may place orders that the warehouse cannot fulfill, forcing cancellations or expedited shipments at higher cost.

Recommendations For Warehouse Managers

Operational changes that reduce ATS/on-hand mismatches include:

• Use ATS For Customer-Facing Inventory: Ensure storefronts and marketplaces consume ATS, not raw on-hand.
• Automate Reservations: Reserve at the point of order confirmation and release on cancellation to keep ATS current.
• Align Holds Processes: Standardize hold reasons and time limits, and automate release after inspection outcomes.
• Audit Integration Points: Monitor API errors between WMS, OMS, and marketplaces to avoid reservation drift.
• Educate Teams: Train customer service and sales on the difference so they provide accurate delivery estimates.

In short, the Available-to-Sell number is the actionable inventory after subtracting reservations, holds, buffers, and allocations — while on-hand is simply what sits in the four walls. Keeping them distinct and synchronized prevents oversells, improves customer trust, and streamlines fulfillment planning.