Shopify shows two inventory numbers that look similar but mean completely different things. On hand counts everything in your warehouse. Available counts what customers can actually buy.
Confusing Shopify on-hand vs. available inventory leads to overselling, disappointed customers, and hours spent fixing order cancellations. Pending orders, reserved stock, and committed inventory create gaps between these numbers that widen as order volume grows.
Most merchants discover the difference after a stockout or overselling damages customer trust.
In this guide, you will learn exactly how Shopify on-hand vs. available inventory works, five common mistakes that cause discrepancies, and how to spot problems before they cost you sales.
Shopify inventory dashboard
Inventory mismatches cost real money, time, and customer trust. Even a single error can trigger a chain reaction across your business.
Business impacts:
The compounding effect is what kills profitability. As you add sales channels, warehouse locations, or integrate accounting systems, each new connection point multiplies the risk of mismatches.
Without real-time synchronization, each system operates on its own timeline. By the time all systems align, customers have already placed orders against phantom inventory that no longer exists.
Shopify’s inventory numbers look simple, but they hide critical complexity. Most errors start with misunderstanding the difference between “on hand” and “available.”
|
Inventory state |
What it means |
Where it shows in Shopify |
|
On hand |
Total physical units in your warehouse |
Products > Inventory > Quantity |
|
Committed |
Units reserved by orders or drafts |
Hidden in order details |
|
Available |
On hand minus committed |
Products > Inventory > Available |
|
Incoming |
Units ordered but not received |
Purchase orders or transfer section |
Table 1: Shopify on-hand vs. available inventory
These five mistakes quietly bloat your on-hand inventory. Spotting them early is the key to accuracy and profit.
On-hand counts include units already committed to unfulfilled orders. If you reorder based on on-hand instead of available, you order too late. Those 50 units showing in stock might already belong to customers waiting for shipment.
How to spot it: Compare Shopify on-hand vs. available inventory weekly. A growing gap means pending orders are tying up more stock than you realize. Check unfulfilled order reports against inventory levels to see the true picture.
Broken items, expired products, and customer returns in poor condition sit in your warehouse counted as inventory. Your system shows 100 units. Only 85 are actually sellable. You overestimate availability and underorder replacements.
How to spot it: Schedule monthly physical audits of actual sellable stock. Compare warehouse counts against system numbers. Create a process to remove damaged goods from inventory counts immediately.
You sell on Shopify, Amazon, and a retail location. Each channel shows its own on-hand count, but none reflects sales from the others in real time.
Your Shopify store shows 30 units while Amazon sold 10 an hour ago. Total on-hand is inflated by units that no longer exist.
How to spot it: Add up on-hand inventory across all channels and compare against a physical count. If the numbers do not match, your channels are out of sync and overstating what you actually have.
Purchase orders ship from suppliers, and some systems count those units as on-hand before they arrive. You cannot sell inventory sitting on a truck. Counting it as available leads to overselling and customer disappointment.
How to spot it: Review how your system handles inbound shipments. Check if units appear in on-hand counts before receiving confirmation. Separate in-transit inventory from warehouse stock in your reports.
Inventory disappears. Employee theft, shipping errors, miscounts, and unrecorded samples create gaps between system counts and physical reality. Small discrepancies compound over months until your on-hand count drifts far from the truth.
How to spot it: Conduct inventory cycle counts on high-value SKUs weekly and full physical inventory quarterly. Track shrinkage as a percentage of inventory value. Investigate when shrinkage exceeds 1-2% consistently.
Webgility’s real-time inventory sync eliminates delays by updating stock instantly across Shopify, Amazon, and your accounting system, so every number matches, everywhere.
Manual checks work for small stores, but as you scale, inventory management automation becomes essential. Use this checklist to prevent most inventory errors.
Daily:
Weekly:
Manual checks become a bottleneck as order volume grows. Look for tools that automate these steps and flag discrepancies automatically.
Suggested read: Shopify Plus vs Multiple Accounts: True Cost & Scale Guide
Manual routines cannot keep up with multi-channel, high-volume, or multi-location operations. Automation is the only scalable solution.
Signs you have outgrown manual checks:
What to look for in a solution:
Webgility delivers on every requirement. Automated reconciliation eliminates the manual matching that consumes hours weekly, while exception alerts flag inventory discrepancies before they cause oversells.
Multi-location support keeps stock accurate across warehouses and retail stores without spreadsheet tracking.
Nappy Shoppe, a baby apparel retailer selling across multiple channels, fell eight months behind on QuickBooks entries while manually managing inventory and orders. They had no real picture of their financial position or accurate stock levels.
After implementing Webgility, they saved 52 hours per week on shipping and order entry, reduced shipping labor by 88%, and finally gained the inventory visibility needed to make informed business decisions.
Book a demo with Webgility today.
On hand is your total physical stock. Available is on hand minus all committed inventory (orders, drafts, holds). Only available inventory can be sold.
If you sell on one channel, check daily. For multi-channel or high-volume stores, automated tools that flag mismatches in real time are best.
Manual adjustments can fix one-off errors, but they do not solve underlying sync issues. Use tools that reconcile inventory and accounting automatically.