Building an ecommerce product database to satisfy your target consumer requires three disciplines in order to get it right: : usability, the use of filters and naming convention.
In this context to 'satisfy' is to display navigation in an intuitive manner, to use navigation techniques to compliment the buying process, and to name category titles your consumers recognise and understand.
This topic normally falls into the 'too hard' category, and is driven by legacy product database systems with little or no flexibility. If you have the time, and the infrastructure to manage the database from the perspective of the consumer experience, then work to these disciplines.
This article was as tagged as Data Driven Decision Making , SEO