Inventory
đź’Ž Built for Sidekick
⚡ Sidekick does this for you
shopify
sidekick
inventory
committed-stock
overselling
Committed vs Available Stock Audit
Check how much on-hand inventory is locked up as committed to unfulfilled orders versus truly available to sell, to catch a false sense of stock coverage.
đź“‹ Prompt
Show me the gap between on-hand inventory and what’s actually available to sell right now. For [PRODUCT_LIST_OR_COLLECTION, or “my full catalog”], pull on-hand, committed, and available quantities per SKU at [LOCATION_NAME, or “all locations”]. Flag every SKU where committed quantity is more than [COMMITTED_PERCENT_THRESHOLD]% of on-hand — meaning most of what looks like stock is already promised to open orders and not really available for new sales. For each flagged SKU, show how many open/unfulfilled orders are holding that committed stock and the oldest order date among them, so I can tell if it’s normal fulfillment lag or a stuck order tying up inventory. Separately, list any SKU where available quantity has gone negative or shows as sellable at 0 available — that’s an active oversell risk right now. Summarize: total SKUs with a committed/available gap, and total units effectively “phantom stock” I’m counting but can’t actually sell. I want this as a real number, not general advice — pull the live committed/available split from my store data.
How to Use
- Copy the prompt above
- Open Shopify Sidekick in your Shopify admin
- Paste the prompt and replace the bracketed placeholders with your details
- Review Sidekick's response and apply the suggestions