How To Calculate Available-to-Sell Inventory For Multi-Channel E‑Commerce

The quantity of inventory currently available for new customer orders after accounting for holds and allocations.

Available-to-Sell Inventory The quantity of inventory currently available for new customer orders after accounting for holds and allocations. Calculating ATS correctly is essential when you publish inventory to multiple sales channels that each require different rules for reservation, buffer, and fulfillment lead time.

Calculating ATS is straightforward in concept but requires disciplined inputs and clear rules. At a minimum you need an accurate on-hand count and up-to-date lists of allocations and holds. For multi-channel sellers, add channel-specific reservations, in-transit adjustments, and planned outbound allocations (for B2B shipments or retail restock) to the calculation.

Basic Formula

Start with a simple, auditable formula:

ATS = On-Hand Stock - Allocations - Holds - Reserved Buffers - Incoming Holds

Each term must be defined consistently in your WMS/OMS to avoid double-counting. For example, 'Allocations' should include confirmed orders and committed picks; 'Holds' should include QC, customs, or legal blocks; 'Reserved Buffers' are deliberate safety stock; 'Incoming Holds' are receipts already logged but blocked (e.g., failed vendor inspection).

Channel-Specific Adjustments

Different channels often require different ATS treatments. For instance, marketplaces that charge penalties for cancellations may need conservative buffers; wholesale customers may have dedicated allocations that never hit general ATS. Configure channel rules in your OMS to present the correct ATS per channel.

• Marketplace Rules: Apply conservative buffers for channels with late-fulfillment penalties.
• Retail Accounts: Dedicate allocations for standing orders to avoid drawing from B2C ATS.
• Brick-and-Mortar Replenishment: Reserve planned transfer quantities as committed until shipped.

Practical Calculation Example

Warehouse shows on-hand = 5,000 units for SKU-456. Confirmed allocations: 1,200 units for web orders, 800 units for a wholesale pallet order, and 300 units staged for a same-day pickup. Holds: 200 units under QC, 100 units under customs review. Reserved buffers: 150 units safety stock for regional retail. Incoming holds: 50 units recently received but flagged. Calculate ATS:

ATS = 5,000 - (1,200 + 800 + 300) - (200 + 100) - 150 - 50 = 2,200 units

This 2,200 should be what online stores, marketplaces, and other channels see when they request availability for new orders—except where channel-specific rules override it.

Real-Time vs. Batch Calculations

Real-time ATS (driven by WMS/OMS events) offers the most accurate availability during peak sales. Batch ATS (updated hourly or nightly) risks oversells when volume is high. For slow-moving SKUs, daily updates may be sufficient, but for fast movers or promotional items, real-time updates are best.

• Real-Time Updates: Required for high-turn SKUs and flash sales.
• Near-Real-Time (minutes): Acceptable for normal e-commerce traffic if systems are robust.
• Batch (hourly/daily): Use only for low-velocity SKUs with low oversell risk.

Automation And System Considerations

Automate allocation and hold workflows within the WMS and connect the OMS to sales channels via APIs. Use event-driven architecture where receipts, picks, returns, and holds update ATS immediately. Implement reconciliation jobs to detect discrepancies between physical counts and system ATS, and flag exceptions for investigation.

• WMS Integration: Ensure pick confirmations immediately reduce ATS.
• OMS Rules: Maintain channel-specific reservation logic in the OMS.
• APIs & Webhooks: Push ATS updates to storefronts for instant accuracy.

Operational Tips

Document what each reservation type means, standardize hold release SLAs, and set alerts for when ATS drops below reorder thresholds. For multi-location fulfillment, calculate ATS per location and aggregated ATS for inventory pooling strategies. If using pooled inventory, account for transit time and transfer safety when publishing aggregated ATS.

In short, the Available-to-Sell Inventory calculation reduces to disciplined definitions, reliable data, and automated system updates. For multi-channel sellers, apply channel-specific adjustments and favor real-time ATS where revenue and customer experience depend on precise availability.