Profit Margin Analyzer

Most ecommerce sellers track revenue but lack visibility into true per-product profitability. Hidden costs like marketplace referral fees, FBA storage charges, payment processing fees, return shipping costs, and advertising spend can turn seemingly profitable products into money losers. This skill performs a comprehensive margin analysis that accounts for every cost layer between your supplier invoice and your net profit, revealing which products actually drive your bottom line and which ones are quietly draining cash.

Use when

• A seller says "I am making sales but my bank account isn't growing" or "I need to figure out which products are actually profitable after all fees"
• An ecommerce operator asks "what is my true margin on this product after Amazon FBA fees, returns, and PPC spend" or needs help calculating landed cost including duties, freight, and warehousing
• A brand manager wants to compare profitability across sales channels to decide whether to prioritize Amazon, Shopify, TikTok Shop, or wholesale based on real net margin data
• A finance team needs a per-SKU profitability report that includes all variable and allocated fixed costs to support pricing decisions, discontinuation reviews, or investor reporting

What this skill does

This skill takes your product cost data, selling prices, and operational expense inputs and builds a multi-layer margin waterfall analysis for each product or SKU. It starts with your gross selling price and systematically subtracts every cost component: cost of goods sold including raw materials and manufacturing, inbound shipping and duties, marketplace or platform fees broken down by referral fees and fulfillment fees and storage fees, payment processing fees, outbound shipping costs if seller-fulfilled, estimated return costs based on your category return rate, advertising cost per unit based on your ad spend and conversion data, and allocated overhead costs. The output reveals your true contribution margin per unit and identifies which cost layers have the biggest impact on profitability, giving you clear levers to pull for margin improvement.

Inputs required

• product_data (required): For each product or SKU provide the selling price, cost of goods sold or supplier price, and the sales channel where it is sold. Include at least the product name, unit cost, and current retail price. If you have multiple variants or pack sizes, list each separately.
• sales_channel (required): Which platform or platforms you sell on such as Amazon FBA, Amazon FBM, Shopify with self-fulfillment, Shopify with 3PL, TikTok Shop, Shopee, Lazada, or wholesale. This determines which fee structures to apply in the calculation.
• monthly_units_sold (optional): Average monthly unit sales per product. Enables calculation of total monthly contribution by product and helps allocate fixed costs more accurately across your catalog.
• ad_spend_data (optional): Monthly advertising spend and number of units sold through ads per product. Allows calculation of advertising cost per acquisition and its impact on per-unit margin. If not provided the skill will note that advertising costs are excluded from the analysis.
• return_rate (optional): Your average return rate by product or category. If not provided the skill uses industry-standard return rates for your product category as a default estimate.

Output format

The output is organized into four sections. First, a Per-Product Margin Waterfall that shows each cost component as a line item from gross revenue down to net contribution margin, displayed as both dollar amounts and percentage of revenue, making it immediately clear where margin is being consumed. Second, a Profitability Ranking Table that sorts all analyzed products from highest to lowest net contribution margin percentage, flagging any products with negative margins or margins below a minimum viability threshold of 15 percent. Third, a Cost Driver Analysis section that identifies the top 3 cost categories consuming the most margin across your catalog with specific recommendations for reducing each, such as negotiating supplier pricing, switching fulfillment methods, reducing return rates through better product descriptions, or optimizing ad spend efficiency. Fourth, a Scenario Modeling section that shows how your margins would change under three scenarios: a 10 percent reduction in COGS through supplier negotiation, a shift from current fulfillment to an alternative method, and optimization of advertising spend to your target ACOS or ROAS. Each scenario shows the projected per-unit and monthly impact.

Scope

• Designed for: ecommerce operators, DTC brand owners, marketplace sellers, and finance teams managing product profitability
• Platform context: Amazon FBA and FBM, Shopify, TikTok Shop, Shopee, Lazada, wholesale, and multi-channel operations
• Language: English

Limitations

• Fee calculations use current publicly available fee schedules for major platforms. Your actual fees may vary based on account tier, negotiated rates, or promotional fee structures not reflected in standard schedules
• Does not pull real-time data from your seller accounts or accounting software. All analysis is based on the cost and revenue figures you provide as inputs
• Tax implications including sales tax, VAT, and income tax are not included in the margin analysis as these vary significantly by jurisdiction and business structure. Consult a tax professional for tax-inclusive profitability analysis