By The Skyline Project ·
Copy this worksheet
Scrollable table: swipe horizontally to see every column. You can also focus the table and use the arrow keys.
| Cutoff | SKU | Location | System on hand | Physical count | Difference | Committed | Held | Available after reconciliation | Owner and reason |
|---|---|---|---|---|---|---|---|---|---|
| Nov. 19, 6 p.m. | SHIRT-BLU-M | Store A | 23 | 22 | −1 | 4 | 2 | 16 | Stock lead checks pending pickup |
Illustrative row. Difference equals physical count minus system on-hand. Available here equals confirmed on-hand minus committed and held units, assuming those groups do not overlap. In the example, reconcile the missing unit before treating 22 as confirmed. Use the stock definitions in your own platforms when they differ. If you keep a safety buffer, record it separately and apply it consistently to channel availability. Shopify documents inventory states and locations. Shopify Help Center.
Put five events through the test
- Sell one unit in store and check the online availability.
- Create an online order and confirm the reservation at the correct location.
- Cancel it and check when the platform releases units.
- Return one item as resellable and one as damaged and check both states.
- Attempt a transfer between locations and confirm how in-transit units are shown.
Write expected and actual results next to the order reference. Use sample records and limit changes to a test setup or a controlled pilot. Track mismatched rows divided by total rows counted. Review the reason for each mismatch before widening scope. For product identifiers, GS1 US explains what a GTIN identifies. GS1 US GTIN guide.
Explore technology integration or tell us how your store tracks stock.
