MCP App Store
by KeenEthics
SKU.io ABC Inventory Analysis icon

SKU.io ABC Inventory Analysis

By SKU.io

Get New App Alerts

Overview

Upload a sales or orders CSV, such as a Shopify orders export, and the ABC Inventory Analysis ranks every SKU by revenue share (A, B and C) and by how steady its weekly demand is (X, Y and Z). Each SKU gets a combined class such as AX or CZ and a rule-of-thumb stocking policy, so you can see which products drive the business and which are erratic tail items. Revenue comes from a price or line total column, an optional price list, or units if neither exists. Results appear as a sortable table. Files are processed in memory for the one request and never stored. No account is needed.

Tools

analyze_abc_xyz

ChatGPT
Use this when a seller asks which products matter most, which are their best sellers and which are the long tail, wants an ABC analysis or Pareto (80/20) breakdown of their catalog, asks which SKUs drive most of their revenue, or which products have steady versus erratic demand. It ranks by revenue or units, not profit. Needs sales lines with SKU, date and quantity; revenue comes from a line total or unit price column if the file has one (a Shopify orders export does), from an optional price list, or else the ranking uses units and says so. Returns every SKU's ABC class (revenue share), XYZ class (weekly demand variability), combined class such as AX or CZ, and a rule-of-thumb stocking policy. Read-only; stores nothing.

Capabilities

Interactive

Example Prompts

Click any prompt to copy it.

Similar Apps