This would be an Admin/mysql database...
the admin would allow me to add categories, subcategories and products to an application (swf)
When I add the products, I could include a tittle, description, size availability, color availability.
In the app...
When a user selects a category, there would be a drop down menu that shows the sub categoies and within those the products.
The products would show up in a small scrolling window as thumbnails and the name and item number under the thumbnail.
When the user selects one of thoses products, the product would appear in a window to the right along with the descriptions. When you choose the color availability (small color squares), a window would pop up and show that product in that color.
That's about it :o)