Your best-selling item may actually be the least profitable: compare profit margins and return rates today. When a collection’s ranking is based solely on orders or revenue, the product at the top may consume enough discounts, media spending, shipping subsidies, and return costs that it loses ground on the list of most profitable items.
This doesn’t mean abandoning the best-seller. It means understanding its role before increasing its exposure, buying more fabric, producing another size run, or allocating more budget to the campaign. The first step is to replace a broad question—“What sells the most?”—with a more useful one: “How much profit does each product generate after variable sales costs?”
Why can sales rankings lead to the wrong decision?
Sales figures show the ability to generate revenue, but they don’t tell the whole story. Two products with similar sales may have very different discounts, costs, fees, and return rates. If the team looks only at gross revenue, it treats the two as equivalent when they may contribute in opposite ways to cash flow.
Consider an illustrative example. Dress A received 100 orders at R$ 300 each and generated R$ 30,000 in gross revenue. After accounting for discounts, product cost, taxes, fees, subsidized shipping, and returns or exchanges, the contribution per completed order was R$ 45, totaling R$ 4,500.
Dress B received 70 orders at R$360, totaling R$25,200. With fewer discounts and a lower impact from exchanges, it yielded R$90 per completed order: R$6,300. In terms of revenue, Dress A comes out on top. In the contribution ranking, Dress B generates more revenue to cover fixed costs and sustain the business.
This comparison also helps avoid another mistake: automatically restocking everything that sells quickly. Sales velocity matters, but it must be considered alongside contribution margin, available inventory, and the stage of the collection. The final decision on restocking remains with the brand.
Which numbers need to be compared side by side?
There’s no need to start with a complex dashboard. A spreadsheet with one row per product—or per variation, when color and size significantly affect the result—already allows you to see differences that revenue figures alone hide.
- Gross revenue: the value of items sold before deductions.
- Discounts: coupons, promotions, and price reductions applied to the product.
- Cancellations and returns: sales that were not recorded as revenue.
- Exchanges: instances that preserved or altered the sale but generated additional costs.
- Product cost: the amount set by the brand to produce or purchase the item.
- Taxes and fees: variable amounts associated with the transaction.
- Subsidized shipping: the portion of shipping costs paid by the brand.
- Media spending: when there is reliable attribution by product or campaign.
- Completed orders: orders that remained valid after cancellations and returns.
The analysis period must allow sufficient time to account for the brand’s typical exchanges and returns. Comparing a collection launched five days ago with another whose orders have already gone through the entire cycle distorts the results. If the window is still open, flag the data as provisional.
It’s also worth distinguishing between item-level data and order-level data. A coupon applied directly to a product is easy to associate. Shipping costs for a purchase with three items, however, require a division criterion, such as value or weight. The most important thing is to choose a rule, document it, and apply the same rule to the periods being compared.
How to calculate contribution margin per product without creating false precision?
Contribution margin is a managerial perspective. It does not replace accounting nor is it intended to capture all of the company’s costs in a single number. Its purpose is to show how much remains from a sale after deducting the costs that vary with it.
- Start with net revenue: gross revenue minus discounts, cancellations, and returns.
- Subtract the cost of goods sold: use the criteria adopted by the brand’s finance department.
- Subtract variable costs: taxes, fees, shipping subsidies, and other amounts directly linked to the sale.
- Consider the impact of exchanges: return shipping, reshipment, and any revenue differences.
- Divide by the number of completed orders or items: this allows you to compare the average contribution, not just the total.
Avoid allocating payroll, rent, technology, and other fixed costs per product in the initial analysis. An arbitrary breakdown can give the appearance of accuracy and hide the trend you’re looking for. First, compare the contribution before fixed costs. Then, the finance department can assess whether the collection as a whole generates sufficient revenue to cover overhead.
The same caution applies to media. If the customer journey involves multiple ads and touchpoints, attributing the entire investment to the last product viewed can lead to a flawed conclusion. When in doubt, maintain two metrics: contribution before media costs and the result of the campaign or the advertised product group.
How can you compare products that serve different purposes?
Not every product needs to deliver the same result. An entry-level product can attract new customers. Another might increase the average order value. A brand-building product can support the collection’s messaging even if it sells less. The key is to confirm this role with data, rather than accepting it as an automatic justification.
A simple matrix helps organize the conversation between sales, marketing, product, and finance:
- High sales and high contribution: maintain exposure, monitor the product lineup, and evaluate restocking with the brand team.
- High sales and low contribution: Review discounts, costs, shipping subsidies, media spending, and reasons for returns before escalating the issue.
- Low sales and high contribution: Test a new display, content, creative, or combination with other items before adjusting the price.
- Low sales and low contribution: Reduce media pressure and evaluate the item’s role in the collection, its launch timing, and pricing strategy.
Then, add two layers. The first is the collection stage: launch, mid-cycle, or end-of-season. The second is the customer type: first-time buyer or repeat buyer. If an entry-level item truly attracts new customers, track whether these people return and how much they contribute to subsequent orders. Without this verification, an “acquisition product” can become nothing more than a fancy name for low margins.
What analysis can the team start today?
Start with the 20 highest-grossing products over a period that has already passed the brand’s usual replacement cycle. The goal isn’t to create the definitive report. It’s to identify decisions that would change if the ranking were based on more than just sales figures.
- Sort the 20 products by gross revenue.
- Calculate the net revenue and total contribution for each one.
- Divide the contribution by the number of items or completed orders.
- Note which products had discounts, subsidized shipping, or increased media promotion.
- Compare exchanges and returns by product, color, and size when there is sufficient volume.
- Classify each item into the four sales and contribution groups.
- Select three decisions: one regarding display, one regarding price or promotion, and one regarding purchase or restocking.
- Record the hypothesis and the date of the next review.
Imagine that the top-selling product also has a high concentration of exchanges in a specific size. The solution doesn’t have to be cutting all advertising. The brand team can review the size chart, product description, photos, size range, and customer service feedback before making a decision. If the problem is concentrated in one size variation, a targeted action preserves the rest of the product line.
Another scenario: a high-contribution item appears infrequently in store windows and campaigns. Instead of offering a discount, the brand can test a new visual presentation, place it in a complete outfit, or position it near an item with higher traffic. The test changes one variable at a time and compares contribution, not just orders.
When sales, costs, media, and returns are spread across different departments, putting together this comparison can be more difficult than making the decision itself. If this is the scenario for your brand, the free e-commerce assessment is a no-obligation conversation with WX3 to understand your brand’s operations and how this data informs decision-making.