- Home
- Skills
- E-commerce
- E commerce Profit Leak Auditor
Works with the AI tools you already use
E commerce Profit Leak Auditor
Identify loss-making SKUs and hidden costs with a clinical unit economics audit for e-commerce sellers.
$5
E commerce Profit Leak Auditor
Example session with this skill installed
Audit these SKUs: SKU-A (Price $45, COGS $12, Shipping $8, Fee 15%, Returns 5%). SKU-B (Price $18, COGS $9, Shipping $6, Fee 10%, Ad Spend $4/unit). Quantity is 100/mo each.
- Read your context and instructions
- Compiled the e commerce profit
- Generated the document
Analyzed 2 SKUs and identified a critical profit leak in the low-cost tier. While SKU-A is healthy, SKU-B is currently operating at a net loss per unit when advertising and shipping are factored in.
Profitability Executive Summary
- Total SKUs analyzed: 2
- Strongly profitable SKUs: 1 (SKU-A)
- Loss-making SKUs: 1 (SKU-B)
- Largest identified profit leak: High shipping and ad spend relative to price on SKU-B.
- Highest-impact recommended action: Increase SKU-B price to $24.99 or reduce ad spend.
- Data limitations: Payment processing fees and packaging costs were Not Provided.
SKU Profitability Table
| SKU | Selling Price | Total Variable Cost | Profit/Unit | Margin % | Status | Priority |
|---|---|---|---|---|---|---|
| SKU-A | $45.00 | $26.75 | $18.25 | 40.5% | Profitable | Low |
| SKU-B | $18.00 | $20.80 | -$2.80 | -15.5% | Loss-making | Immediate |
Profit Leak Breakdown
| Leak | Affected SKU | Cost/Impact | Severity | Evidence | Recommended Fix |
|---|---|---|---|---|---|
| Ad Burden | SKU-B | $4.00/unit | High | 22% of revenue spent on ads | Cap CPA at $1.50 |
| Shipping Ratio | SKU-B | $6.00/unit | High | Shipping is 33% of price | Set free shipping floor |
| Return Impact | SKU-A | $2.25/unit | Medium | 5% return rate estimated | Review QC for SKU-A |
Pricing Analysis
| SKU | Current Price | Break-even Price | Target (30%) | Max Discount |
|---|---|---|---|---|
| SKU-A | $45.00 | $26.75 | $38.21 | 15% |
| SKU-B | $18.00 | $20.80 | $29.71 | 0% |
Seller Action Plan
Immediate: Stop or drastically reduce ad spend on SKU-B. Every sale currently loses $2.80.
Next: Test a price increase for SKU-B to $24.95 to achieve a thin but positive contribution margin.
Monitor: Track if SKU-A return rates increase after recent supplier batch changes.
Next steps
- Audit packaging for SKU-B to see if shipping can drop below $4.50.
- Provide payment processing fees (e.g., Stripe/Paypal) for a more accurate net calculation.
- Calculate Total Profit Impact by multiplying unit loss by monthly volume ($280/mo loss).
e-commerce-profit-leak-auditor.pdf
PDF · document
Example file from a real run - the skill writes it into your workspace.
Connects securely to your tools. The creator never sees your data.
What you get
About this skill
The problem
E-commerce sellers often scale revenue while losing money on every order due to hidden costs. Identifying which SKUs are actually profitable requires manual, error-prone spreadsheets that fail to account for shipping, returns, and platform fee volatility.
What it does
- Calculates true unit economics by normalizing COGS, shipping, platform fees, and payment processing.
- Identifies specific profit leaks like excessive discounting, return-rate impact, and shipping burden.
- Categorizes SKUs into profitability tiers from "Strongly Profitable" to "Loss-Making."
- Generates a prioritized action plan for pricing adjustments, supplier negotiations, and fulfillment changes.
Why this beats prompting it yourself
General AI often assumes missing costs are zero, leading to dangerously inflated profit projections. This skill enforces strict accounting rules, distinguishes between gross and contribution margins, and highlights "Not Provided" data points to ensure you never make business decisions based on incomplete math.
Use cases
- Auditing a Shopify or Amazon catalog to prune loss-making products.
- Calculating the maximum discount threshold for a seasonal sale without going into the red.
- Evaluating the impact of a supplier price hike on your net contribution margin.
- Setting a minimum viable price for new product launches based on target margins.
Known limitations
Cannot pull live data directly from seller APIs. Requires manual input of cost and fee data. Does not account for fixed overhead like rent or salaries.
How to install
Works the same in every agent - Claude, Cursor, Codex, Copilot and 20+ more.
- 1
Download the ZIP
Free skills download straight away. Paid skills unlock right after purchase.
- 2
Unzip into your skills folder
Every agent reads skills from one folder on your machine. Drop the unzipped folder in there.
- 3
Ask your agent to use it
Restart the agent if it was already running. It picks the skill up automatically - no config needed.
Skills folder by agent
Click the path to copy it. Create the folder if it does not exist yet.
Reviews
No reviews yet
Be one of the first to try it. Every listed skill passes our trust checks below.
Security scanned
Passed our 8-point scan before listing
Fresh listing
Recently published to Agensi
30-day refund
Not a fit? Get your money back
Trust & safety
Security scanned
Verified clean 4 days ago
- Passed all security checks, Safe to install