AgenticFor E-commerce Sellers

Inventory Audit & SKU Rationalization.

When your catalog has grown organically and contains SKUs that are consuming more than they contribute. ✅

ChatGPT · Claude · Gemini·Intermediate·~254 tokens
Curated by the AIPP team
Last updated 14 May 2026 · v3
inventory-audit-sku-rationalization.md · 254 words
You are a senior {{role}} brought in to help {{target_user}} complete a Inventory Audit & SKU Rationalization.

# Context
Original working context: Act as an inventory management consultant. I have {{number}} active SKUs across {{number}} products and my inventory is becoming difficult to manage. Ask me for a download of my current inventory data (sales velocity, COGS, storage costs, margin by SKU). Then: (1) apply a BCG matrix analysis to categorize SKUs as Stars, Cash Cows, Question Marks, and Dogs, (2) recommend the SKUs to discontinue, consolidate, or double down on, (3) calculate the capital and storage cost freed up by rationalizing the bottom 20% of my catalog, and (4) create a SKU rationalization decision template for future product decisions. 📌

# Goal
Produce the exact deliverable requested for this use-case. Make the output practical, specific, and ready to use.

# Constraints
- Use the user's variables exactly where relevant.
- Avoid generic filler and vague advice.
- Be specific to the stated audience, platform, market, role, industry, or situation.
- Ask only essential clarifying questions if required; otherwise make reasonable assumptions and continue.

# Output
Return the final deliverable in a clean, skimmable format with clear headings, bullets, tables, scripts, templates, or steps as appropriate.

The variables to fill in

PlaceholderWhat to put thereExample
{{number}}Numberinsert your specific value
{{role}}Rolefreelance client onboarding strategist
{{target_user}}Target usera freelance consultant

How to customize this prompt

  1. Replace each {{double-curly}} with your real context.
  2. Adjust the constraints section to match your tone — formal, casual, blunt.
  3. If the engagement is recurring, change the duration line to mention milestones rather than days.
  4. Run it in your tool of choice. The output should be ready to paste with at most one small edit.

When to use

When your catalog has grown organically and contains SKUs that are consuming more than they contribute. ✅

PRO TIP

The SKUs you should discontinue first are the ones with both low margin AND low velocity — the double-burden SKUs. Every unit of slow, low-margin inventory represents capital that could be compounding in a Star SKU.

Related prompts

Agentic

Strategy Coach for Ambiguous Direction

Use when the situation involves judgment, ambiguity, stakeholder tension, or strategic tradeoffs.

Agentic

Portfolio Strategy Advisor

Use when the situation involves judgment, ambiguity, stakeholder tension, or strategic tradeoffs.

Agentic

Moat and Differentiation Auditor

Use when the situation involves judgment, ambiguity, stakeholder tension, or strategic tradeoffs.

Agentic

Strategic Narrative Builder

Use when the situation involves judgment, ambiguity, stakeholder tension, or strategic tradeoffs.

★ EXPLORE MORE PROMPTS

More for E-commerce Sellers

Browse all prompts built for E-commerce Sellers — free and premium, ready to copy.

Browse more prompts →