Germane to this topic somewhat, I've been wanting a home/personal inventory program. Ideally with the ability to create customer fields, sort of by fields/categories, unlimited photos right from smart phone, CVS import and export, android and PC version that synch..... and of course, unlimited and FREE!
Although it might not be free, you might already have a license for Access - Microsoft Office's Relational Database or Google Clouds Data Storage.
I have not done what you suggest. But as you might expect, I am not a fan of excessive organization.
I think Snipe-it was designed for IT control freaks who want to know where all their IT assets are. For this purpose, I'd prefer an application that collects free-form data and then figures out various ways to organize and present it based on open questions like: what's all in toolbox A drawer 1, or where are all my pliers, or how many pliers do I have, or list all my pliers, or what else is in with my open end wrenches, or where is my 5/16ths hex driver, etc.
I think it's ok to have a keyed database, but I shouldn't have to remember the keys to make it work for me.
It must support voice recognition. If I have to type everything in, I'll be dead before I'm done. That way I can also put tools with projects and move them to another project and still know where they are. I'm already pretty good at that but voice control would be awesome. I could even tell it where I put my glasses and actually have it remember.
I'm ok with CVS input and output, but this should only be for data entry or structured output because I prefer unstructured data.
It should also allow me to tell it I moved my large vise grips to the drawer with the monkey wrenches in it, or that I ran out of room in my screw driver drawer so I put some of my hex drivers on top of my #5 workbench temporarily.
My brain does a pretty good job of all that already, but a voice app would be better. Especially if I want to give the data to one or more of my kids.