Etsy Inventory Management — A Complete Guide for Handmade Sellers
Everything Etsy sellers need to know about tracking materials, finished products, and orders — and when to move beyond spreadsheets.
You opened an Etsy shop because you love making things. The inventory part? That was an afterthought. A quick spreadsheet here, a sticky note there, a mental tally of how many jars of shea butter you have left.
And for a while, it works. But then orders start coming in faster. You add a few more products. A customer buys the last of something you didn’t realise was almost sold out. You spend two hours on a Sunday recreating last month’s material purchases because your tax preparer needs numbers.
That’s when most Etsy sellers go looking for a better way.
This guide covers everything you need to know about Etsy inventory management — what to track, how to set it up, when spreadsheets stop working, and what to do instead.
Why inventory management matters more for handmade sellers
Most inventory advice online is written for retailers who buy finished products and resell them. That’s not you.
If you make what you sell, you’re not just a retailer — you’re a manufacturer. That changes everything about how inventory works.
You have two layers to track: the raw materials that go into your products, and the finished products themselves. A retailer only has one layer. So when an Etsy seller says “I lost track of inventory,” they often mean they lost track of both layers at once — and the ripple effect hits faster and harder.
Here’s what poor inventory management actually costs handmade sellers:
Stockouts that hurt your shop ranking. Etsy’s search algorithm factors in your shop’s reliability. Running out of stock, cancelling orders, or having long dispatch times all drag your ranking down. A well-stocked shop with fast fulfilment consistently outranks one that goes dark every time materials run low.
Underselling because you don’t know what you can make. If you’re not tracking materials, you might have the capacity to produce 50 units — but list only 5 because you’re not sure. That’s lost revenue sitting on your shelf.
Pricing that doesn’t cover your costs. You can’t price accurately if you don’t know what goes into each product. Materials, your time, packaging, platform fees — all of it needs to land in your price. Most makers who track their costs properly end up realising they were undercharging. Some by a lot.
Tax time turning into a crisis. When you file your taxes, you need your cost of goods sold (COGS). Without good records, you’re either leaving deductions on the table or spending days reconstructing data from memory and old receipts.
The three things every Etsy seller needs to track
Good Etsy inventory management comes down to tracking three things. Get these right and everything else follows.
1. Your raw materials
Raw materials are what you buy to make your products. Thread, resin, wax, fragrance oil, beads, packaging, labels — anything that ends up in or on your finished product.
For each material, you want to know:
- How much you currently have on hand (quantity and unit of measurement)
- What you paid for it, per unit
- Your reorder point — the quantity that triggers a new purchase order
- Which products it goes into
That last one is the key. Once you know which materials go into which products, you can work out your cost per unit automatically. And when a material’s stock drops, you know immediately which products are affected.
2. Your finished products (and how to make them)
A finished product record tells you what you made, how many you have on hand, and what it costs you to produce one.
The “how to make it” part is what’s often called a recipe or bill of materials (BOM). It lists every material that goes into the product, the quantity used, and your labour time. Once that recipe exists, your software can calculate cost per unit automatically — and update it whenever your material prices change.
This is where handmade inventory gets interesting. A candle that takes 150g of wax, 5ml of fragrance, one wick, and 15 minutes of labour has a very specific cost. When your fragrance supplier raises prices, your cost per candle goes up. If you’re not tracking this, you won’t know until your margins quietly disappear.
3. Your orders and sales
Order tracking ties the other two together. Every sale should automatically reduce your finished product stock. And if you’re tracking at the manufacturing level, it should eventually reduce your raw material stock too.
The practical goal: after every order, your inventory numbers should still be accurate without you touching a spreadsheet.
Spreadsheet vs. software — when each one works
Not everyone needs inventory software from day one. Spreadsheets are a perfectly reasonable starting point — the question is knowing when you’ve outgrown them.
A spreadsheet works well when:
- You have fewer than 10 products
- Each product has a simple, stable material list
- You sell on one channel only
- You have time to update it manually after every order and material purchase
- You don’t need COGS reports or detailed financial tracking
Most solo makers starting on Etsy fall into this category. A well-built Google Sheets template with a material list, a product list, and a manual order log will do the job. We’ve written a guide to the best Etsy inventory spreadsheets if you want to start there.
A spreadsheet starts breaking down when:
- You have 20+ products or complex recipes
- You sell on more than one channel (Etsy + Shopify, say)
- You need accurate COGS for tax time and can’t face reconstructing it manually
- You’re buying materials regularly and want to see true cost changes reflected in product costs
- You’re spending more than an hour a week just updating the spreadsheet
That’s the point where most makers look at dedicated software. The time cost of manual tracking starts to exceed the subscription fee pretty quickly.
How to set up an Etsy inventory system (step by step)
Whether you’re starting with a spreadsheet or moving to software, the setup process is the same. Build it in this order.
Step 1: List every material you use
Start with a complete materials list. Include:
- Material name
- Supplier
- Current price per unit
- Unit of measurement (grams, ml, yards, each)
- Current stock quantity
Don’t worry about being perfect here. A rough count is better than no count. You can refine quantities later.
Step 2: Create a recipe for each product
For every product you sell, document:
- Each material it uses
- The quantity per unit (e.g., 150g wax, 5ml fragrance)
- Labour time (how many minutes does one unit take to make?)
If you sell variations (different scents, sizes, colours), create separate recipes for each or use a base recipe with variation notes. This is tedious to set up once but saves hours every month once it’s done.
Step 3: Record your current finished goods stock
Do a physical count. How many of each finished product do you currently have on hand? Enter those numbers.
If you batch produce — making 20 of something at once — note that too. This matters when you’re tracking manufacture runs.
Step 4: Set reorder points for your materials
A reorder point is the stock level that triggers a new purchase order. It accounts for how long your supplier takes to deliver and how quickly you use the material.
A simple formula: (daily usage × supplier lead time) + safety stock
For example, if you use 100g of shea butter a day, your supplier takes 5 days, and you want a 2-day buffer, your reorder point is (100 × 5) + 200 = 700g. When your stock hits 700g, order more.
This sounds elaborate, but once it’s set, you never have to think about it again. You just get a warning before you run out. Check our reorder point formula guide for the full calculation.
Step 5: Connect your Etsy store
If you’re using inventory software, connect it to your Etsy shop. Orders should flow in automatically and update your product stock without manual entry.
This is the part where you get time back. Instead of logging every order by hand, you check your inventory at the start of the day and your numbers are already current.
Step 6: Track your manufacturing runs
When you batch produce, record it. “I made 30 lavender candles using 4.5kg of wax and 150ml of fragrance” should become a manufacturing record that reduces your material stock by those amounts and increases your finished product stock by 30.
Most makers skip this step — and then wonder why their material quantities drift out of alignment. The manufacture record is the bridge between your raw materials and your finished goods. Without it, you’re always guessing at one or the other.
Syncing inventory when you sell on multiple channels
If Etsy is your only channel, this section isn’t urgent. But the moment you add a second channel — Shopify, your own website, wholesale buyers, or even a market stall — inventory syncing becomes one of your most important problems.
The core issue: every channel has its own stock counts. When someone buys a candle on Etsy, your Shopify stock doesn’t automatically update. Now you’ve got two sources of truth — and they’ll diverge the moment you get a busy weekend.
There are a few ways to handle this:
Option 1: Separate inventory pools per channel. You allocate specific quantities to each channel and track them independently. Simple, but manual — and you have to re-allocate stock constantly.
Option 2: Centralised inventory with integrations. One inventory system syncs across all channels. When something sells on Etsy, the central count drops, and Shopify reflects the new number. This is the approach that scales.
Craftybase does this by importing orders from both Etsy and Shopify, tracking your unified material and product inventory in one place, and giving you a single view of what you have across all channels. It won’t update Etsy or Shopify listing quantities in real time (that’s what dedicated stock-push tools do) — but it gives you the authoritative source of truth for your actual manufacturing inventory.
We’ve covered the full picture in our guide to managing inventory across Etsy and Shopify and our post on syncing Etsy and Shopify inventory. And if you’re still deciding whether a second channel is right for you, read our piece on when to add a second sales channel.
Common Etsy inventory mistakes (and how to avoid them)
These come up again and again. Most of them are predictable — which means they’re avoidable.
Tracking finished goods but ignoring materials. This is the most common one. You know how many candles you have in stock, but you have no idea if you have enough wax to make more. You find out when you’re mid-batch. Tracking both layers prevents this.
Not recording manufacturing runs. You buy materials, make products, and sell them — but you never record the manufacturing step. Your material counts slowly drift into fiction. Your product counts only drop when you manually adjust them. Everything gradually becomes an estimate.
Listing more than you can fulfil. Without knowing what you have on hand, some sellers list optimistically. Then they get orders they can’t fill. Cancellations hurt your Etsy standing, and that hit lasts.
Treating inventory as a once-a-year task. Tax time rolls around and suddenly you need to reconstruct 12 months of material purchases and COGS. That’s a miserable way to spend a weekend. Tracking month by month makes year-end trivially easy. If this one resonates, our Etsy COGS tracking guide is worth reading before your next tax period.
Copying competitor prices without knowing your costs. “My competitors charge $18 so I’ll charge $18” is only a valid strategy if you know your costs are lower than theirs. Most makers who finally calculate their actual COGS discover they’ve been either underpricing or — occasionally — that they’ve been fine all along. Either way, knowing the number is better than guessing.
Holding out until you “need” a system. The spreadsheet breaking point is real, but by the time you hit it, you’ve already got months of messy data to clean up. Starting with even a basic system early is much easier than retrofitting one onto a running business.
When to move from spreadsheets to software
There’s no exact threshold — but here are the signs you’ve crossed it:
- You’re spending more than 30 minutes a week updating your inventory manually
- You’ve had a stockout that hurt your shop ranking or led to a cancellation
- You can’t tell a customer accurately how long their order will take to ship
- You needed to calculate COGS for tax time and it took more than a day
- You added (or are thinking about adding) a second sales channel
- You batch produce and you’ve lost track of which batch used which materials
If two or more of those apply, you’re past the spreadsheet stage. You need something that tracks materials, finished goods, manufacturing runs, and orders in one place — and automatically pulls orders from your Etsy shop.
Craftybase connects directly to Etsy, imports your orders automatically, and tracks inventory at the manufacturing level — materials, recipes, production runs, and finished goods. You get real-time COGS, Schedule C-ready reports, and reorder alerts without the manual work. There’s a 14-day free trial, no credit card required.
Frequently Asked Questions
What is Etsy inventory management?
Etsy inventory management is the process of tracking your raw materials, finished products, and orders so you always know what you have on hand, what it costs to make, and when to reorder supplies. For handmade sellers, this means tracking two layers — the materials that go into products and the products themselves — rather than the single layer a retail reseller would track.
How much inventory should I start with on Etsy?
A common starting point is 10–20 units of each product — enough to show steady stock without tying up too much cash. More important than the quantity is having enough materials on hand to restock quickly. If your production time is under a week, you can start lean and produce as orders come in. See our full guide on how much inventory to start with on Etsy for a more detailed breakdown by product type.
Does Etsy have built-in inventory management?
Etsy lets you set a quantity per listing that counts down as orders come in and marks the listing as sold out when it hits zero. That's useful, but it only tracks finished product quantities — not raw materials, recipes, or COGS. For handmade sellers who need to track what goes into each product, calculate true costs, and manage reorder points, Etsy's built-in tools aren't enough on their own.
What's the best inventory management software for Etsy sellers?
The best option depends on your business stage. Spreadsheets work well when you're starting out and have a small, simple product range. Once you're managing 20+ products, batch producing, or selling on multiple channels, dedicated software built for makers — like Craftybase — handles the manufacturing layer that retail-focused tools miss: raw materials, recipes, production runs, and automatic COGS calculation with Etsy order sync.
How do I track COGS for my Etsy shop?
COGS for Etsy sellers equals your opening inventory + materials purchased − closing inventory. To calculate it accurately, you need records of every material purchase, how much went into each product, and how many products you sold. In practice, most makers track this with a spreadsheet or inventory software that builds COGS automatically as orders come in. Our Etsy COGS tracking guide walks through both approaches in detail.
Can Craftybase sync inventory between Etsy and Shopify?
Craftybase imports orders from both Etsy and Shopify and tracks your manufacturing inventory in one place — materials, recipes, production runs, and finished goods. It acts as your central source of truth for what you have and what it costs. For real-time listing quantity sync between Etsy and Shopify, you'd pair it with a stock-push integration. See our guide on managing inventory across Etsy and Shopify for the full picture.
If you’re still figuring out how much stock to start with before you open or restock your Etsy shop, our guide on how much inventory to start on Etsy covers it in detail.
And when you’re ready to move past the spreadsheet, Craftybase is built for exactly this. Connects to Etsy, tracks your materials and recipes, calculates your COGS automatically, and gives you the numbers you need at tax time without a weekend of reconstruction. Try it free for 14 days — no credit card needed.
