Affiliate.com’s Query Builder: Share Product Results

Affiliate.com’s Query Builder makes product discovery repeatable and reviewable. You can layer filters across more than thirty networks and over a billion products, then share the exact query and results with a single link. The shared link opens the Query Builder with your search options, selected fields, and result set already loaded.

Shared queries remove guesswork. Editors, analysts, and partners can see the same inputs, validate pricing and availability, and publish with confidence. The same pattern works in the Product Search API when you want code and editorial to stay aligned.

What a shared product result contains

A shared link preserves the logic that produced the list, not just a screenshot. That includes identity anchors like barcode or MPN, governance scopes like Network ID and Merchant ID, pricing fields such as regular price, final price, and sale discount, inventory flags like in stock and stock quantity, as well as sort, limit, and deduplication.

Why this matters

• Team members evaluate the same dataset without rewriting searches
• Editors can turn a vetted query into a Comparison Set and bind it to snippets
• Analysts can spot errors quickly because fields and operators are visible

Build a high integrity query, then share it

The workflow below uses the Walmart discount example, then a price band example. Each step mirrors best practice for identity, pricing, availability, and governance.

Step by step

1. Start broad, then narrow. Use any or name to explore, then pivot to brand or category.
2. Anchor identity. Once you know the exact item, add barcode, SKU, MPN, or ASIN to compare identical products across merchants.
3. Scope partners. Filter by network name or Network ID and merchant name or Merchant ID to stay within approvals.
4. Set market context. Fix currency to your locale. Add a price floor or ceiling.
5. Require freshness. Filter to in stock equals true and include stock quantity when scarcity matters.
6. Choose presentation. Deduplication on for a clean list of unique SKUs. Deduplication off when you want every offer for a single identifier.
7. Sort with intent. Final price for best price tables. Sale discount for deal pages. Last updated for fast changing categories.
8. Click Share. Copy the link from the top left and send it to your reviewers or save it in your editorial doc.

Two practical patterns with sharing

Curate deals at one merchant

• Filters: merchant name equals Walmart, on sale equals true, sale discount greater than thirty five, currency equals USD, in stock equals true
• Sort: sale discount descending
• Use: a merchant specific sale roundup where every item has credible savings because regular price and final price are both present
• Share: send the link to the channel owner with a note on thresholds and intended snippet layout

Build a price band for a category

• Filters: name contains vacuum stick cleaner, final price greater than three hundred, currency equals USD, in stock equals true
• Sort: final price ascending
• Use: a buying guide section for high end models
• Share: paste the link into the brief so editors can audit the list and convert it to a Comparison Set

Converting a shared query into a Comparison Set

When the team approves the selection, press Save as Comparison Set. This freezes the logic and gives you a stable object to reuse across snippets like Price Comparison, Vertical Products, or Buttons. Any later edits you make to the set can cascade to every placement that uses the same snippet.

Shared links also speed vendor or partner reviews. Instead of sending static exports, invite stakeholders to open the link and see the precise filters you used.

Field checklist for share ready queries

• Identifiers: barcode, SKU, MPN, ASIN
• Pricing: currency, regular price, final price, sale price, sale discount, ship price
• Inventory: in stock, stock quantity, availability, commissionable status
• Governance: network name and Network ID, merchant name and Merchant ID, commission URL
• Search scaffolding: any, name, description, brand, category, attributes such as color or size
• Results control: limit, sort, deduplication, last updated

QA before you press Share

• Are identifiers present so you compare the exact product across merchants
• Do results include both regular price and final price when you show savings
• Is currency correct for the audience and clearly scoped to the market
• Are merchants and networks limited to approvals using IDs
• Is deduplication set to match the chosen snippet layout
• Have you verified price and stock in the live UI since conditions change

Get started

Open the Query Builder, build a clean selection with the checklist above, click Share, and send the link to your team. Approve the list, save it as a Comparison Set, and choose the snippet layout that fits the story. With shared product results, your search logic becomes a reusable asset that raises trust and speeds production.

To learn more, check out https://www.affiliate.com/programmatic-apis.