How to Price Handmade Items: Materials, Hours and Fees With AI

To price handmade items, add the materials per unit (including waste), your hours at a real hourly rate, a share of monthly overheads, and the marketplace fees, then divide by what remains after fees and your target margin. A candle with a $12.52 full cost needs a retail price near $19 on a marketplace with about 11% fees.

The common error is working forwards: cost, plus a margin, equals price. Fees are a percentage of the price, so they must be taken out of the price, not added to the cost. Ask AI to build the sheet and show its working, but check the totals by hand, because language models slip on multi-step arithmetic. Everything below uses an illustrative candle, so swap in your own figures.

Follow me on Instagram@sagnikteaches

The product: a 300 g hand-poured soy candle

A one-person maker pours candles in batches of 24 in a spare room, photographs and lists them herself, and ships them in a small box. She sells about 300 a month through an online marketplace and a few craft fairs. She has priced at $14 because that is what similar candles seem to cost, and suspects she is working for very little. Her job is to find out, using a costing sheet that AI helps build.

Connect on LinkedInSagnik Bhattacharya

Start by gathering four kinds of number, each in its own tab of one spreadsheet: materials, time, overheads, and selling costs. Then a fifth tab combines them. Keep the tabs separate, because next season the wax price changes and you will want to alter one cell, not hunt through a formula.

Subscribe on YouTube@sagnikteaches

Materials: every item that leaves with the candle, plus the waste

List what goes into one finished unit, including packaging. Work out the price per unit of each item from the last invoice, not from memory. Here is the candle, in illustrative figures:

Now add waste. Candles are lost to sinkholes, frosting, cracked jars and test pours. If one in twenty is not sellable, that is 5% on top: $6.02 x 1.05 = $6.32. If you do not know your waste rate, count the rejects across your next two batches. A guess of zero is almost always too low.

Where AI helps with the materials tab

Paste your last supplier invoices (typed in or as a photo of the invoice) and ask the model to turn them into a per-unit list. The prompt below stops it inventing prices, which is the main failure with this task.

Below are my supplier invoice lines. Build a table with these columns: item, pack size, pack price, unit (g, ml or each), cost per unit.
Only use numbers that appear in the text. If a pack size or price is missing, write "MISSING" and do not estimate.
Show the division you used for each cost per unit so I can check it.

Invoice lines:
{{paste lines}}

Illustrative output: "Soy wax, 10 kg pack, $65.00, g: 65.00 / 10,000 = $0.0065 per g." That is right. The fault to watch for is a pack described as "5 lb" that the model silently converts, rounding as it goes. Ask it to state the conversion, and recompute one line on a calculator. For a tutorial on why this happens, see why AI is bad at maths.

Labour: the hours you really spend, at a rate an employer would pay

Handmade work has two kinds of time. Production time is making: melting, pouring, trimming wicks, labelling, boxing. Selling time is everything else per order: photographing, writing the listing, answering messages, packing, printing a label, walking to the post counter. Most sellers count only the first and then wonder why the week feels long.

Time a full batch once with a phone timer. For the candle: 3 hours 12 minutes for 24 candles, or 8 minutes each. Selling time is estimated at 10 minutes an order, averaged across the month. So the labour per candle is 18 minutes, or 0.30 hours.

Then the rate. Do not choose the lowest number you can bear. A practical rule: take what a skilled job of similar demand pays per hour, and add about 15 to 20% because you receive no paid leave, sick pay or employer pension. Our maker settles on $18 an hour. So labour per candle is 0.30 x $18 = $5.40.

If this number frightens you, resist the urge to quietly set the rate to $8 so the price looks more normal. Keep the honest figure in the sheet. You can then see exactly how much unpaid work a given price implies, which is a real decision rather than a hidden one.

Overheads: the monthly costs that no single candle causes

Overheads are what you pay each month whether or not you sell: the share of rent or electricity used for making, insurance, accounting software, a website or listing tools, the printer, photo backdrops, and a small fund for replacing equipment. Add them up for a typical month and divide by the number of units you sell.

