Sounds like you are looking for some flavor of Product Management program. There is probably one out there, but they vary.

If you track them with Excel, some small Database might do the trick if somebody had programming ability.

Originally Posted by: PackFanWithTwins 

A lot of the information we're looking to organize is already in a database, unfortunately the program to run queries is barely more user-friendly than having to run manual SQL queries - We've already developed a web-based frontend for this system for time-logging purposes but I don't think IT is going to want to devote the time needed to create a similar frontend for this purpose.

Originally Posted by: Porforis 

Platforms? I assume SQL 2005 or 8.

What types of products are we talking about... single level bills? Tiered?

Is this just a management tool or is there a need to tie it into a order processing platform?

Do you want the interface to be web driven, client based?

Or business here is a tier bill of materials for residential and commercial windows.. we use a configuration driven Q&A with the options tied to multiple choice questions.. stock verse custom. Each question will drive the bill for the related choice.

From the engineering standpoint, all parts are maintained in tables, pulled with scripting logic. But a simple query can pull back all parts and where they are used in the configurations based on product type and option.

All parts are kept in a single item master table with all purchase, stocking and costing information.

Originally Posted by: Pack93z