Currently, we have information about our products in a variety of places.
ERP, Various Databases, etc. Generally we're using SQL Server to store most of the database.
We want to create a centralized place where we can store all the information related to our products and start replacing these disjoint databases (with the exception of the ERP).
What are some good software packages that will handle thousands of products, have a HTML interface and perhaps a Win32 client as well. Be able to handle Web Friendly Data, internal only data and be customizable. (If I want to add a product features section, I do that... if I want to set the attributes to be in a specific order when displayed I'd like to be able to order them).
Our ERP has some information, but it's not normalized data, it's not standardized and won't hold everything about the product.
Are there any good software packages that will maintain a database of products that we can hook into ( for product information, reporting, showing on the web etc. ) or do I have to roll my own?
The problem isn't in rolling the database, it's all about the interface and the ability to add attributes to products, add different things in different languages etc.
Any ideas?