Inventory
💎 Built for Sidekick
âš¡ Sidekick does this for you
shopify
sidekick
inventory
promotion
oversell
Flash Sale / Promotion Stock Pre-Check
Before a planned promotion goes live, check available stock for every featured SKU against a projected demand multiplier and flag anything likely to sell out or oversell.
📋 Prompt
I’m running a promotion on [PROMOTION_NAME] starting [PROMOTION_START_DATE] featuring [PRODUCT_LIST_OR_COLLECTION]. Check whether my current stock can survive the expected demand spike. Pull current available inventory per SKU for the featured products, at every location that sells online. Pull average daily sales velocity over the last [BASELINE_DAYS] days for each SKU as the baseline. Apply a demand multiplier of [DEMAND_MULTIPLIER]x to the baseline (my estimate for how much the promotion will lift sales) and project expected units sold over the promotion’s [PROMOTION_DURATION_DAYS]-day run. Flag every SKU where projected demand exceeds current available stock — these will sell out or oversell during the promotion. For each flagged SKU, show the shortfall in units and whether there’s an open purchase order that could close the gap before [PROMOTION_START_DATE]. Recommend which flagged SKUs to either restock before launch, cap per-customer purchase quantity on, or pull from the promotion entirely if restock isn’t possible in time. Give me the flagged list first, sorted by shortfall size, before any narrative summary.
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