I thought I’d share with you my inventory system.
For years I just put all the jewelry I made into little bags and popped them in a drawer until I sold them.
This worked well until I started to drown in finished jewelry pieces and found myself becoming more and more fraught with anxiety each time I sold something and couldn’t immediately put my hands on it.
It didn’t help that I wasn’t always good at following the drawer rule either.
Sometimes I’d find the pieces in other places.
Just laying around.
I’ve always worked, (and lived really), in a chaotic mess which has never really bothered me except that sometimes the idea of running a business just really brings out the nerd in me.
I mean I love Office Depot for instance.
All those organizing things under one roof.
It’s just unfortunate that Ms Chaos runs rings around Order every time I decide to sort myself out..
But now I have the perfect system.
For me anyway.
Prepare to get your nerd on…
… and your baggies out.
And the sticky labels…
This is only for those of us who don’t know what the hell they’re doing.
For all you other people who already know what you’re doing this will probably have you either in stitches or you’ll lose your eyeballs in the back of your head.
You have been warned…
I break down all of my items into codes as such.
Necklaces with Cabochons = NC
Necklace without Cabochons = NS because they’re typically just made with silver.
And so on.
Earrings = EC and ES
Bracelets = BC and BS
Rings = RC and RS
Then I add their numbers after this code and stick it onto individual appropriate sized bags.
I then use a larger bag to hold up to ten pieces of jewelry.
This bag gets its own label.
NC1 – 10
NC11 – 20
NC21 – 30
Into which I put the corresponding items.
The good thing about this is that I can then store them in bag order in the drawer and so when I sell item NC26, for instance, I can put my hands on it straight away.
To encourage me to remember to do all of this I have a set of numbered bags ready and waiting in a little box on my work table.
When I finish a piece I put it straight in its pre-labeled bag, then I just take the box inside and list the pieces that are in it.
It may sound simple.
You may already do this.
You may have a better system.
But to me, this is heaven on a sticky label.
Here are the cabochons waiting for their turn.
I then have a simple spread sheet that I made on my computer which has this code number on it, where I have it listed, i.e., Etsy or my Website, the item name, how much it is, and finally a box in which I can mark off when and also where I sold it.
i.e. √E = Etsy
√F = Facebook
√I = Instagram
This one is for the earrings.
Don’t ask me what the P is for…
Just goes to show. You can take a horse to water….
Maybe it’s a private sale?
We may never know…
So there you have it.
Of course you have to follow through with all the putting things in baggies and remembering to put the code in the item’s title when you list it on Etsy, etc., although I noticed that now Etsy has a new box for putting in your SKU number when you list something so that should make life easier.
O.K. so don’t laugh that it’s taken me this long to figure things out.
I didn’t know I was going to make so much stuff.
Not my fault…
Of course I don’t have any system whatsoever for keeping track of materials etc.
I suppose I’ll be saving that little project for another decade.