I think a good way to solve this issue will be to use a "YMM" like filter
The idea of the YMM is to allow your users to filter and search through your inventory using key fields. In this case it will be an Inventory Location.
So on the homepage or where ever the user starts their journey on your store. You can have a similar filter with maybe [Inventory Location | Availability | Price]. So these fields will have a narrow down option that will allow the users to only be able to see products that match these options they have inputted.
This is usually what wholesale clients with large inventory use. I'm happy to discuss this further with you. If this seems useful to what you're trying to do.