How to Keep Track of Craft Business Inventory Without Losing Your Mind
Carla Mae
September 16, 2026
If you make things to sell, you probably have at least one place where you keep track of your inventory.
Maybe it’s a spreadsheet.
Maybe it’s a notebook.
Maybe it’s a collection of sticky notes.
Or maybe your inventory system is currently:
“I think I have some of those somewhere.”
We’ve all been there.
The problem is that inventory becomes surprisingly complicated once your hobby starts turning into a business.
You aren’t just keeping track of finished products anymore. You may also have fabric, beads, paper, blanks, packaging, labels, shipping supplies, partially finished projects and materials for products you haven’t even made yet.
And when you’re preparing for a craft fair, it gets even more complicated.
The good news is that you don’t need an elaborate inventory management system to get control of it.
You need a simple system that you will actually use.
Inventory isn’t just about knowing how many products are sitting on a shelf.
It can help you answer some important business questions:
What products do I currently have available to sell?
Which products are running low?
What supplies do I need to reorder?
How much money do I have tied up in inventory?
Which products are worth making again?
What should I take to my next craft fair?
Which supplies am I buying too much of?
How much could my current finished inventory potentially generate in sales?
Without this information, it’s easy to make decisions based on memory rather than numbers.
And memory gets surprisingly unreliable when you’re surrounded by 47 different craft supplies.
Start by Separating Products From Supplies
One of the easiest ways to make inventory confusing is to put everything into one giant list.
Instead, divide your inventory into two basic categories:
Finished products
These are things that are ready to sell.
For example:
12 handmade journals
8 fabric baskets
20 greeting cards
6 painted signs
15 earrings
10 candle holders
Supplies and materials
These are things you use to make your products.
For example:
cardstock
fabric
ribbon
beads
paint
blanks
adhesive
packaging
shipping envelopes
This distinction becomes particularly useful when you’re trying to figure out how much finished inventory you have versus how much money you’ve invested in materials.
This is where inventory tracking becomes more than organization.
It can actually help with production decisions.
Imagine you have:
Product A 3 left
Product B 18 left
Product C 0 left
If Product C consistently sells quickly while Product B sits around for months, that tells you something.
You might decide to make more of C and fewer of B.
You don’t have to make that decision based on one event or one slow week. But over time, inventory and sales records can reveal patterns.
This is particularly useful for makers who tend to create whatever they feel like making next.
There’s nothing wrong with making things because they’re fun.
But when you’re running a business, it helps to know which of those fun projects are actually earning their shelf space.
You Don’t Need a Complicated Inventory System
This is where many small makers go wrong.
They discover inventory software with dozens of features and spend an afternoon setting up categories, locations, barcode systems and complicated reports.
Then they stop using it three weeks later.
Your inventory system only needs to answer the questions that matter to your business.
For many makers, that’s simply:
What is it?
How many do I have?
What did it cost me?
What does it sell for?
When do I need to make or buy more?
That’s enough to create a useful starting point.
A Simple Inventory System for Makers
If you’re starting from scratch, I’d suggest tracking these fields:
For finished products
Product name
SKU or product code
Quantity on hand
Cost per item
Selling price
Minimum stock level
Reorder or production quantity
Notes
For supplies
Supply name
SKU or product code, if useful
Quantity on hand
Cost per unit
Minimum stock level
Reorder quantity
Notes
You can keep this in a spreadsheet, notebook or inventory tool.
The important thing is consistency, not complexity.
Ideally, update finished-product inventory whenever something is:
Made → Sold → Damaged → Given away → Set aside → Moved to a market
You don’t necessarily need to count every bead and scrap of paper every time you use them.
For inexpensive supplies, you can use a simpler system.
For example:
“I have approximately half a package of these.”
Then do a proper supply count when you’re getting close to your minimum level.
The more expensive the material, the more worthwhile precise tracking becomes.
What About Inventory You Already Have?
Don’t feel like you need to spend an entire weekend counting every craft supply you’ve accumulated since 2017.
Start with your finished products.
Then identify your most important or expensive supplies.
Get those into your system first.
Once that works, gradually add the rest.
A simple inventory system that contains 80% of the information you actually need is much more useful than a perfect system you never finish setting up.
Keep Inventory and Sales Records Separate
Your inventory tells you what you have.
Your sales records tell you what happened.
You need both.
For example, your inventory might show that you currently have:
6 journals
Your sales records might show that you’ve sold:
24 journals over the last six months
That second number tells you something your current inventory can’t.
Together, they give you a much better picture of your business.
The Goal Isn’t Perfect Inventory
If you’re a one-person handmade business, you probably don’t need the same inventory system as a company with a warehouse and 15 employees.
Your goal is simply to know enough about your stock that you can make better decisions.
You want to be able to answer:
What do I have?
What is it worth?
What’s running low?
What should I make next?
What do I need to buy?
And when you’re getting ready for a craft fair:
What am I taking with me?
That’s a useful inventory system.
A Simple Inventory Tracker for Makers
If you’d rather not build an inventory spreadsheet from scratch, Crafty Marketer is developing a simple inventory tracker specifically for makers and small craft businesses.
The idea isn’t to turn your craft room into a warehouse.
It’s to give you a straightforward place to record your products and supplies, keep an eye on stock levels, and understand the value of the inventory you already have.
