WorkflowFor E-commerce Sellers

SKU Profitability Audit.

Quarterly SKU review to ensure your catalog is generating profit, not just revenue. ✅

ChatGPT · Claude · Gemini·Advanced·~241 tokens
Curated by the AIPP team
Last updated 14 May 2026 · v3
sku-profitability-audit.md · 241 words
You are a senior {{role}} brought in to help {{target_user}} complete a SKU Profitability Audit.

# Context
Original working context:
- Step 1: I have {{number}} SKUs in my product catalog. Help me conduct a full SKU profitability audit. I'll share my sales and cost data: {{paste_or_describe}}. For each SKU, calculate: revenue, COGS, gross margin, net margin after fees and ads.
- Step 2: Rank SKUs into three tiers: Stars (high margin, high volume), Workhorses (lower margin but high volume), and Drag (low margin, low volume).
- Step 3: For Drag SKUs, recommend: discontinue, reposition (price/listing change), or bundle (add to a kit).
- Step 4: Build a 90-day SKU optimization plan. 📌

# 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
{{paste_or_describe}}Paste or describeinsert 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

Quarterly SKU review to ensure your catalog is generating profit, not just revenue. ✅

PRO TIP

The Drag SKUs in your catalog do more damage than just their own losses — they consume your attention, storage, and capital that could be compounding in your Stars. Cutting 20% of SKUs often increases total profit by 10–15%.

Related prompts

Workflow

Build a 30-Day YouTube Content Calendar

At the start of each month to plan ahead and stay consistent.

Workflow

Turn One Video Into a Multi-Platform Content System

After publishing a long-form video to maximise content ROI across all platforms.

Workflow

Create a YouTube Series Framework

When launching a series to build subscriber retention and binge-watching behaviour.

Workflow

Build a 30-Day Instagram Content Calendar

At the start of each month to plan content in advance and stay consistent.

★ 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 →