Derive the sellable allocation, not the shelf count
The sellable allocation for your storefront is a derived figure: units your business owns or is documented as authorized to sell, at that location, minus units already allocated to existing commitments and units under any hold. Start from the register, apply the ownership filter, then apply the allocation filter. A gross warehouse count becomes a promise to buyers only after both filters.
Watch the direction of each subtraction. If the warehouse system already nets out allocated stock, subtracting those commitments again understates your availability. If it reports gross on-hand units, the units you neither own nor have documented authority to sell must come out before the figure touches the storefront — and commitments and holds come out exactly once, against the eligible allocation that remains. Record which basis the source system reports, from its field definitions or the warehouse's confirmation, rather than assuming from a column name.
Apply the same discipline per owner when several merchants share the location. Units owned by another seller enter your sellable allocation only where a governing document explicitly authorizes you to sell them — some consignment terms do exactly that, defining your sale as the event that settles with the owner. Units with no such documented authority are not your buffer stock, even temporarily, even with an informal understanding. An informal understanding that is not in the governing documents is precisely the fact to escalate, not to rely on.