Hi There
I have 3 categories of products. Commercial, Charter and Leisure.
I have created Product categories for the type of product. ie my categories look like below:
-Commercial
-Charter
-Leisure
-Product type
--- Lifejacket
Adult Lifejacket
Product1
Product2
Child lifejacket
Product3
Product4
From the above you can see that my products are all generic when I create them. (ie root category is just 'Product type').
I then decide what customer type the product would interest. Some lifejacket would be suitable only for Commercial, some for Leisure, some suit both commercial and leisure etc. So I can assign the category(ies) that the product also belongs to. So now it is a 'Product type' of 'Commercial'. Very cool.
My question is:
I can display all my products with a simple module on screen, looks good, but this is ALL products. I would like to simply say display all 'Product type' where 'Commercial' is true and so the cateogry listing displayed just picks only the commercial. Same for Leisure and Charter of course.
I presume it is some query somewhere, but not sure where