The maker's figures, illustrative: studio share of rent and power $110, product insurance $35, software and subscriptions $48, printing and sundries $32, equipment replacement fund $15. Total $240. At 300 candles a month, that is $0.80 each. Note the dependency: sell 150 a month and the same overhead is $1.60 a unit. Overhead per item is the number most likely to be wrong, so recalculate it every quarter.

Add up the three so far: materials with waste $6.32, labour $5.40, overhead $0.80. The full cost to make and sell one candle, before any selling fees, is $12.52. At her old price of $14, that leaves $1.48 before marketplace fees even start, which at $14 come to about $1.99, so she was losing $0.51 on every candle. That is the case where the AI-built sheet pays for itself in one afternoon.

Marketplace fees: take them out of the price, not off the cost

Fees are mostly a percentage of what the buyer pays, so the higher the price, the more fee you pay. That is why you cannot add them to cost. Use the fee page of the platform you sell through, not a third-party page or an AI summary, because rates change. The figures below are from Etsy's fees policy and its payments policy as they stood in late October and early November 2026; confirm each line on your seller dashboard before you rely on it:

• Listing fee: $0.20 per listing.
• Transaction fee: 6.5% of the displayed price plus whatever you charge for shipping and gift wrapping.
• Payment processing: 3% plus $0.25 per order for a shop paid out in USD, charged on the full sale including tax and shipping (the rate depends on where your bank account is, and the payments policy lists each one).
• Offsite Ads: 15% of an order that Etsy attributes to one of those ads, or 12% once a shop has passed $10,000 in sales over the prior 365 days, capped at $100 per order. A shop under $10,000 can opt out; above it, taking part is required at the 12% rate.

The simplified calculation: assume buyers pay shipping separately, ignore the fee on the shipping portion (it exists, so your real fees run slightly higher), and expect about one order in ten to come through Offsite Ads. The expected ad fee is then 10% x 15% = 1.5% of price. Add 6.5% and 3% and the percentage fees total 11% of price, plus fixed costs of $0.25 + $0.20 = $0.45 per sale (assuming one listing fee per sale, which is slightly pessimistic if a listing renews rarely).

The price formula, with the candle's numbers

Define a target profit as a percentage of the price. Profit here means what remains after you have already paid yourself $18 an hour, so it is the business's own reserve for growth, bad months and tax. Our maker picks 20%.

Price = (full cost + fixed fee) divided by (1 - percentage fees - target margin).

Price = ($12.52 + $0.45) / (1 - 0.11 - 0.20) = $12.97 / 0.69 = $18.80, rounded to $19.

Check by working forward at $19: percentage fees 11% x $19 = $2.09, plus $0.45 gives $2.54 in fees. Profit = $19 - $12.52 - $2.54 = $3.94, which is 20.7% of the price. The formula holds. The jump from $14 to $19 looks daunting, so the next sections test whether the market will accept it rather than flinching.

The sheet, so you can reuse it

Ask AI to build the calculator in a spreadsheet, and give it the structure so it does not improvise. This prompt works in ChatGPT, Claude or Gemini:

Build a pricing sheet with an Inputs block and a Results block. Inputs: materials per unit, waste percentage, minutes of production per unit, minutes of selling per order, hourly rate, monthly overhead, units per month, listing fee, transaction fee %, payment fee %, payment fixed fee, expected ad-fee share of orders, ad fee %, target margin %.
Results: materials with waste, labour per unit, overhead per unit, full cost, percentage fees total, fixed fees total, price needed, profit per unit at that price, and profit as a percentage of price.
Write every formula as a cell reference, no hard-coded numbers. List each formula in plain words beside it.

Open the result and test it with your own known case: enter the candle's numbers and confirm you get $12.52 and $18.80. If you do not, find the formula that is wrong before trusting any other product. If you work in Sheets, these Google Sheets AI prompts cover the build-and-check habit in more detail.

Wholesale: the check most makers skip

