It would really depend on your site requirements -- namely, what you want to track, how to correlate said info, etc.
You might want to check out GLPI. It covers the basics that most inventory management software does. The documentation is a bit lacking / confusing, but there're enough users out there who can help. It's pretty flexible, too, but seeing that the OP mentioned isn't a web coder, that's not as good a selling point.
On another note, I'd recommend searching SourceForge and Freshmeat for "inventory." It might just so happen that someone's written it in such a way that fits your needs. In my experience, every organization has always had something slightly different, where one works better than the other.