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
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
- 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