I suggest you use SharePoint Online as an inventory management system to manage inventory.
For classification, you could store inventory of different products in different lists. In the SharePoint Online, different product lists can have different permissions and can be shared to different users. You could also create a flow for list to notify changes in inventory. And SharePoint Online supports searching.
References:
Introduction to SharePoint and OneDrive in Microsoft 365
If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.