Dead Stock Identification and Clearance Plan

Analyze my Shopify store inventory to identify dead stock and create a clearance plan. My store sells [PRODUCT_TYPE] and I want to free up capital tied in unsold inventory.

Please perform the following analysis:


  Define dead stock criteria for my store:
    
      Products with zero sales in the past [ZERO_SALES_DAYS] days.
      Products with fewer than [MIN_SALES] units sold in the past [SLOW_SALES_DAYS] days.
      Products received more than [AGE_DAYS] days ago with more than [REMAINING_PERCENT] percent of original stock remaining.
    
  
  Generate a dead stock report including:
    
      Product name, SKU, variant details.
      Date last sold and total units sold lifetime.
      Current quantity on hand and original quantity received.
      Cost value tied up (unit cost multiplied by quantity on hand).
      Storage cost estimate based on [STORAGE_COST_PER_UNIT] per unit per month.
    
  
  Categorize dead stock into action tiers:
    
      Tier 1: Discount by [TIER1_DISCOUNT] percent and feature in a clearance collection.
      Tier 2: Bundle with popular items to increase perceived value.
      Tier 3: Liquidate through [LIQUIDATION_CHANNEL] or donate for tax write-off.
      Tier 4: Write off and dispose if total value is below [WRITEOFF_THRESHOLD].
    
  
  Create a clearance timeline spanning [CLEARANCE_WEEKS] weeks with escalating discounts.
  Calculate the total capital recovery expected from each tier.
  Recommend preventive measures to avoid accumulating dead stock in the future.


Please sort the report by cost value descending so I can prioritize the biggest capital drains first.