I have lots of electronic part. Have not counted yet, but certainly many thousands. Of these parts I have many hundred unique parts. These parts are scattered around my home. Some are in the garage, some in the attic, some in my home office, and the rest in my electronics lab. It has gotten to the point that I find it difficult to known what I have and where it is.
Several weeks ago, I was up in the attic rumaging for parts when I stumbled on an old Radio Shack Cue-Cat. This was a cute barcode scanner that RS gave away free that was part of a ‘plot’ to gather consumer data. I realized that with the scanner, I could set up an inventory control system for my parts.
I went online and purchased several hundred similar sized zip-lock ESD bags. I already have a ton of Avery shipping lables. All I needed was an Excel spreadsheet to store part information, and a way to print barcodes.
The spreadsheet was a piece of cake. I set up for my ID code, barcode, manufacturer’s part number, Title, Description, Location, Quatity, Link to datasheet, and Class (opto, transistor, …). I can always add more fields later.
I then found some free barcode fonts and downloaded them. Put when I printed out one, the CueCat would not read it. I tried different codes (UPC, Code128, …) without any luck. I was about to buy a program to print barcodes when I realized that a barcode has a checksum. I had neglected to include the checksum in my printed versions. Found an Excel macro that created the checksum and I was up and running.
Now I am looking for a way to print individual labels rather than sheets of them at a time. There are plenty such printers available (think UPS address labels) but they all cost a fortune. Looking for something cheap. Any ideas?