Reorder Point Automation Setup

What This Sidekick Query Does

Help me set up automated reorder points for products in my Shopify store. I want to ensure I never run out of stock on key items while avoiding over-ordering.

Please configure reorder automation based on the following:


  Calculate reorder points for each SKU using this formula:
    
      Reorder Point = (Average Daily Sales x Supplier Lead Time in Days) + Safety Stock.
      Average daily sales should be calculated from the past [LOOKBACK_DAYS] days of order data.
      Supplier lead time for [SUPPLIER_A] is [LEAD_TIME_A] days, for [SUPPLIER_B] is [LEAD_TIME_B] days.
    
  
  Determine safety stock levels:
    
      Use a service level target of [SERVICE_LEVEL] percent (e.g., 95 percent means stockout risk of 5 percent).
      Factor in demand variability and lead time variability from historical data.
      Set minimum safety stock of [MIN_SAFETY] units for all tracked SKUs.
    
  
  Calculate Economic Order Quantity (EOQ) where applicable:
    
      Ordering cost per purchase order: [ORDER_COST].
      Holding cost per unit per year: [HOLDING_COST].
    
  
  Set up automated notifications when inventory reaches the reorder point:
    
      Generate a draft purchase order with suggested quantities.
      Send to [PURCHASER_EMAIL] for review and approval.
      Include current supplier pricing if available.
    
  
  Exclude products tagged [EXCLUDE_TAG] from automation (seasonal, discontinued, etc.).
  Review and recalculate reorder points on a [RECALC_FREQUENCY] basis to adapt to changing demand.


Please analyze my current catalog and show me which products would benefit most from this automation.

Expected Output

Tips to Improve Results