Inventory Advice Needed

I’m wondering if anyone else has this problem and has figured out a way to solve it. I have a TON of inventory. Each piece is in a zip lock bag and I have all of the Necklaces/Earrings/Bracelets separated. My problem is that when I sell something, I have to dump out and go through hundreds of bags of jewelry to find the piece that I sold! Has anyone out there figured out a better and less time consuming way to do this? I thought of filing them somehow by name but not sure what I would use to file them in. As I said, there are hundreds of items.

Thanks in advance for your feedback!

Tags: inventory organization ideas

K. Lynn Designs


9 0
Share Tweet


Donna's trinkets, LLC ...

It helps if you file them by number in a spreadsheet, and using the color idea above. The combination should work well.

Linda Foust ...

I have a lot of inventory as well. I came up with a solution that helps me find each piece very fast. I number each piece and put a tag on the bag with the Item # and price then file it numerically. I use Multi purpose labels 1.5 x 1.75". There are 1000 labels in a box. If I do a necklace, bracelet and ear rings that match I number them the same, except with an ..a.. for bracelet and …b… for ear rings. They are all filed separately in numeric order because not always does the same person buy all 3 pieces. ie; Item 1000 (necklace) 1000a (bracelet) and 1000b (ear rings). It has helped me tremendously in finding what I need. I tried all the other ways and it still was disorganized when trying to find items. This works great for me. I have them stored in the bags in a large envelope box in numerical order on a book shelf. Good luck, hope this helps

Donna's trinkets, LLC ...

Linda, would you upload a picture of your envelope box? I am trying to find a way to store my inventory and your idea sounds like it would work for me.

Madalynne Homme ...

Yes I agree this is a big problem for us all. I haven’t found anything that works all that well. I have jewelry trays and several cases that they fit into. So I just look thru the trays. By keeping my jewelry in the trays it makes it easy for me to do a last minute show. A person could # the trays or mark what stone they contain. I used to do the baggy thing and it was so time consuming for me taking jewelry in and out of baggies. So I bit the dust and bought storage trays and the cases. And a FYI, don’t by the big metal cases with wheels on it. Although it’s nice for storage of jewelry, if you plan on doing a show, they are too heavy and they have to stand up right! UGH!

Linda Foust ...

Will upload pics of my idea this evening. I will tag you when it is done Donna. I also do a time sheet for each piece so I know what I have in it and what I am selling it for so as I sell I can look up the item # and enter all the information into my sales sheet as well. Will try to send pics of that as well

Beaded Bliss ...

I have brown tags that help hang the jewelry. I also have tiny white jewelry tags that I put my “skew #” and I staple it to the back. When I sell a piece i take that tag and put it in a container til I get home. This way I can match what I’ve sold to my inventory list and know how much to write up for that show for tax purposes.

Cheryl Lojewski ...

It’s interesting hearing how other people handle their inventory. Always looking for better ideas! Here is what I use. For keeping a record of my supplies I use a software called BeadManager Pro. It keeps a record of your supplies and it can be used to price your pieces and can also be used to keep a record of what you have in inventory. It is a little extra work in the beginning, but I have found it to be very useful for me. Plus, I’m a bit of a geek, so I like keeping the info on the computer.

I created a separate spreadsheet to use to keep a record of what inventory I have and what has sold. I also use the spreadsheet to figure our taxes, credit card charges and costs. It makes reporting our quarterly gross receipts and yearly taxes so much easier.

I, too, mark each piece with a stock number and log it when it sells. As for organizing my inventory, I haven’t come up with a very good system for that yet. I try to separate by type, earrings, necklaces, bracelets, etc., and divide them into different containers. The necklaces are kept in individual plastic bags which does make it easier to keep them straight. I like how Linda divides hers in the boxes. I think I’ll give that a try. Happy beading!!

K. Lynn Designs ...

Thank you for all of the feedback ladies! It gave me some things to think about.

Donna's trinkets, LLC ...

It did the same for me! Thanks.