Inventory 💎 Built for Sidekick ⚡ Sidekick does this for you
shopify sidekick inventory bundles forecast

Bundle Component Depletion Forecast

Using bundle-to-component metafield mappings and bundle sales velocity, forecast which component SKU will run out first and constrain bundle availability.

📋 Prompt
Run in Sidekick
Forecast when each of my bundles will be constrained by a component running out of stock.


  Pull the bundle-to-component mapping from the [BUNDLE_COMPONENT_METAFIELD] metafield on each bundle product (or use this mapping if metafields aren’t set up yet: [BUNDLE_LIST_WITH_COMPONENTS]).
  Pull current available stock for every component SKU, plus each bundle’s sales velocity over the last [LOOKBACK_DAYS] days.
  For each bundle, calculate how many more bundle units can be sold before its most-constrained component runs out (component available stock ÷ quantity-per-bundle, taking the minimum across all components in that bundle).
  Combine that with bundle sales velocity to project days-until-component-stockout per bundle.
  Rank bundles by soonest projected stockout, and name the specific limiting component for each.
  Flag any component shared across multiple bundles where combined bundle demand alone (before counting any standalone sales of that component) would deplete it within [ALERT_WINDOW_DAYS] days.


Give me the ranked table first — bundle name, limiting component, days until constrained — then details per bundle below it.

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