Inventory Health Auditor

Audit ecommerce inventory notes or SKU exports, flag stockout, aging, overstock, capital lock-up, and promo-readiness risks, then turn partial inventory data into a prioritized replenish-hold-clear brief. Use when operators, buyers, planners, or founders need a weekly or monthly inventory diagnosis without live ERP, WMS, or BI integrations.

Overview

Use this skill to translate SKU inventory notes, sales summaries, replenishment lead times, and campaign plans into a practical inventory action report. It is designed for weekly ops reviews, monthly inventory meetings, and pre-promo readiness checks.

This MVP is heuristic. It does not connect to live ERP, WMS, procurement, or marketplace systems. It relies on the user's exported data, pasted notes, and business context.

Trigger

Use this skill when the user wants to:

• identify which SKUs are most at risk of stockout, aging, or overstock
• prioritize replenishment versus hold versus clearance actions
• prepare inventory review notes for ops, procurement, or warehouse meetings
• assess whether current stock is ready for a promotion or seasonal demand spike
• turn partial inventory exports into a management summary plus execution checklist

Example prompts

• "Review our SKU inventory and tell me what needs replenishment first"
• "Which products are aging and tying up too much cash?"
• "Prepare an inventory health brief before our 618 promotion"
• "Help me spot stockout risk across our hero SKUs"

Workflow

1. Capture the review goal, SKU scope, and whether the immediate concern is stockout, aging, or promo readiness.
2. Normalize the main signals: on-hand inventory, sales velocity, lead time, campaign timing, and seasonality.
3. Separate the likely risk pools: stockout risk, aging or overstock risk, capital lock-up, and structural imbalance.
4. Turn each risk pool into concrete actions such as replenish, throttle, bundle, clear, or pause purchasing.
5. Return a markdown inventory report with a priority queue and a 30-day action plan.

Inputs

The user can provide any mix of:

• SKU inventory or on-hand stock notes
• 30 to 90 day sales velocity or sell-through context
• replenishment lead times, supplier constraints, or arrival timing
• campaign plans, promo windows, or seasonal tags
• category labels, hero SKUs, and long-tail notes
• cash, warehouse, or procurement constraints

Outputs

Return a markdown report with:

• an inventory health summary
• a priority queue of major SKU risk types
• recommended actions across replenish, hold, clear, and review
• a 30-day action plan
• assumptions, evidence gaps, and limits

Safety

• Do not claim access to live ERP, WMS, procurement, or forecasting systems.
• Keep replenishment quantities and purchase decisions human-approved.
• Downgrade certainty when sales velocity, lead time, or campaign timing is incomplete.
• Do not treat seasonality or new-product demand as proven when historical data is weak.

Best-fit Scenarios

• weekly or monthly ecommerce inventory reviews
• pre-promo inventory readiness checks
• multi-SKU catalog management without heavy BI tooling
• operator or founder-led businesses that need a fast prioritization layer

Not Ideal For

• real-time replenishment automation
• warehouse slotting optimization
• full demand forecasting or probabilistic planning models
• businesses with no SKU-level inventory or sales visibility at all

Acceptance Criteria

• Return markdown text.
• Include summary, priority queue, action plan, and limits.
• Make the advisory framing explicit.
• Keep the report practical for ops, procurement, and inventory owners.