So this is something I wished I thought of doing earlier, but didn't think of it until recently. Hopefully, it will give someone else some inspiration.
I used to keep track of my inventory in a spreadsheet, but I never really kept track of how much I used. It was more of a purchasing list. I decided to go with a new tool to do that job for me. There are a bunch of options out there that may do a better job. But this method is free and I also decided that if I got a scanner, it would make the check in/out process much easier. So I would be more inclined to keep track.
I went with PartKeepr for inventory management. There was a little bit of a learning curve to get used to it and there are a couple issues with it. So I decided to build a tool to help improve my experience with it. The tool was built off of Python and then I wrote a little REST API to interface with the PartKeepr SQL database.
Here's the fun part! It's no fun entering all the parts my hand and all the parameters, so I made a little data miner that searches mouser.com for the parts (using their API initially). And then it takes it a step further and parses the loaded web page for the table of parameters that each part has (package, voltage rating, bandwidth, size, etc...) and adds it to the PK database. Turns out mouser.com actively searches for robots, so this became a bit of a challenge to get around. It also downloads the image of the part and adds it to the database as well (semi-automatic for now). The whole process isn't 100 automatic because there's a captcha you need to get by.
So all you do is enter the part number (or scan) and the tool will:
1. Search the database to see if it exists
2. Adds it if it doesn't
3. Create an internal part number
4. Mine mouser.com for parameters
5. Generate a QR code based on the internal part number
6. Assigns that QR Code to the part
7. Saves the part number to a spreadsheet so I can import it into my label maker to print out
And with my tool, for each item I scan I can add or subtract inventory without effort. Hopefully this will keep me on track! The scanner I have has a memory mode, so I can do inventory later or right away in instant upload mode.
Here's an example video of the scanner with my PK database
https://youtu.be/Rx2d9_IW5QUWould like to hear what else you guys do to keep track of inventory so I can get some ideas. This isn't quite ideal, but its a step in the right direction and at least its all free.