Inventory - A New System Might be a Breakthrough Positive Thing for Me

Looking at my post counts, this week will be a serious milestone week for me and for my readers - my 5000th post! Yes, that's THREE zeroes! When I started this blog years ago, I would never have imagined that I would be doing this so long and meeting so many fabulous people near and far. I'm totally blessed. 

Friends - friends are the BEST thing ever, and I'm 
so very fortunate with my on-line friends. Some of 
you I've known for more than a decade now, a few 
of you close to two decades. I'm totally blessed 
with my friends. 

I've been working hard on inventory at the shop - inventory for the various boxes of product that we have out with sale prices for our customers to browse through. They are separated by size/type of bead, but there are some lovely bargains in there at 30% off the marked price. (The super expensive choices are in a separate bin, under glass, and we pull that bin out on request.) 

I made full lists of the contents of each box, put them into a spreadsheet I designed, and I'm hoping, through this new method, that we can keep a much better lock on the inventory of the boxes. I'm looking at the sheets for the "8o Hex Beads by Part Number" right now, and that one list got totally "berspukled" - (I don't think that's a real word, but it is in my world - my Mom used it sometimes - LOL). So, today's chore, after doing some inventory checks on the sheets I did yesterday, is to get this one list knocked into shape and accurate. Right now the part numbers and inventory numbers aren't correct, so I'll correct the inventory numbers - those are the ones that got messed up. The part numbers are just fine. 

My inventory lists really comprise three columns followed 
by tight columns for check marks next to each item. It's rather 
like a grid, with three organizational columns - Price Lookup 
Number, Part Number, and Price followed by a lot of 
blank grids where we put in the date the inventory was 
done and check off the beads that were present in the 
boxes. Empty boxes equals missing beads. Pretty easy and 
effective. 

But I did a solid inventory check yesterday using the sheets and it worked REALLY well, - smoothly and efficiently. I found a few duplicates which I removed, caught some missing beads that I restocked, and I think we'll be on a flat plane once I get this last sheet under control. Then, doing inventory for the boxes shouldn't take much more than an hour in the mornings. That's something I can easily do four times a week, and it will give us better control of this inventory. 

There's always one bad apple in every group, and in 
this case it was my 8o bead list where the PLU 
numbers were completely incorrect. So ... I'll be going 
through that box again today and correcting those 
numbers to the proper ones. A necessary evil, but easier 
to do with the box of beads than on the computer at this 
time. 

So that's my excitement for the day - LOL. Correcting long sheets of numbers so that they are actually in order and correct. Go CRAZY, me! LOLOL So, on that note, I'm off to the swimming pool. My trivet lady sent me a lovely email yesterday and said she's starting to feel a bit better. She credits all of us with her recovery, and I know that she's absolutely correct. The power of the people I'm in touch with through my daily blog is strong, powerful, and loving. A trifecta of positive energy flowing through the ether. Have an excellent day and I'll be back tomorrow. Slava Ukraini and חיים למען ישראל.