Are you using keyboard for data entry? Pure free form in the description field(s)? If the amount of things of varied type are as big as you have said, I fear that you'll end up with problems getting good search results. Since you may be forced to implement your system before design is finished (typical for any IT implementation where "what" comes after "when"), I would consider putting some type of standard type codes in a separate element with at least some type of high level breakdown, i.e. "tools", "hardware', "book" etc. that would help break down a search. Hopefully with AI poking its way into everything, search tools that can take a search parameter and ask "did you mean ...... or .........." in some fashion . I have a love/hate relationship with the voice input search on my old Garmin Nuvi, that does it when it misunderstands the requested item, but at least it TRIES ..
I'm having a bit of a overflow crisis in my barn, workshop and house after saying "adios" to our winter home in Zephyrhills. Two 18' enclosed trailers and two pickups full unloaded into my barn. I had duplicated lots of tools in the workshop, plus all the household goodies when you're spending several months there, now to go through the keep or not phase.. ugh, I feel your pain.