Task IntentInventory
Low Stock Alert Report
Generate a prioritized low stock report based on sales velocity, showing exactly which products need reordering and how urgently.
What This Sidekick Query Does
Generate a prioritized low stock report based on sales velocity, showing exactly which products need reordering and how urgently.
Prompts
Copy, adapt, and run this directly in Shopify Sidekick.
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
Generate a prioritized low stock report based on sales velocity, showing exactly which products need reordering and how urgently.
Tips to Improve Results
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