- Home
- Skills
- E-commerce
- E commerce Profit Leak Auditor
Works with the AI Agents 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
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).
Connects securely to your tools. The creator never sees your data.
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.
Requires manual input of cost/fee data. Does not calculate net profit involving fixed overhead like rent or payroll. Accuracy depends entirely on the granularity of supplied cost data.
How to use
- 1
Connect your agent to the Agensi MCP
Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup
- 2
Sign in to Agensi
Your agent shows a sign-in link. Sign in and click Allow.
- 3
Ask for what you need
Your agent loads this skill and uses it on your task. It always asks before any payment.
Reviews
No reviews yet
Be one of the first to try it. Every listed skill goes through the trust checks below.
Security scanned
Checked by our 8-point scan before listing
Fresh listing
Recently published to Agensi
Money-back guarantee
Doesn't do what its page promises? You get your money back.
Trust & safety
Security scan
Security scan passed 1 month ago
Permissions
No special permissions declared or detected