Every stock report has a number that looks bigger than the quantity you can ship. A supplier may have finished 240 units while your warehouse has only released 110. Both numbers are useful. The one you need at checkout is the quantity the right location can actually pick for a new order.
Start with the quantity you can release
Give each state an owner and a rule for when it changes. A supplier can confirm a production batch is finished. The warehouse confirms how many units arrived. An agreed release check decides what can go into the pickable inventory. Those milestones can happen on different days.
| State | What the team can promise |
|---|---|
| In production or moving between sites | A planning window based on a confirmed milestone |
| Received, awaiting inspection | A receiving count and the date of the next check |
| Available | A new order against the quantity at an eligible location |
| Reserved or committed | Stock for the order or channel that already has the claim |
| On hold | A decision date, with a reason and an owner |
If you sell on Shopify, use its own labels when assigning a state. The platform separates incoming units from available stock and includes committed and unavailable units in its on-hand inventory. Check the meaning of each column against the warehouse system before you join the reports. Shopify inventory states
Work through a real-looking count
Suppose the warehouse records 180 units on hand for a medium charcoal variant. Twenty are committed to paid orders and 15 are on hold after a carton arrives wet. That leaves 145 units available for new orders at that location. Another 60 units on an inbound transfer belong on the replenishment plan until receipt and release.
If 40 of the 145 available units are allocated to a separate marketplace, publish the adjusted quantity to the other storefront. Check how your systems record reservations before doing the maths. If the stock report has already taken the 40 out of its available column, subtracting them again creates a false stockout.
Give customer support the next useful date
On a held order, share the milestone the team can actually observe. “Inspection is scheduled for Thursday, and we’ll confirm dispatch once the count is released” is easier to act on than “stock is arriving soon.” A customer who needs delivery by Friday can make a decision with a range and a clear update time.
Put the state, quantity, location, owner and next review time on the same line in the exception list. At the daily cut-off, check purchases and returns since the last count, release any approved stock, and reconcile the new quantity against channel orders. An available balance can change several times in one day. Keep the time of the last update visible.
Before you open backorders
Pick one SKU and trace it from the purchase order to the warehouse count and the store. If anyone gives a different answer about when a unit becomes available, settle that rule before promising a date. Start with the SKUs customers are trying to buy today. Explore HQ warehousing




