I just install an inventory management app on our team website and it seems like a good way to keep track of parts we have in stock. It seems great but lets see if the team will actually follow through and use it during the stress of build season. haha
It use php and MyPHPAdmin and is really easy to install.
Check it out
http://www.inventory-management.org/