Analytics
๐ Built for Sidekick
โก Sidekick does this for you
shopify
sidekick
analytics
inventory
Report Stockout Risk Forecast
Project which in-stock products will run out within a set window based on recent sales velocity.
๐ Prompt
Forecast which products are at risk of stocking out within the next [14 / 30] days, based on sales velocity over the last [30] days. Per active, in-stock product: Units sold per day, averaged over the last [30] days Current units on hand Days of cover remaining = units on hand รท average daily units sold Projected stockout date Filter and rank: List only products with days of cover under [14] Sort by days of cover ascending (most urgent first) Separately flag any of those products that are also currently a top-20 revenue driver โ a stockout there costs more than a stockout on a slow mover Output format: Table: product, avg daily units sold, units on hand, days of cover, projected stockout date, is-top-revenue-driver flag Deliverables: The ranked table A short list of the products that need a purchase order placed this week, prioritized by revenue impact of a stockout, not just by days of cover alone
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