I have a problem with filtering by multiple attributes at a time using the Layered Nav widgets.
My site uses three attributes:
- Clothing type
I have setup 3 instances of the Layered Nav widget in the sidebar to allow customers to find what they want. For all 3 I am using the query type of "OR", so that if a customer enables the Blue and Green and Red filter options, they can see any product that is either Blue OR Green OR Red. Similarly for Brand and clothing type.
Where I get stuck is that these widgets don't seem to have an option to specify AND or OR between attributes. I would expect the following logic when I use a clothing filter on a website:
Color: green OR blue
Brand: Nike OR Adidas
Type: Accessories OR Tops OR Bottoms
but instead everything is just one long OR query so a piece of clothing could be blue OR an accessory OR nike OR green OR adidas.
The result is that customers get lots of products they don't want to see i.e. a Puma product shows up because it's Blue, even if the brand filter only wants Nike or Adidas.
Is there any way to chain queries together so that WITHIN an attribute we use OR, but across attributes we use AND? I imagine the SQL query for this wouldn't be too complex, I'm just hoping there's an extension that would handle this for me.
Thanks in advance!