Task IntentInventory

Restock Quantity Calculator

Calculate optimal reorder quantities for each product based on sales history, lead times, and safety stock levels.

What This Sidekick Query Does

Calculate optimal reorder quantities for each product based on sales history, lead times, and safety stock levels.

Prompt / Skill

Copy, adapt, and run this prompt or skill workflow directly in Shopify Sidekick.

Calculate restock quantities for my products:

Parameters:

  Target stock coverage: [30] days
  Lead time (supplier delivery): [14] days
  Safety stock buffer: [7] days extra


For my top [50] products by sales volume, calculate:

  Average daily sales (last 60 days)
  Current inventory level
  Days of stock remaining at current rate
  Reorder point (when to order)
  Recommended order quantity
  Estimated cost to restock (if cost data available)


Factor in:

  Seasonal trends (compare to same period last year if available)
  Recent sales velocity changes (trending up or down)
  Minimum order quantities if applicable


Output as a restock order sheet with:

  Products that need ordering NOW (below reorder point)
  Products that need ordering within 7 days
  Products that are well-stocked (no action needed)


Sort by urgency.

Expected Output

Calculate optimal reorder quantities for each product based on sales history, lead times, and safety stock levels.

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

Sidekick Skills & Magic Prompt

Create & Manage AI skills for Sidekick. Discover AI skills from other merchants.

Build unlimited custom Sidekick skills, organize prompts into collections, and discover proven workflows shared by other Shopify merchants.

View on Shopify App Store Install Free App