Product Pricing Calculator
Pricing a handmade product means accounting for materials, labor, packaging, and platform fees before solving for a target margin — not adding a flat 2× markup to materials. This Excel calculator runs the math for you and outputs a defensible retail price plus per-batch unit cost at scale.
A three-tab Excel workbook for makers, bakers, and small-batch sellers who need to stop guessing what to charge. Tab one is a Read Me with the math written out plainly and a platform-fee cheat sheet (Etsy, Shopify, Square, Stripe). Tab two is the Pricing Calculator itself — per-SKU columns for materials, labor (hours × rate), packaging, shipping supplies, platform fee %, fixed fee, and target margin %, with a suggested retail price that solves the math after fees. Tab three is Batch Pricing — one product, multiple batch sizes, side-by-side per-unit cost so you can see whether scaling up is worth it before you do it.
- A Pricing Calculator tab with formulas wired in — true unit cost, suggested retail, profit per unit, effective margin
- Platform-fee handling done right: fees come out of revenue before margin is calculated, so the suggested price actually clears the target margin after Etsy or Stripe takes their cut
- A platform-fee cheat sheet for Etsy, Shopify, Square, PayPal, and Stripe — copy the right numbers into the calculator
- A real-world sanity check column that flags below-cost pricing, aggressive (70%+) margins, and thin (<30%) margins
- A Batch Pricing tab that shows per-unit cost at 5, 10, 25, 50, 100, and 250 units — the math behind "is it worth scaling up?"
- Six sample SKUs across candles, soap, baked goods, and jewelry you can replace with your own catalog in a few minutes
Educational tool only — not financial, tax, or legal advice. Platform fees (Etsy, Shopify, Square, Stripe, PayPal) change periodically; verify current rates against each platform's published schedule before relying on the suggested retail. Pricing strategy varies by product category, channel, and jurisdiction — the multipliers and margin floors in the workbook are starting points, not industry standards. Use the cost outputs as estimates; actual material draw and labor will vary batch to batch.
Why most makers underprice by 18–25%
The two costs makers omit most often are labor and packaging. A candle that takes 12 minutes of hands-on time at a $20/hour effective wage carries $4.00 of labor cost — frequently more than the wax itself. Mailers, labels, tissue, and tape on a $24 ship-to-buyer order can run $2.50–$4.00. Add a 6.5% Etsy transaction fee on the gross plus a $0.20 listing fee, and a candle priced at "2× materials" lands well below cost-of-goods plus operating expenses.
The calculator solves for retail price after fees, which means the suggested price clears the target margin once Etsy or Stripe takes their cut — not before. Change the platform-fee percent and the price recalculates.
How the batch-pricing tab works
The Batch Pricing tab lays out per-unit cost at 5, 10, 25, 50, 100, and 250 units side by side, holding fixed setup costs constant and varying only the variable per-unit costs. The "is it worth scaling?" question becomes a number: at 100 units the cookie costs $0.62, at 25 units it costs $1.18, and the difference compounds across an order.
Use this when a buyer asks for a wholesale-style price break. Plug their order quantity into the matching column and you can quote a defensible discount that still clears margin.
Or skip the spreadsheet entirely
A spreadsheet runs the math once. Ardent Seller runs it continuously — every time a material price changes, every recipe and product reprices itself, and your retail and wholesale tiers stay in sync with the cost. So the price you charge tomorrow reflects what the candle actually costs you today.
Recipe costing
Roll material, labor, and overhead into a true unit cost that updates automatically when an ingredient price moves — the calculator math, but always live.
Pricing tiers (retail & wholesale)
Maintain retail and wholesale prices per product, with one-click application of margin rules — synced with cost so a fee or material change reprices everything.
Production runs & batch tracking
Track real batch sizes, real labor, and real yield — so the per-unit cost in your reports comes from data, not estimates.
Frequently asked questions
How do I price a handmade product?
Calculate true unit cost first — materials, labor (hours × your hourly rate), packaging, and overhead allocation. Then apply your target margin AFTER subtracting platform and processing fees from gross revenue. The simplest formula is: retail price = (true unit cost + target profit) ÷ (1 − fee percentage). For wholesale, use a 50% margin floor as a sanity check.
What is a good profit margin for handmade products?
A defensible retail margin for handmade goods is 50–70% (i.e., cost is 30–50% of price). Wholesale margin is typically 50% (keystone pricing), and retail is 2× wholesale or more. Margins below 30% rarely cover real labor; margins above 70% suggest your labor or material allocation is too low.
Should I include my labor in pricing?
Yes — always. Pay yourself an hourly wage in the cost calculation, even if you re-invest the profit. Skipping labor makes your prices look profitable on paper but hides the fact that you are working for free. The most common reason makers burn out is undervalued labor compounding across hundreds of units.
How do I price for Etsy versus my own site?
Etsy charges roughly 6.5% transaction fee + $0.20 listing fee + 3% + $0.25 payment processing on US orders. Shopify charges a flat $9–$39/month subscription plus 2.9% + $0.30 per transaction. Use the calculator's platform-fee column to set the right fee for the channel — and consider keeping retail prices identical across channels to avoid channel cannibalization.
Related resources
Product Pricing Calculator (Live)
Live web version of our Excel pricing calculator. Materials + labor + packaging + platform fees → defensible retail at your target margin, with batch-pricing tiers.
Pricing Personality Quiz
9-question shareable quiz that classifies you into one of 8 maker pricing personalities — from Cost-Plus Cathy to Reluctant Raiser Rita. Personalized next-move advice.
Should I Raise My Prices? Decision Tool
A live web tool that runs the +10% / +20% / +30% price-hike math for one product — including the volume drop that comes with each — and tells you which scenario clears the most monthly profit.
Maker Hourly-Rate Pricing Calculator
Pick a target hourly rate, enter your materials, hands-on minutes per unit, and platform fees — the calculator returns the minimum price that actually pays you that rate after fees and costs. Maker-business specific, not a "freelance day rate" tool.
Etsy Fee & True-Profit Calculator
A working Excel calculator for Etsy sellers — every fee broken out, bulk reconciliation across 60 orders, and a listing-price solver that targets a margin AFTER Etsy takes its cut.
Recipe Scaling & Batch Calculator
A working Excel recipe scaler — enter a base recipe, set a target yield, and every ingredient auto-scales with unit conversions (oz/g/lb/ml/cups). Plus a batch-cost tab and a unit-conversion reference.
Soap Maker's Cost-Per-Bar Calculator
A working Excel cost-per-bar calculator for cold-process and melt-and-pour soap. Oils, lye (auto-calculated from SAP values), fragrance, colorants, mold and packaging in; per-bar fully-loaded cost out — with cure-weight loss baked into the bar count.
Wholesale Line Sheet
A working Excel line sheet for handmade wholesale — buyer-ready front sheet, per-SKU pricing math behind it, and the formulas already wired in.
Inventory Tracker Starter Kit
A working Excel inventory tracker for makers — raw materials, finished goods, packaging, and a purchase log. Reorder thresholds and a status column do the math; conditional formatting flashes red when you are below the line.
From the blog
Articles that dig deeper into the topics this tool covers.
Recipe Costing 101: How to Calculate the True Cost of Every Product You Make
Learn how to calculate the real cost of every product you make — from raw ingredients to labor and overhead — so you can price with confidence and protect your profit margins.
Margin vs Markup: The Pricing Math Mistake That's Quietly Ruining Your Profit
Half the sellers who say they run a "50% margin" are actually running a 33% margin and subsidizing their own business. Here is the difference between margin and markup, why the confusion costs real money, and the pricing math that separates the sellers who stay open from the ones who quietly close up shop.
Against the "Just Charge More" School of Pricing Advice
"Just charge more" is the most common pricing advice on the internet, and the most useless. Raising prices is sometimes the right move, but the line skips every step that decides whether the hike works. Three places it goes wrong, three things to check first, and what to actually do this week.
Wholesale Pricing for Handmade Products: How to Set Minimums, Protect Margins, and Not Undersell Yourself
A boutique owner wants to carry your products. You have no idea what to charge. Most makers default to 50% off retail and hope the volume makes up for it. It usually does not. Here is how to set wholesale prices, minimum orders, and terms that grow your business without gutting your margins.