- Home
- Skills
- Business & Operations
- Ecommerce Profit Margin Auditor
Works with the AI Agents you already use
Ecommerce Profit Margin Auditor
Audit SKU-level profitability, calculate true contribution margins, and identify cost leaks in ecommerce data.
$12.99
Ecommerce Profit Margin Auditor
Example session with this skill installed
Audit these October stats for SKU: GLOW-01. Units: 500. Price: $25. COGS: $8. Shipping: $4. Amazon Fee: 15%. Ad Spend: $2,000. Returns: 10 units. We have $1,000 fixed monthly warehouse overhead.
- Read your context and instructions
- Compiled the ecommerce profit margin
I have audited the performance for SKU: GLOW-01 based on your October data. The analysis excludes sales tax and assumes the shipping cost is a flat rate per unit sold.
Ecommerce Profit Margin Audit
1. Executive Summary
SKU GLOW-01 is currently contribution-positive before advertising, but the high ad spend relative to volume is significantly compressing margins. The product is currently not covering its allocated fixed warehouse costs.
2. SKU-Level Profitability Table
| Metric | Value | Status |
|---|---|---|
| Gross Sales | $12,500.00 | Verified |
| Returns/Refunds (10 units) | ($250.00) | Verified |
| Net Sales | $12,250.00 | Calculated |
| COGS ($8.00/unit) | ($4,000.00) | Estimated |
| Marketplace Fees (15%) | ($1,837.50) | Calculated |
| Shipping ($4.00/unit) | ($2,000.00) | Estimated |
| Contribution Profit (Pre-Ad) | $4,412.50 | Calculated |
| Ad Spend | ($2,000.00) | Verified |
| Total Contribution Profit | $2,412.50 | Low Margin |
3. Break-Even Analysis
- Unit Contribution: $8.82 per unit (after variable costs and ads).
- Fixed Costs: $1,000.00.
- Break-Even Units: 114 units required to cover fixed warehouse overhead.
- Current Margin: 19.7% contribution margin.
4. Cost Leak & Risk Findings
Ad Spend Intensity: Advertising accounts for 16.3% of net revenue, which is high for a $25 item with a 15% marketplace fee.
*
Shipping Ratio: Shipping costs represent 16% of the gross price. Investigate if $4 covers packaging and labor or just postage.
Next steps
- Verify if the $4 shipping cost includes packaging materials and pick/pack labor.
- Review ad campaigns for GLOW-01 to lower the ACOS below 15%.
- Calculate the impact of a $2 price increase to $27 to buffer against the high shipping-to-price ratio.
Connects securely to your tools. The creator never sees your data.
About this skill
Many store owners confuse revenue with profit, overlooking hidden fees, shipping subsidies, and ad spend that erode the bottom line. This skill performs a rigorous SKU-level economic audit to identify cost leaks and calculate true contribution margins.
What it does
- SKU-level analysis organizes inputs like COGS, landed costs, and marketplace fees to determine profitability per product.
- Contribution modeling separates fixed and variable costs to show the real impact of every sale.
- Break-even calculation determines the exact units or price points needed to cover operating expenses.
- Scenario testing simulates how changes in price, return rates, or ad spend affect final margins.
- Data auditing flags missing costs, inconsistent time periods, and potential double-counting in your spreadsheets.
How it works
- Validate data by checking for missing SKU identifiers, unclear currencies, or tax inconsistencies.
- Normalize costs into categories including net sales, fulfillment, returns, and advertising.
- Generate audit using formulas for gross profit, unit contribution, and break-even points.
- Identify risks by flagging low-margin products or high return burdens relative to revenue.
Frameworks & tools
This skill works with raw data from Shopify, Amazon Seller Central, or custom ERP exports. It requires manual input of cost structures or CSV/Excel data uploads containing sales and expense details.
Why this beats prompting it yourself
Standard prompts often treat missing data as zero or hallucinate marketplace fee structures. This skill enforces strict accounting logic, requiring formula transparency and flagging incomplete estimates rather than presenting them as verified net profit.
Use cases
- Auditing a product catalog to identify which SKUs are losing money after ad spend.
- Calculating the minimum viable price for a new product launch including all marketplace fees.
- Modeling the impact of a 10% discount campaign on overall monthly contribution margins.
- Investigating how return rates on specific categories are impacting warehouse labor costs.
Known limitations
Does not provide tax, legal, or formal accounting advice. Calculations are limited by the accuracy and completeness of user-provided data. High-level net profit requires full fixed cost visibility.
Not a substitute for formal accounting or tax advice. Reliability depends entirely on user-provided data accuracy. Cannot access live store APIs without explicit authorization.
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