Analytics 💎 Built for Sidekick ⚡ Sidekick does this for you
shopify sidekick analytics inventory

Report Out-of-Stock Lost Sales Estimate

Estimate revenue missed while top products were out of stock, using pre-stockout sales velocity.

📋 Prompt
Run in Sidekick
Estimate lost sales from stockouts on my top 20 revenue products over [LAST 90 DAYS].

For each product that had a stockout period in the window:

  Dates it was out of stock
  Number of days out of stock
  Average daily units sold in the 30 days BEFORE the stockout started (the baseline velocity)
  Estimated units lost = baseline daily velocity × days out of stock
  Estimated revenue lost = estimated units lost × average selling price


Ranking:

  Sort products by estimated revenue lost, highest first
  Total estimated revenue lost across all stockouts in the period


Output format:

  Table: product, stockout dates, days out, baseline daily velocity, estimated units lost, estimated revenue lost
  Total row


Deliverables:

  The table and total
  Flag clearly that this is an estimate based on pre-stockout velocity, not a guaranteed figure (some of that demand may have shifted to a substitute product rather than being lost entirely)
  The single product where a stockout cost the most estimated revenue, as the top candidate for tighter reorder-point rules going forward

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