I have a collection/channel of products, where each product belongs to multiple categories. I have two category groups:
product categories include 'shirts' and 'hats'. Example
collection categories include 'blue' and 'on sale'.
collection categories can be thought of as children of
product categories, though in the EE backend, their category groups are siblings.
I have a form that lets you input a keyword to search by, and then a tree of the
I have a pseudo-query of what I need to accomplish:
SELECT products WHERE keyword = 'foo' AND ( ( product_cat = 'shirt' AND ( collection_cat = 'blue' OR collection_cat = 'on sale' ) ) OR ( product_cat = 'hat' AND ( collection_cat = 'blue' ) ) )
I know you can search through multiple categories by sending an array of category IDs, but in this case I need to have a parent-child category relationship.
Is this possible?