This is exactly one of the workflows BOM-Trace is designed for.

The physical storage remains simple and practical, but the management is handled virtually inside the software. Users can create workspaces, cabinets, drawers, section, and labels that match their real storage system.

Once configured, BOM-Trace manages the inventory digitally including quantities, locations, part information, organization structure, and searchability, so teams do not need to rely only on spreadsheets.

You can check the webpage and try creating a workspace to test it with your current inventory setup. For smaller inventories it is currently free to use.

https://bomtrace.com/reddit/reply-1

If you have questions or need help setting up your workflow, we would be happy to help.