Skip to content
SheetModel
Real EstateE-commerceConstructionB2B SaaSWorkforceAbout
E-commerce 3 Excel tabs included 9 min read Updated Jan 2026

Shopify product pricing matrix

Build true unit cost, derive a margin-targeted retail price, test promo, wholesale and marketplace tiers — and find the discount point where margin collapses.

Typical DTC contribution margin
55–70%
Payment fees
2.9% + $0.30
Wholesale discount
40–50%
Advertisement
Advertisement

True unit cost is not your supplier invoice

Pricing decisions go wrong at the cost input, not the markup. Suppliers quote an FOB price; your actual cost of putting a sellable unit on a shelf includes packaging, inbound freight, duty, labour for kitting, and a returns provision.

The returns provision is the one that gets omitted most often. If 6% of orders come back and processing a return costs $12 plus 5% of the item’s value in shrink, that is roughly $1.40 per unit sold — which on a $34 product is over 4% of revenue, right off the margin.

True unit costlive formula
True cost = Materials + Packaging + Labour + Inbound freight
          + (Return rate × (Processing cost + Price × Shrink%))
Because the returns provision depends on price, changing your price changes your cost. The workbook handles this with a circular-safe formula that references the retail price cell.
Cost lines people forget
LineTypical amountWhy it matters
Returns provision2–6% of revenueScales with price, not volume
Inbound freight & duty$0.50–2.50 per unitVaries with shipping mode and volume
Payment processing2.9% + $0.30Fixed fee hurts low-price products most
Packaging & inserts$0.80–2.00 per unitOften 5% of a $30 product
Marketplace fees5–15%Zero on your own store, material on Etsy

Deriving price from a margin target, not a multiplier

Most brands price by applying a markup — "3x cost" — which produces margins that vary wildly with the cost basis and ignores channel fees entirely. A better method is to solve for the price that delivers a target contribution margin after fees.

Price required for a target contribution marginlive formula
Price = (True unit cost + Fixed fee) ÷ (1 − Fee% − Target margin%)

Example: ($14.10 + $0.30) ÷ (1 − 0.029 − 0.62) = $41.09
The workbook solves this once and drives all five pricing tiers from the result, so changing the margin target updates retail, promo, wholesale and marketplace prices together.
Required price at a $14.10 true cost, 2.9% + $0.30 fees
Target marginRequired priceContribution per unit
50%$29.51$14.75
58%$35.56$20.62
62%$41.09$25.48
70%$59.42$41.59
Advertisement

The discount ladder: where margin actually dies

Discounts are usually decided emotionally. The discount ladder makes it arithmetic: for each discount level, what price do you charge, what do you pay in fees, what is left as contribution, and what margin percentage does that represent?

The pattern is consistent and important: because fees are proportional to price, a discount reduces contribution by more than the discount percentage. A 20% discount on a 62%-margin product typically reduces contribution by 27–30%. And every fee line — payment processing, marketplace commission, affiliate payout — stacks on top of the discount rather than alongside it.

  • A 20% discount on a $41 product costs $8.20 of price and roughly $8.90 of contribution.
  • Discounts below break-even are not marketing, they are charitable donations.
  • Site-wide promotions should be tested against a held-out control group to measure incrementality.
  • Wholesale at 45% off is structurally different from a consumer promo — it carries no acquisition cost.

Pricing across channels without cannibalising yourself

Most brands sell through their own store, a marketplace and wholesale, and each channel has a different fee structure and price expectation. The chart below shows how the same true unit cost produces very different contribution depending on channel.

Channel economics on a $41 retail price, $14.10 true cost
ChannelSelling priceFeesContributionMargin
DTC (Shopify)$41.00$1.49$25.4162.0%
Promotional (−20%)$32.80$1.25$17.4553.2%
Wholesale (−45%)$22.55$0.95$7.5033.3%
Marketplace (+15%)$47.15$7.37$25.6854.5%
Bundle (per unit, −12%)$36.08$1.35$20.6357.2%

Covering overhead: the number behind the number

Contribution margin pays for variable costs; it must also carry your fixed overhead — software, salaries, warehousing overhead, retainers. The coverage ratio is monthly contribution divided by monthly fixed overhead, and it is the fastest way to see whether a product is actually funding the business.

Below 1.0x, the product loses money at any volume. Between 1.0x and 2.0x it pays its own way but leaves little room. Above 2.0x the product is subsidising growth, whether in ads or in new SKUs.

  • Units needed to cover overhead = fixed monthly overhead ÷ contribution per unit.
  • Coverage ratio above 2.0x means the product has room to fund acquisition.
  • A price increase of 5% typically improves coverage by 12–18% because costs stay flat.
  • Cutting COGS by 5% improves coverage by roughly half as much as a 5% price increase.

How to use this tool

  1. Build the true unit cost. Enter materials, packaging, labour, inbound freight, return rate and return processing cost. The allocator produces a true cost that includes the returns provision most brands omit.
  2. Set a contribution margin target. 55–70% for DTC with paid acquisition. The calculator solves for the price that delivers it after all percentage fees.
  3. Test the pricing tiers. Review retail, promotional, wholesale, marketplace and bundle pricing side by side. Every tier is derived from the same cost basis, so comparing contribution is apples to apples.
  4. Download and run the discount ladder. The workbook shows contribution at 0% to 50% discount so you know exactly where margin dies before you run the next promotion.

What is inside the download

A true-cost allocator that captures returns and freight, a scenario tab with five pricing tiers and overhead coverage maths, and a discount ladder plus competitor benchmark index.

  • COGS Allocator — a separate worksheet in product-pricing-matrix.xlsx.
  • Pricing Scenarios — a separate worksheet in product-pricing-matrix.xlsx.
  • Benchmark Index — a separate worksheet in product-pricing-matrix.xlsx.

Where these defaults come from

Every pre-filled value in the calculator above is listed below with its basis. None of it is proprietary to us — we do not run primary research. Statutory figures come from the regulator, fee schedules from the vendor that charges them, ranges from published industry surveys, and conventions are labelled as rules of thumb. When you have your own numbers, replace the default: the workbook formulas do not care where an input came from.

DefaultValue usedBasisSource
Card processing feeStandard online card rate. The fixed component makes sub-$20 price points structurally harder.2.9% + $0.30Vendor rate cardStripePricingOpen source
Wholesale discount off MSRPMust still clear true variable cost plus contribution after returns and freight.40–50%Rule of thumbNo authoritative source — industry convention
Target net margin (marketplace)Below 10% leaves no resilience to a fee change or a returns spike.15–25%Rule of thumbNo authoritative source — industry convention
Marketplace referral feeCharged on the total sales price. Category exceptions apply — check your own category.15% (8% media & some electronics)Vendor rate cardAmazonSelling on Amazon — pricing and referral feesOpen source

Full source registry, verification status and review cadence: data sources & methodology.

Frequently asked questions

Start from true unit cost, add your fixed payment fee, then solve for the price that leaves your target contribution margin after all percentage fees: Price = (Cost + Fixed fee) ÷ (1 − Fee% − Target margin%). This produces a defensible floor. Then validate against competitor prices and willingness to pay before finalising.

Software that pairs with this model

These are the platforms our models are designed to work alongside, chosen because their pricing or data appears in the model itself. Some links are affiliate links — they cost you nothing, and they never influence a formula, a default value or a result.

Related models