Can I use AND and OR filters simultaneously for diamond collections?

Store Design

Topic summary

Mixing AND/OR logic for Shopify collections to group diamonds by clarity and color. The goal: build collections like colorless AND (VVS1 OR VVS2) and colored AND (VVS1 OR VVS2), and broader clarity groups (VVS, VS, SI) using tags.

Context: Shopify collection conditions typically use “all conditions” (AND) or “any condition” (OR). The request seeks a way to combine both within one collection.

Suggested workaround (single reply):

  • In Conditions, set Product tag to “equals any of” VVS, VS, SI to include a broad clarity group (OR).
  • Add a condition where Product title “contains any of” VVS1, VVS2 to narrow to specific VVS levels.
  • Add another condition on Product tag for color category (e.g., colorless or colored) to split into separate collections.

Notes:

  • Approach relies on consistent product tags/titles (e.g., VVS, VS, SI, colorless, colored, VVS1, VVS2).
  • No code, images, or attachments involved.

Status: No confirmation from the original poster; effectiveness and full resolution remain unverified.

Summarized with AI on January 24. AI used: gpt-5.
1

Is there a way to filter in Collection type to filter with an OR operation and a AND operation? I am selling diamonds and would like a way to make a collection based on broad clarity groups VVS, VS, SI etc. instead of VVS1, VVS2, VS1, VS2, SI1, SI2 etc.

For example: I have tags for each and would like to make a collection with all VVS diamonds (VVS1, VVS2), for colorless diamonds, and a separate group of VVS diamonds for colored diamonds.

I apologize if this isn’t worded the best, I admit my frustrations may be getting the best of me.

Essentially I need to make a collection of diamonds that are colorless, and VVS1 or VVS2. And another group that are colored, and VVS1 or VVS2. I need to be able to use the all condition and the any condition in the same collection. Is there a work-around?

2

  1. Click on “Create collection” or choose an existing collection to edit.

  2. Under the “Conditions” section, select “Product tag” and set the condition to “equals any of” and enter the tags for the clarity groups you want to include (e.g., VVS, VS, SI). This will include all products tagged with any of these clarity groups.

  3. Click on “+ Add condition” to add another condition.

  4. In the new condition, select “Product title” and set the condition to “contains any of” and enter the tags for the specific VVS clarity levels you want to include (e.g., VVS1, VVS2). This will further filter the products to include only those with the specific VVS clarity levels.

  5. If you want to filter by color as well, click on “+ Add condition” again and follow the same steps as above, but select “Product tag” and enter the tags for the color category you want (e.g., colorless, colored).