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.

StateWhat the team can promise
In production or moving between sitesA planning window based on a confirmed milestone
Received, awaiting inspectionA receiving count and the date of the next check
AvailableA new order against the quantity at an eligible location
Reserved or committedStock for the order or channel that already has the claim
On holdA 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