new "repair cafe" type setup

[jerrys987]

Hello,
I work with a NGO museum of older technical and electric parts. Think of things before 1960. Radios, bicycles, toasters, and everything else that showed some form on innovative/interesting design. You can look at the collection on moah.org. I have to imagine we are not the only repair cafe that needs things like this. [If there are folks in the SF bay area, I am happy to give tours of the warehouse, lots of cool and crazy things to see.]
We get new donations, and they often need physical or operational restoration. We have parts from resistors to springs and a odd mix of new and old tools. We are looking for something that people can search to locate something like a 1/4 inch fine thread bolt. So there are no BOMs and the bin is 1-9 ohm resistors rather than a 2.5 ohm 1/4 watts resistor.

Inventree is the closest thing I could find to what we want.
Things that fit the bill right now:

• hierarchical storage: like a bin in a bin grid on a shelf in a case on a wall (that's not a made up example, most of our electrical and small mechanical components would have that exact pattern.
• The ability to add a picture of the bin contents: we have 5 drawers on 1/4"x20tpi bolts, being able to look at the pictures would make finding things much faster

Two things that would be great:

• being able to track the restoration/repair jobs we are doing and what supplies they used
• searching on locations content ranges, so if I ask for a 2 ohm resistor, it points me to the 1-9 ohm bin. In particular, we replace a lot of aged capacitors, and they usually don't need to be exact to get things working. It helps having Silicon Valley EEs to figure those things out.

I am computer literate and write acceptable but not wonderful python. I am not above writing code, but would want lots of guidance to get things that the team would be happy with.
My first steps are to set it up on a local machine in our warehouse, that's easy for me, sounds like I would be best off pulling from github, probably starting with the latest release.

The first thing I would like advice on is how to set up the location naming scheme to cover the general location through bin hierarchy.
thanks for any help,
jerry

[matmair]

Sounds like a cool purpose. I do not think core InvenTree is really ready for this but would be interested to hear if you can make it fit.

[SergeoLacruz]

our naming scheme is simple. room/shelf/level/box. All entries are numbers e.g. 427/3/4/2. That's basically it. The location path might be longer if there are drawers in the shelf with boxes inside. But the system remains the same.
A parameter range search is a good idea. I think it is around for some time already.