Skip to content
Enjoy complimentary data migration when switching from your existing bookkeeper or CPA to Institution.

Industry guides

A product's average margin can hide an expensive variant

Compare variant selling prices, actual costs and return patterns before using a product-wide margin to decide what to replenish or promote.

By Institution3 minute readPublished View sources
In this guide

Start with a complete variant population

List the saleable variants beneath the product, including discontinued options that sold during the review period. Preserve the stable variant reference, supplier item, selling unit and cost basis. Two sizes may share a product page while having different purchase costs, packaging requirements or return rates. A product-level average conceals those differences when the sales mix changes.

Shopify provides profit reporting by variant and states that profit is reported only where cost was recorded at the time of sale. Compare the included sales population with the full sales report. An attractive margin can partly reflect omitted variants with missing costs, so resolve coverage before ranking the assortment.

References: Shopify: Profit reports

Calculate the weighted result and its components

Use actual net sales and the relevant cost of units sold for each variant. Keep discounts and returns associated with the affected option. Calculate the product's overall margin from total profit divided by total net sales; do not average variant percentages without weighting them. A change in product margin can result from mix even when every variant's economics stays constant.

In a hypothetical product, 30 units of variant A sell for $50 each and cost $20 each. Their gross profit is $900, or 60% of $1,500 sales. Thirty units of variant B also sell for $50 each but cost $35 each. Their gross profit is $450, or 30%. Together the product earns $1,350 on $3,000 sales, a 45% gross margin.

That 45% does not describe either option particularly well. If the next promotion attracts mostly variant B buyers, applying the historical product margin will overstate expected profit. Model the likely variant mix rather than assuming that a higher product sales total carries the same contribution as the previous period.

Add the costs that change the assortment decision

Review variant-specific shipping, handling and customer remedies alongside gross profit. A larger size may require another package; a fragile finish may create more replacements. Preserve these costs as separate operating measures so the team can explain the difference between product gross profit and contribution after fulfillment. Do not silently mix incompatible cost definitions across variants.

Allow enough time for returns to emerge before comparing recently launched variants with mature ones. Review whether small sales volumes make the result unstable and whether stockouts prevented customers from choosing an option. Poor sales during an unavailable period do not establish weak demand, just as one costly return does not establish a permanent rate.

Turn the comparison into a replenishment decision

Evaluate options such as variant-specific pricing, a packaging change, smaller replenishment quantities or a different promotional mix. Consider supplier pack requirements and the role of each variant in the overall offer. A lower-margin option may support the range, but that decision should use its observed economics and the cost of holding it.

Record the chosen action, expected mix and assumptions, then revisit the same variant population after implementation. Keep the original analysis so a later product rename or assortment change does not rewrite the comparison. Finance should be able to explain whether the outcome came from better unit economics, a different sales mix or simply more complete cost data.

Sources

Requirements and product details can change. Check the linked guidance for the facts that apply to your situation.

Related reading

Need help with this work?

General information, not personalized accounting, tax, legal, or investment advice. Have the appropriate qualified professional review decisions that depend on your circumstances.