> ## Content Index
> Fetch the complete content index at: https://blog.affiliate.com/llms.txt
> Use this file to discover other available public pages before exploring further.

# Perform "Or" Searches for product comparison sets
- URL: https://blog.affiliate.com/perform-or-searches-for-product-comparison-sets/
- Published: 2025-11-11T12:25:00.000Z
- Updated: 2025-11-21T23:39:27.000Z
- Author: Casey Caroselli

Perform "Or" searches for product comparison sets when you want breadth without sacrificing integrity. In Affiliate dot com, you can add multiple values to the same field with an Or operator, then layer normal And filters for price, discount, currency, stock, network, and merchant governance. The result is one query that populates clean comparison sets you can share and reuse.

An Or search combines peers inside a single field, for example multiple merchants, currencies, or brands. You still barcode match for identity, deduplicate for presentation, and keep currency scoped to your market for fair pricing. Below, we map the feature to practical workflows and the screenshots in this article.

0:00 

/0:05 

1× 

## How Or works in the Query Builder

Click the plus sign next to a field to add another value. The field will evaluate as value A Or value B while the rest of your filters continue to apply with And logic. This is the fastest way to stage a comparison set that spans more than one brand, merchant, or currency without creating multiple queries.

![](https://storage.ghost.io/c/22/24/222415b9-00f9-4f91-b2be-0ff3f96900ef/content/images/2024/11/Screenshot-2024-11-17-at-9.41.53-PM.png)

### Typical fields that support Or

- **Merchant Name or Merchant ID:** include Macy’s Or Nordstrom Rack in a single result set
- **Currency:** search in USD Or EUR Or AUD when auditing global availability
- **Brand or Category:** test two editorial angles without rebuilding the entire query
- **Network Name or Network ID:** pull from several approved networks at once

![](https://storage.ghost.io/c/22/24/222415b9-00f9-4f91-b2be-0ff3f96900ef/content/images/2024/11/Screenshot-2024-11-20-at-7.55.39-AM.png)

## Include multiple merchants in one comparison

Use this when you are building a price table for a seasonal hero product and want to show offers from more than one partner.

**Steps**

1. Start broad with **name** or **any**, for example winter jacket.
2. Add **currency** equals USD, and set **in stock** equals true.
3. In **merchant**, click plus to add Macy’s and Nordstrom Rack, which creates an Or within the merchant field.
4. Anchor to **barcode** or **MPN** once you have found the exact model to avoid lookalikes.
5. Toggle **deduplication off** to display every offer for the same identifier, then sort by **final price**.

**Why it works**  
Identity comes from identifiers, not the merchant title. Or simply expands the partner set while your integrity rules remain strict.

For more information, visit [https://www.affiliate.com/api](https://www.affiliate.com/api?ref=blog.affiliate.com).