---
schema_version: "1"
id: 1f6c30df2a4f161d3a13cdb2547a54d04d761dc87ac9c087c294e802f6b6d472
title: Find a Product Using Advanced Search
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/cc/264-0-0/b2c_configure_advanced_product_search.md
canonical_url: https://help.salesforce.com/s/articleView?id=cc.b2c_configure_advanced_product_search.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 122d06ae89e481483c0f7850635c0c4a0e2f5ec72d1bcb25d82a8a1f271f8cb4
description: Find products in your B2C Commerce catalog that have specific standard and custom attributes. Advanced search provides flexible, case-insensitive query options.
products:
  - Commerce
  - B2C Commerce
release: "264"
---
# Find a Product Using Advanced Search

Find products in your B2C Commerce catalog that have specific standard and custom attributes. Advanced search provides flexible, case-insensitive query options.

Because a complex search on a large dataset requires many resources, advanced search filtering isn't intended for heavy use on a production instance. Instead, perform complex searches on a staging instance. However, inventory data in a staging instance isn't always in sync with a production instance. Keep in mind that when you run a search on your staging site, the results do not always conform with the inventory in your production environment. See [Advanced Search Extended Attribute Data Types.](https://help.salesforce.com/s/articleView?id=cc.b2c_advanced_search_extended_attributes_datatypes.htm&language=en_US&type=5)

1. In Business Manager, click App Launcher ![App Launcher](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-cc-b2c_merchandiser_administrator-264-0-0-production-enus/ea76f372-6cfa-42a6-8e7c-05c6df7abed8/cc/b2c_merchandiser_administrator/images/appLauncher.png), and then select **Merchant Tools** | **Site** | **Products and Catalogs** | **Products**.
2. Click **Advanced**.
3. Enter the ID, name, or manufacturer of the product that youʼre trying to find.
4. (Optional) Under Product Classification, select values for the filters.
    
    Variants inherit the base productʼs category assignments, unless you explicitly reassign them. If you use the Category Assignment filter, filtering for assigned products yields more results, while filtering for unassigned products yields fewer results. Search for products that aren’t assigned to a specific catalog.
5. Under Search Term, select a case-sensitive option.
    
    You can’t select a case-sensitive option if you enabled the B2C Commerce beta search feature. See [Simple Search](https://help.salesforce.com/s/articleView?id=cc.b2c_simple_search.htm&language=en_US&type=5).
6. (Optional) Under Related Information, select values for the filters.
    
    Use these filters to find products that have or are missing images, prices, or inventory. These filters are disabled for catalogs with more than 2.4 million products or if the number of products in the largest catalog when multiplied by the number of stores is greater than 10 million.
7. (Optional) Under Extended Attributes, select the attribute, operator, and value for product attributes you want to search for.
    
    You can include five extended attributes of any length at a time. You can’t search for attributes of type password, HTML, text, or image. Use the Default, OR, or AND operators to specify multiple search conditions.
    
     
    | Option | Description |
    | --- | --- |
    | Default | By default, conditions on the same attribute are combined using a logical OR, and conditions on different attributes use a logical AND. The default applies if you don’t make a selection. Use Default for queries such as lastName = 'Doe' AND (firstName = 'John' OR firstName = 'Jane'). |
    | OR | All configured conditions are combined. Use for queries such as size = 'XXL' OR color = 'green'. |
    | AND | All configured conditions are combined. Use for date range queries such as birthday > '01/01' AND birthday < '02/01'. |
8. Under Search Results, specify how you want the result set to appear.
9. Click **Find**.