Quote Originally Posted by tenashi View Post
So do categories have to be related linearly, as in your example: wines(products)= subset of colors = subset of regions. Is it possible to have wines=products, but with category1=regions, category2=subregions, category3=price group, etc., where each wine/product belongs to several categories of the same level? Where does v_categories_name2, etc. fit in? If all my products are wines (most are, but not all), does that mean all the wines would have to be under the same parent category (in this case, "region")?
However you wish to categorize and subcategories, ending at a product. I always think of as a tree, by drawing a flowchart from top down.