Low Stock Alert Report

What This Sidekick Query Does

Create a low stock alert report for my store:

Alert threshold: [10] units or less

For each low-stock product, show:

  Product name and variant
  Current inventory quantity
  Average daily sales (last 30 days)
  Estimated days until stockout
  Recommended reorder quantity (based on [30] day supply target)
  Priority level:
    
      [RED] URGENT: Less than 3 days of stock
      [YELLOW] WARNING: Less than 7 days of stock
      [GREEN] MONITOR: Less than 14 days of stock
    
  


Sort by: Days until stockout (most urgent first)

Also show:

  Total number of products at risk
  Estimated revenue at risk if these go out of stock
  Products that went out of stock in the last 7 days


Format as a clear, actionable report I can share with my purchasing team.

Expected Output

Tips to Improve Results