How to identify your most profitable products vs. your best-selling products

The product that sells the most units is not always the one that makes the most money. This basic confusion destroys margins in e-commerce operations every day. The obsession with sales volume [fueled by dashboards that prioritize units sold and gross revenue] obscures a more important metric: the net contribution per SKU after all associated costs.

Distinguishing between bestsellers and profitable products is not an academic exercise. It is the difference between scaling a sustainable business and financing the growth of SKUs that only generate inventory movement with your own margin.

The trap of revenue as the primary metric

Seller Central, Mercado Libre, and Walmart Marketplace display revenue and units sold by default. These metrics are useful for understanding traction, but insufficient for profitability decisions. A product with 500 units per month and a 15% net margin contributes less than one with 200 units and a 35% margin, even though the former appears higher in any report sorted by volume.

The problem is amplified when high-volume products also consume more advertising budget to maintain their position. In competitive categories on Amazon Mexico, it is not uncommon to find SKUs that generate 40% of revenue but only 15% of profit after advertising. The visibility these products provide has value, but that value must be quantified, not assumed.

What is common in accounts that have never performed this analysis is to discover that between 20% and 30% of their active catalog operates with a negative or marginal margin once all costs are correctly allocated.

Actual cost components per SKU

Calculating real profitability requires going beyond the product cost and marketplace commission. The complete list of deductions includes items that many sellers ignore or assign incorrectly.

Direct costs per unit

• Landed cost of goods (including import, duties, and freight to warehouse)
• Marketplace referral commission (varies by category: 8% to 20%)
• Fulfillment fee or shipping cost (FBA, Fulfillment by ML, or own logistics)
• Packaging and preparation costs, if applicable
• Monthly storage fees prorated per unit

Associated variable costs

• Advertising spend attributed to SKU (PPC, Sponsored Products, Product Ads)
• Average coupons and discounts applied
• Return rate multiplied by processing cost
• Cost of units that cannot be recovered due to damage or loss

Advertising allocation is where most sellers make mistakes. If an SKU requires $3,000 MXN per month in PPC to maintain 100 units sold, that $30 per unit must be subtracted from the margin. Many accounts allocate advertising expenses as a general operating cost rather than attributing them to each product, which completely distorts the profitability picture.

Practical methodology for analysis

The exercise requires extracting data from multiple sources and consolidating it into a single view by SKU. For Amazon, you need the Business Report (units and revenue), the fulfillment fee report, Campaign Manager for attributed advertising, and the returns report. In Mercado Libre, the combination of sales reports, commission billing, and the advertising dashboard covers most of the inputs.

With the consolidated data, calculate for each SKU: net revenue (after returns and cancellations), minus all direct and variable costs. The result is your net contribution per SKU. Divide it by the units sold to obtain the contribution per unit, and by the revenue to obtain the contribution margin percentage.

Sort your catalog by absolute net contribution, not by percentage margin or units. An SKU with a 50% margin but $2,000 monthly contribution matters less than one with an 18% margin but $15,000 contribution. Percentage margin indicates efficiency; absolute contribution indicates business impact.

Strategic decisions according to the quadrant

Once the actual profitability has been calculated, each SKU falls into one of four profiles that determine different actions.

High volume, high profitability

These are the SKUs that sustain the operation. The priority is to protect your position: maintain stock, defend against competitors' listings, and avoid unnecessary experiments. Any marginal improvement here [reducing ACoS by one point, negotiating a better product cost] has an amplified impact due to volume.

High volume, low profitability

The most common case of value destruction. Before abandoning these SKUs, assess whether the problem is structural (category margins, price competition) or correctable (advertising inefficiency, negotiable product cost, abnormal return rate). In accounts with this profile, optimizing ACoS or reducing returns can turn a problematic product into a net contributor without sacrificing volume.

Low volume, high profitability

Candidates for investment in visibility. If the margin supports more advertising expenditure, scaling these SKUs may be more profitable than continuing to feed low-margin bestsellers. The question is whether the addressable market allows scaling without destroying the margin due to increased competition or the need to lower prices.

Low volume, low profitability

Candidates for discontinuation or liquidation. These SKUs consume operational attention, warehouse space, and working capital without a proportional return. Most catalogs have between 15% and 25% of SKUs in this quadrant that should be eliminated.

Frequency and automation of analysis

This analysis is not a one-time exercise. Fulfillment costs change, storage fees are seasonal, ACoS fluctuates with competition, and product costs are renegotiated. A quarterly review is the reasonable minimum for medium-sized operations; monthly for large catalogs or volatile categories.

Automation depends on the volume of SKUs. For catalogs with fewer than 50 active products, a well-structured spreadsheet with manual data import works. Above that, tools such as Helium 10 Profits, Sellerboard, or custom solutions with API connections reduce consolidation time from hours to minutes.

The most common mistake is to build the analysis once, make decisions, and not update it. Profitability per SKU is dynamic. A product that was profitable six months ago may be operating at a loss today due to changes in any of the variables in the model.

Implications for advertising and expansion

Profitability analysis by SKU should directly inform advertising strategy. Allocating budget proportionally to revenue or historical volume is the default setting for most accounts, and it is suboptimal. Budget should flow to SKUs where the contribution margin supports the acquisition cost, not to those that already sell by inertia.

For catalog expansion, the analysis reveals what characteristics the most profitable products share: category, price range, level of competition, type of fulfillment. Launching new SKUs with the profile of those that already work is more likely to succeed than diversifying blindly.

The distinction between what sells best and what contributes most is operationally awkward because it contradicts intuition and standard platform reports. But it is the only solid basis for inventory, pricing, advertising, and catalog development decisions that build a profitable business, not just one with impressive volume on the dashboard.