using both AND (all conditions) and OR (any condition) in the building of collections

using both AND (all conditions) and OR (any condition) in the building of collections

miXmiX
Visitor
2 0 7

Hi, I'll keep this simple. This is not a newby question instead it appears to be a glaring omission in shopify but there must be a workaround.

 

How would I build this collection in shopify (preferably the optimal way). Please note the use of brackets.

 

tag = Sale AND product type = coats OR product type = puffers OR product type = jackets )

 

Note this is definitely not the same as the following which seems to be all that is available in collections :

 

tag = Sale OR product type = coats OR product type = puffers OR product type = jackets

 

Thank you,

Neil

Replies 4 (4)

EcomSol
Excursionist
20 3 5

In Shopify, you can build collections based on conditions such as product tags and product types. Unfortunately, the platform does not support logical AND and OR operators within a single condition.

However, there is a workaround to achieve the desired collection:

Create three separate collections, each with a different product type (coats, puffers, jackets).
In each of these collections, add a condition that filters only the products with the "Sale" tag.
Finally, create a fourth collection that includes all three of the above collections. This will effectively combine the products that match the conditions you specified.
You can also use a custom product tag for all of your sale items and add a condition to each of the collections to only include products with that tag.

I hope this helps! Let me know if you have any further questions.

I hope this helps! Let me know if you have any further questions.
Best Regards!
Ecom Solutions
miXmiX
Visitor
2 0 7

Thanks you for taking the time to reply!

 

You said: "Finally, create a fourth collection that includes all three of the above collections."

 

but there is no way to create a collection from other collections in shopify ??

Kelly222
Visitor
1 0 2

Hi, I am really keen to understand how to build a collection from other collections as this is the exact problem I am trying to solve at the moment. Have you found a way of doing this please?

pddyohara
Shopify Partner
1 0 1

Fantasy response - can't create collections from other collections - time waster.