Inventory πŸ’Ž Built for Sidekick ⚑ Sidekick does this for you
shopify sidekick inventory abc-analysis classification

ABC-Based Reorder & Count Policy

Classify every SKU into A/B/C tiers by revenue contribution, then assign each tier a reorder frequency and safety-stock rule instead of treating all products the same.

πŸ“‹ Prompt
Run in Sidekick
Classify my catalog into A/B/C tiers by revenue contribution and assign each tier a different reorder policy β€” I’m currently treating every SKU the same way and it’s wasting effort on low-value items.


  Pull total revenue and unit sales per SKU over the last [LOOKBACK_PERIOD].
  Rank SKUs by revenue contribution and classify: A = top [A_PERCENT]% of revenue, B = next [B_PERCENT]%, C = the remainder.
  Show me the SKU count and revenue share in each tier, plus the top 10 SKUs in tier A by name.
  For each tier, propose a policy:
    
      Tier A: review frequency (e.g. weekly), target safety stock in days-of-cover, count frequency.
      Tier B: same fields, less frequent.
      Tier C: same fields, least frequent β€” flag any C-tier SKU that’s also dead stock (zero sales in [DEAD_STOCK_DAYS] days) as a candidate to stop reordering entirely.
    
  
  Ask which policy defaults I want to keep vs adjust before finalizing.


Once confirmed, tag each product with its tier ([TAG_PREFIX]-A, [TAG_PREFIX]-B, [TAG_PREFIX]-C) so the classification is visible on every product going forward, and give me the final tier assignment counts.

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