Pricing Strategy

Formula Pricing for Custom and Made-to-Measure Products on Shopify

Learn how to build accurate formula-based pricing for custom and made-to-measure Shopify products with variable costs across materials, labor, and options.

2026-07-316 min readBy BulkOps.ai

If you sell custom or made-to-measure products on Shopify — custom furniture, personalized jewelry, made-to-order apparel, or any product where the cost changes based on what the customer actually orders — you already know the pricing challenge. Your margins aren't fixed. Your cost isn't fixed. And applying a single formula to your entire catalog either leaves money on the table or prices you out of the market on your most complex pieces.

The good news: formula-based pricing still works for custom products. It just requires a different setup than what most guides describe. Here's how to do it right.

Why Custom Products Break Standard Pricing Logic

Standard formula pricing assumes a static input: you know what a product costs, you apply a multiplier, and you get your retail price. A Lodge cast iron skillet costs $18 to source — you apply a 2.2× markup and price it at $39.99. Simple.

Custom products break this model because the cost input isn't fixed. A made-to-measure Carhartt-style canvas work jacket might cost $60 in materials for a size Small, but $95 for a 3XL. A custom-sized dining table has a completely different lumber cost at 72 inches than at 96 inches. A handmade leather goods seller might spend 3 hours on a small wallet and 8 hours on a messenger bag.

The formula is still the right tool — you just need to build it around your actual cost structure, not a placeholder number.

The Three Types of Variable Cost in Custom Products

Before you can write a pricing formula, you need to understand which kind of variable cost you're dealing with:

Material-driven cost: The cost scales with material usage. More fabric, more leather, more lumber = higher COGS. This is the most common pattern in made-to-measure goods.

Labor-driven cost: Time is the variable. Custom embroidery, hand-finishing, or bespoke tailoring costs more for complex pieces. Your formula needs to account for time × hourly rate.

Option-driven cost: The customer chooses something that changes the cost — a premium fabric upgrade, a specific hardware finish, a personalization add-on. Each option has a different COGS floor.

Most custom products combine at least two of these. Once you've categorized your cost type, you can write a formula that actually reflects reality.

How to Structure Your Formula by Cost Type

Material-Driven: Price from per-unit cost

The cleanest approach: set your cost per item field accurately at the variant level, then let your pricing formula work from there. If your 72-inch table costs $310 in lumber and hardware, and your 96-inch version costs $490, enter those as separate variant costs. Your formula — say, cost / (1 - 0.45) for a 45% margin — then produces the right price for each automatically.

For a concrete example: a custom canvas tote bag uses $8.50 in materials at the standard size. You want a 40% gross margin. Your formula is cost / (1 - 0.40) = 8.50 / 0.60 = $14.17. Round up to $14.99. If the large size uses $13.20 in materials, the same formula gives you $22.00. Your margin holds across both variants without touching prices manually.

Labor-Driven: Add labor cost to your COGS baseline

Many Shopify merchants under-price custom work because they don't include labor in their cost per item. Fix this by computing a fully-loaded COGS before entering it:

Total COGS = Materials + (Labor hours × Hourly rate) + Allocated overhead

If your hourly labor rate is $25 and a custom embroidered jacket takes 2 hours beyond standard production, add $50 to the base material cost before entering the cost per item. Then your formula prices from a number that actually includes your time. A jacket with $55 in materials and 2 hours of labor has a true COGS of $105 — and at a 40% margin target, should retail at $175, not the $91.67 you'd get from materials alone.

Option-Driven: Create variant groups with separate cost entries

If a premium wool option costs $40 more than the standard polyester blend, create a variant for each option rather than trying to average costs or use a single formula. Shopify variants exist exactly for this reason. Set accurate costs per variant, apply your formula, and let the math run. Trying to use one blended cost across options is how you end up accidentally subsidizing your most expensive configurations.

Setting Up Formula Pricing for Multiple Variants at Scale

Here's where many merchants hit a wall. You've got 30 products, each with 4–8 variants, each with a different cost. Manually calculating prices for 200+ variant combinations isn't just tedious — it's a reliable source of pricing errors that quietly erode your margins.

The practical approach has three steps:

Get every cost per item field populated first. A formula is useless if it's running on blank or incorrect cost data. Before anything else, identify and fix your cost gaps — Shopify Missing Cost Per Item: Why It's Killing Your Margins walks through how to find and bulk-fix these across your catalog.
Group products by margin target. Not all custom products need the same margin. High-labor items might target 50–55%; commodity-adjacent materials might be fine at 35%. Create separate formula rules for each margin tier rather than trying to find one formula that fits everything.
Apply formulas by collection or product type. This lets you run one formula across an entire segment of your catalog without editing each product individually.

BulkOps handles this workflow with its Pricing Rules feature — you write a formula like cost / (1 - 0.45), pick which products or collections it applies to, and it calculates and applies correct prices across all matching variants in one pass. For custom product lines with frequent cost updates from supplier price changes or seasonal materials, this means you can re-price your full custom catalog in minutes instead of hours.

Handling Significant Cost Variance Across Variants

One edge case worth addressing: sometimes the cost variance between your cheapest and most expensive variants is large enough that a single margin formula produces prices that feel off to customers.

Say your custom denim jacket costs $40 in materials at size XS and $72 at size 3XL. A 40% margin formula gives you $66.67 vs $120. That $53 price gap for size alone might read as odd in your store, even though it's mathematically correct.

In this situation, you have two options: accept the mathematically correct prices and communicate openly about why sizing affects cost, or build in a pricing floor that keeps your entry-level size competitive while compressing margin slightly on large sizes. The key is to make this a deliberate, documented choice — not something that happens accidentally because you applied a uniform markup to an averaged cost figure. For more on the underlying math, Shopify Pricing Psychology: Markup vs Margin explains why working in margin percentages (not markup) matters for decisions like this.

Keeping Formula Pricing Current as Costs Change

Custom product pricing has a shelf life. Material costs go up. Labor rates adjust. Supplier invoices shift with the seasons. The formula itself might stay the same, but the cost inputs feeding it need regular review.

Set a calendar reminder to audit cost per item fields quarterly — or whenever a key supplier changes prices. If you source from manufacturers who quote in USD but source materials overseas, exchange rate moves can quietly widen or compress your margins without any visible price change in your store.

A useful benchmark: if your gross margin on any custom product line has moved more than 3 percentage points since you last set prices, there's a stale cost input somewhere. Fix the cost data, then re-run your formula — the prices update automatically without you having to recalculate each variant by hand.

If you're starting from scratch and need to establish your pricing floor before applying a margin formula, How to Set Up Break-Even Pricing on Shopify With Your Cost Data covers the baseline math you need before running any formula.