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
Run in Sidekick
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

  1. Copy the prompt above
  2. Open Shopify Sidekick in your Shopify admin
  3. Paste the prompt and replace the bracketed placeholders with your details
  4. Review Sidekick's response and apply the suggestions