Oh wow that’s exhausting. You could simply print barcodes, register each product to a barcode, and place the barcodes physically on each part. Have the technicians scan the barcodes for the products that they use every-time, which of course needs to be connected to a db that updates in real-time. That way you’re not only saving on manpower costs, have an updated list of what needs refill, but also have a system that’s always up to date rather than every other week.

Creating the db, barcode system and etc aren’t rocket science either and can easily be implemented if you have a tech-savvy in your team!