Inventory
💎 Built for Sidekick
âš¡ Sidekick does this for you
shopify
sidekick
inventory
product-launch
allocation
New Product Launch Stock Split
Before a brand-new SKU with no sales history goes live, split initial inventory across locations using the launch performance of comparable past products.
📋 Prompt
I’m launching [NEW_PRODUCT_NAME] on [LAUNCH_DATE] with [TOTAL_LAUNCH_UNITS] units total. Help me split it across my locations since it has no sales history yet. Since [NEW_PRODUCT_NAME] has no history, pull launch-week sales-by-location data for [COMPARABLE_PRODUCT_LIST] — products I consider similar in category/price point — to use as a proxy for expected demand split. Show what percent of each comparable product’s launch-week sales came from each location. Using the average split across the comparables, recommend how many of the [TOTAL_LAUNCH_UNITS] units should go to each location. Flag if any location’s recommended allocation would leave it with less than [MIN_LAUNCH_STOCK] units — that may be too thin to sustain launch-day interest there. Show the final allocation table: location, units, percent of total. Ask for my confirmation before creating the transfer from [SOURCE_LOCATION_NAME] (or receiving location, if this is a new PO) to each destination. After I confirm, create the transfer(s)/allocate the receiving location split accordingly and confirm final units per location.
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