I am trying to organize thousands and thousands of different types of hardware. I am in the process of counting everything, but I have to figure out a way to organize it to better control inventory, we have tried organizing it by job #. Each different type of hardware has a part #, we have tried organizing it by part number. Hardware consists of screws, nuts, bolts, washers, brackets etc. you name it we got it. Can someone please throw out some ideas on a better way to organize it so we can control inventory better, I have been thinking about this for a while and cannot come up with a efficient way of organizing it that will actually work.
You can take a look at inFlow Inventory. It is a basic inventory system that has all the esstenials.They have a Free version that is free forever, but limits to 100 products and customers. The software itself is very easy to use and fast to install.Here is their website:http://www.inflowinventory.comHope this helps!
You may consider implementing a barcoding system. Checkout http://www.adcbarcodeconsulting.com for some more information..