Pricing a handmade product by "materials times two" leaves out most of what it really costs to sell it: your time, packaging, shipping you absorb, and the fees charged on every sale. This guide shows a spreadsheet method for pricing Etsy listings so each sale actually pays you, and how to keep it accurate as fees and costs change.
Important: Etsy sets and updates its own fees. This article deliberately doesn't list fee amounts. Always check Etsy's official Fees & Payments Policy for the current figures in your country before you price. Every number below is a made-up illustration.
Why materials-only pricing loses money
Materials are often the smallest part of a product's real cost. Once you add the hours you spend making, photographing, listing, packing and answering messages, plus the platform's fees, a price that "feels right" can leave little or nothing.
Step 1: Build the true cost of one unit
For each product, list:
- Materials: the cost per unit, including the waste you can't use
- Labor: time to make one unit × the hourly rate you want to pay yourself
- Packaging: box, mailer, tissue, stickers, inserts
- Shipping you cover: if you offer free shipping, it's a cost
- Overhead share: tools, software, photography gear and studio costs, spread across the units you expect to sell
Illustration: materials $4, 30 minutes of labor at $20/hour ($10), packaging $1.50 and overhead $1 = $16.50 cost before fees and profit.
Step 2: Account for fees as a percentage of price
Marketplace fees typically include a mix of per-listing charges, percentage-based transaction fees and payment processing fees, and sometimes advertising fees on certain orders. Because some fees are a percentage of the sale price, you can't just add them to cost. You have to price so that what's left after fees covers cost plus profit.
The spreadsheet approach:
- Look up the current fees on Etsy's fee page and enter them in your sheet as editable inputs, one cell each.
- Add up the percentage-based fees into one "total fee %".
- Add up the fixed per-order fees into one "fixed fees" amount.
- Price = (cost + target profit + fixed fees) ÷ (1 − total fee %).
Illustration (made-up fee inputs): if your sheet held a combined 10% in percentage fees and $0.50 in fixed fees, with a $16.50 cost and a $6 profit target: ($16.50 + $6 + $0.50) ÷ 0.90 = about $25.56. Your real result depends on Etsy's current fees and your own costs.
Keep the fee cells separate and labeled with the date you checked them. When Etsy updates its fees, you change one cell and every price updates.
Step 3: Price for every channel you sell in
If you also sell at craft fairs, on your own site or wholesale, each channel has different costs: booth fees, other payment processors, wholesale discounts. Wholesale in particular needs a retail price high enough that a shop can buy from you at a discount and still mark it up. Build one row per channel, so you can see whether each channel is worth your time.
Step 4: Track profit after the sale
A pricing calculator tells you what should happen. A profit tracker tells you what did. Log each sale with its actual fees (from your Etsy payment account), shipping and any discount. Over time you'll see which products and channels really earn money, and which only feel busy.
Common pricing mistakes
- Paying yourself $0 an hour "for now"
- Forgetting fees on shipping charges, if the platform charges them
- Running sales and discounts without checking the margin left afterward
- Never re-checking fees after a policy update
Pricing variations, bundles and custom orders
Products with sizes, colors or personalization often have different costs per variation. Give each variation its own cost row instead of averaging. A larger size or a personalized item usually takes more material and time, and averaging hides which versions earn the least.
Bundles (for example, a set of three) can raise the order value, but run the bundle through the same formula: combined cost, plus profit, plus fees. A bundle discount should come out of your profit on purpose, not by accident.
Custom orders deserve a minimum price and a clear note of how much back-and-forth is included. Custom work often hides extra time in messages and revisions, so track that time for a few orders and build it into your custom pricing.
Discounts and sales: check the margin first
Before running a sale, put the discounted price through your calculator. Because some fees are a percentage of the price, a discount lowers the fees a little but cuts your profit by much more. Decide the lowest price you'll accept for each product ahead of time, and don't go below it during promotions.
Plan the launch, not just the price
Good pricing works best alongside a steady plan for listing, photographing and promoting. A dated launch checklist and a posting calendar keep you consistent in the first months, when it's easiest to stall.
Templates for Etsy sellers
- Pricing Calculator & Profit Tracker for Etsy Sellers: true unit cost, prices for each channel, and sale-by-sale profit tracking, with fee inputs you update yourself.
- Shop Launch Checklist & 90-Day Marketing Calendar: plan the weeks before launch and keep posting for the first 90 days.
- Pricing, Shop Launch & Media Kit Template Bundle: pricing, the launch plan, and a media kit and rate card for creators working with brands.
FAQ
Where do I find Etsy's current fees?
On Etsy's Fees & Payments Policy. Fees can vary by country and can change, so check before you set or update prices.
Should I offer free shipping?
If you do, build the shipping cost into the item price and run it through the same fee math.
How often should I review prices?
Whenever fees, material costs or your production time change, and at least a few times a year.
Ready for your own storefront?
Many sellers eventually want a site of their own alongside a marketplace shop. See website design from The Collective.