A shop that stocks your candle will usually want to buy at about half of the retail price, and in return takes on the selling. Test it. Wholesale at 50% of $19 is $9.50. The cost structure changes: no marketplace fees, no per-order selling time (an invoice for 12 candles takes 15 minutes, so about 1 minute each), but the same materials and overhead. Labour becomes 9 minutes at $18 an hour, $2.70. Cost per candle is $6.32 + $2.70 + $0.80 = $9.82. Revenue $9.50. The maker would lose $0.32 a candle selling to shops at half of retail, and she would not have noticed without the sheet.

There are three ways out, and the choice is hers, not the AI's:

1. Raise retail so that half of it covers wholesale cost with a margin. To make 15% on a $9.82 cost, wholesale must be about $11.55, so retail $23.10 or more.
2. Sell wholesale at about 60% of retail ($11.40), with a minimum order of 12, accepting a thin profit of $1.58 (about 14%) in exchange for large, predictable orders.
3. Decline wholesale for this product and keep it as a retail line.

Many makers choose a retail price at or above double the full cost for exactly this reason. It gives them a retail margin on direct sales and room to wholesale without a loss. A neighbouring tutorial on pricing prompts for bakers uses the same idea for products sold across the counter and to cafes.

Free shipping: a quick sum before you offer it

Buyers like free shipping, and many marketplaces nudge sellers to offer it. It is simply a price rise in disguise. Say the average postage and packaging is $5.20 per candle. Charging it separately keeps the candle at $19, with the buyer paying $24.20. To offer free shipping you either absorb the $5.20 (profit goes from $3.94 to negative) or raise the item price to cover it, with fees also taken from the larger total. Price = ($12.52 + $5.20 + $0.45) / 0.69 = $26.33. The honest comparison for the buyer is $24.20 versus $26.33 shown as "free shipping", and it is for you to decide whether the second wins more sales. Test both on the same listing for four weeks, not across two different products.

Checking the price against the market without copying it

Once the cost-based price exists, compare it with what similar makers charge, but as a check, not a source. Collect ten comparable listings and note price, size, ingredients (soy against paraffin makes a difference) and review counts. Ask the AI to tabulate them, and look for a gap you can defend: a larger candle, a longer burn time, or a better-known scent. If competitors sit at $12 to $15, you have three options: lower cost (cheaper jar, bigger batches), sell something different enough that the comparison fails, or accept lower volume at a fair price. Repeat the ten-listing check every month or two rather than once, because rivals change their prices too.

Be wary of AI answers to "what should I charge" without your costs. They draw on average listings, which include sellers who are undercharging. For the limits of that question, read what AI pricing research can and cannot tell you.

A second product, a different shape: the crocheted toy

The method changes when labour dominates. Take a small crocheted animal: yarn and stuffing cost $2.40, safety eyes and packaging $0.90, so materials with 3% waste are $3.40. Making takes 3 hours 30 minutes, selling takes 12 minutes, and at $18 an hour labour is $66.60. Overhead $0.70. Full cost $70.70. At 11% fees plus a $0.45 fixed fee and a 20% margin the price is ($70.70 + $0.45) / 0.69, about $103.

That is a number few buyers will pay for a small toy. This is the useful moment: the sheet tells you that the product, as made, cannot reach a normal price. The choices are to make it faster (a simpler pattern at 2 hours), to make it a premium item (personalised, named, gift-boxed) with a story that supports a higher price, or to stop making it. Setting the price to $25 and silently paying yourself $5 an hour is a fourth choice, and it should be a conscious one.

The mistake that kept a price low for a year

A pattern worth knowing: a seller costs a product in January, writes the numbers on a notepad, and never updates them. By December the jar supplier has put up prices twice, the wax is 12% dearer, and the marketplace has added a fee. The price has not moved, so the margin has quietly shrunk from 20% to under 10%, and it is invisible because sales are healthy. The fix is dull but effective: put one reminder in the calendar every quarter to update the Inputs block, and keep the previous version of the sheet so you can see how much the cost has moved.

A smaller version of the same mistake is forgetting fees you pay outside the marketplace, such as a payment platform's fee on direct sales, or the cost of a stall at a craft fair, which belongs in the overhead of a fair-only product line. Treat each selling channel as its own column, with its own fees, rather than one blended price.

Using one price for several channels without losing money

Many sellers want the same price everywhere, which is sensible for customers who compare. Work out the price for each channel, then choose the highest, or choose a middle price and accept a lower margin on the dearest channel. In the candle's case, direct sales through her own website avoid the 6.5% transaction fee, so her margin there is higher at $19, while a craft fair needs a stall fee of $45 for a day on which she sells 22 candles, an extra $2.05 a candle. A single price of $19 therefore earns different profit per channel: about $3.94 on the marketplace, perhaps $5.70 on her own site (after a payment processor's fee, which you should check on your own processor's page), and about $4.40 at the fair after the $2.05 stall share, before card-reader fees, which she should look up for her own reader.

Seeing those three figures side by side is what lets her decide where to put her energy. If the fair earns nearly the same profit per hour as the marketplace but needs a whole Saturday, the sheet shows the real return on each.

How to know the new price is working

Change the price on one listing, not all at once. Watch three numbers for four weeks: orders per week, conversion from views to orders if your platform shows it, and the profit per week in the sheet. Here, moving from $14 to $19 turns a loss of $0.51 a candle into a profit of $3.94. Even if she sold 200 a month instead of 300, her $240 of overheads would rise to $1.20 a candle and profit would fall to about $3.54 each, or about $708 a month, against a $153 monthly loss at the old price and volume. Put those figures in the sheet before you decide, because the instinct to protect volume is strong and often wrong.

Keep the sheet, and keep it simple. If you want help setting up a costing sheet that updates from your supplier invoices, or deciding what to price differently by channel, that is the sort of thing an AI implementation consultation can map; see the contact page. The listing itself comes next, and using AI for Etsy titles, tags and descriptions picks up from here.

Pricing questions handmade sellers ask next

What hourly rate should I pay myself?

Use what you would earn doing comparable skilled work for someone else, then add a margin for the benefits you do not get, such as holiday and sick pay. Do not use zero because the work is enjoyable. If the number makes your product unsellable, that is information about the product, not a reason to drop your wage.

Should shipping be built into the price?

Either works, but be consistent. Free shipping means folding the average postage into the item price and then paying marketplace fees on it. Charging postage separately keeps the item price lower and the sums simpler. Weigh two or three typical parcels and use an average, not your cheapest case.

How much below retail should wholesale be?

Shops commonly expect about half of the retail price, which is why many makers set retail at least double their full cost. Check that figure against your own cost first. If half of retail is below cost, the answer is a higher retail price or a minimum order size, not a thinner margin.

Can AI set the price for me?

It can build the sheet, check your sums and test what happens when fees change, but it should not choose the number. It cannot see how your buyers react or what your work is worth to them. Ask it to show its arithmetic and recheck the totals yourself.

Further reads

• Does Writing Etsy Listings With AI Hurt Your Search Ranking? — Whether AI-written listings affect how you rank.
• Can AI Help a Small Shop Set Prices and Promotions? — Set promotions without eroding the margin.
• How to Do Competitor Research With AI in One Afternoon — A structured way to check what rivals charge.
• Best AI Tools for Etsy Sellers, Ranked by Time Saved — Tools that save a marketplace seller time.
• How to Answer Etsy Customer Messages Faster With AI — Answer buyer questions without losing an evening.
• How Landscapers Use AI to Stop Underpricing Jobs — Same underpricing trap, seen from a trade business.
• How to Track Competitors' Prices and Offers With AI — A monthly routine for watching rivals' prices.
• Jewellery Pricing Calculator With AI: Metal, Labour and Markup — Build a jewellery pricing sheet with AI: metal weight and loss, stones, labour, overhead, then retail and wholesale prices that still leave profit.
• Furniture Lead Times: Set Realistic Made-to-Order Dates With AI — How a small furniture workshop works out an honest delivery range from its capacity and queue, and tells customers at the right moments.
• AI Tools and AI Development: The Complete 2026 Guide — the AI hub, including every tutorial in the AI-for-business series.

Sources: Etsy Fees and Payments Policy and Etsy Payments Policy (archived copies of 24 October and 2 November 2026, read 5 November 2026).