Claude-powered ecommerce business review toolkit — run /ecom review to get a full-store business review with prioritized fixes
Project description
claude-ecom
Turn an ecommerce orders CSV into an executive-grade business review — KPI decomposition, prioritized findings, and concrete next actions. One command.
Who This Is For
- Data Analysts / Marketers who write monthly business reviews from scratch every time
- Sales managers / D2C brand owners, but no analyst on staff
- Anyone who knows revenue dropped but can't explain why
Quick Start
# Install
curl -fsSL https://raw.githubusercontent.com/takechanman1228/claude-ecom/v0.1.3/install.sh | bash
# Drop your orders CSV, Start Claude Code, and run:
/ecom review
Requires: Claude Code CLI, Python 3.10+, and git
What You Get
A single REVIEW.md that reads like a consultant wrote it:
# Business Review
> Revenue reached $9.37M for the year, essentially flat YoY (-1.7%), despite strong
> short-term momentum — the last 90 days surged 84% and November posted +28.5%,
> both driven by Q4 seasonal demand rather than structural growth. The flat annual...
30d Pulse 90d Momentum 365d Structure
Revenue $1.47M (+ 28%) $3.73M (+ 84%) $9.37M (= -2%)
Orders 3,499 (+ 26%) 8,814 (+ 60%) 24,812 (- 11%)
AOV $419 (+ 2%) $424 (+ 15%) $378 (+ 10%)
Customers 1,676 (+ 11%) 2,918 (+ 51%) 4,296 (= flat)
...
Revenue $9.37M (YoY: -1.7%)
├── 🔴 New Customer Revenue $1.45M (15.5%)
│ ├── New Customers: 1,559 (-57.8%)
│ └── New Customer AOV: $305
└── 🟢 Existing Customer Revenue $7.92M (84.5%)
├── Returning Customers: 2,737 (+345%)
├── Returning AOV: $395
└── Repeat Purchase Rate: 75.4%
Executive summary → Multi-horizon dashboard → KPI trees with 🔴/🟢 signals → Findings with "what / why / what to do" → Prioritized action plan with deadlines, success metrics, and guardrails. See a full example output →
Commands
| Command | Description |
|---|---|
/ecom review |
Full business review — auto-selects 30d / 90d / 365d |
/ecom review 90d |
Quarterly focus |
/ecom review How's retention? |
Ask a question instead of a full report |
Input
Any e-commerce orders CSV works.
Required columns: order ID, order date, customer ID or email, revenue (after discounts, before tax/shipping). Optional (enables deeper analysis): quantity, SKU or product name, discount amount. In many cases, column names don't need to match exactly.
How It Works
Orders CSV → Python engine → review.json → Claude → REVIEW.md
Python computes every KPI and runs health checks. Claude reads the structured output and writes the business narrative. Numbers are precise because Python owns them. Interpretation is sharp because Claude owns that.
Example
Tested on Online Retail II (UCI, CC BY 4.0) — a real UK retailer with ~1M transactions over 2 years.
See the full report → | Try it yourself →
Roadmap
- Shopify API integration (skip CSV export)
- Weekly digest mode
- Multi-store comparison
License
MIT
Project details
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Filter files by name, interpreter, ABI, and platform.
If you're not sure about the file name format, learn more about wheel file names.
Copy a direct link to the current filters
File details
Details for the file claude_ecom-0.1.3.tar.gz.
File metadata
- Download URL: claude_ecom-0.1.3.tar.gz
- Upload date:
- Size: 38.1 kB
- Tags: Source
- Uploaded using Trusted Publishing? Yes
- Uploaded via: twine/6.1.0 CPython/3.13.7
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
ab986c65b60703f98ace421e6cab14142a4601d6e8ce74b3ac21a379d0ed929b
|
|
| MD5 |
402a9c2e1f88aa814a6b7bf6e0e93ae5
|
|
| BLAKE2b-256 |
d2303b3c3f0e1bfa8b733e7b365e60707b98b84a70406f6107b8a900d754c0d5
|
Provenance
The following attestation bundles were made for claude_ecom-0.1.3.tar.gz:
Publisher:
publish.yml on takechanman1228/claude-ecom
-
Statement:
-
Statement type:
https://in-toto.io/Statement/v1 -
Predicate type:
https://docs.pypi.org/attestations/publish/v1 -
Subject name:
claude_ecom-0.1.3.tar.gz -
Subject digest:
ab986c65b60703f98ace421e6cab14142a4601d6e8ce74b3ac21a379d0ed929b - Sigstore transparency entry: 1057736251
- Sigstore integration time:
-
Permalink:
takechanman1228/claude-ecom@8102b779f9a681369c43ff5b2566dd42909e31f9 -
Branch / Tag:
refs/tags/v0.1.3 - Owner: https://github.com/takechanman1228
-
Access:
public
-
Token Issuer:
https://token.actions.githubusercontent.com -
Runner Environment:
github-hosted -
Publication workflow:
publish.yml@8102b779f9a681369c43ff5b2566dd42909e31f9 -
Trigger Event:
push
-
Statement type:
File details
Details for the file claude_ecom-0.1.3-py3-none-any.whl.
File metadata
- Download URL: claude_ecom-0.1.3-py3-none-any.whl
- Upload date:
- Size: 29.7 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? Yes
- Uploaded via: twine/6.1.0 CPython/3.13.7
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
83b895a8d698d8fc5e7909ec4a48c5b18b36b98b74da7a34e64f69cc2cc57224
|
|
| MD5 |
4205b8cd035bcd8aa8243ab3f5cd884f
|
|
| BLAKE2b-256 |
b7e15f01346716c8e7108a851420d5f1b5c14c4ed0fe5016c5a4e8e700fad028
|
Provenance
The following attestation bundles were made for claude_ecom-0.1.3-py3-none-any.whl:
Publisher:
publish.yml on takechanman1228/claude-ecom
-
Statement:
-
Statement type:
https://in-toto.io/Statement/v1 -
Predicate type:
https://docs.pypi.org/attestations/publish/v1 -
Subject name:
claude_ecom-0.1.3-py3-none-any.whl -
Subject digest:
83b895a8d698d8fc5e7909ec4a48c5b18b36b98b74da7a34e64f69cc2cc57224 - Sigstore transparency entry: 1057736326
- Sigstore integration time:
-
Permalink:
takechanman1228/claude-ecom@8102b779f9a681369c43ff5b2566dd42909e31f9 -
Branch / Tag:
refs/tags/v0.1.3 - Owner: https://github.com/takechanman1228
-
Access:
public
-
Token Issuer:
https://token.actions.githubusercontent.com -
Runner Environment:
github-hosted -
Publication workflow:
publish.yml@8102b779f9a681369c43ff5b2566dd42909e31f9 -
Trigger Event:
push
-
Statement type: