Advanced Product Search

Advanced search for custom objects and products within Business Manager provides many flexible query options to help you find the information you need quickly and easily.

You can also use Salesforce B2C Commerce's Beta search feature, which must be enabled by by Commerce Cloud Support. This feature is case insensitive. There is no need for wildcard because it supports multi-word entries that are not order specific. For example, "Striped Shirt" and "Shirt Striped" are considered equivalent. If you enter shirt striped using the standard product search, no entries are found.

See Navigating Products Lists. See also Simple Product Search and Search by ID.

  1. Select site > Merchant Tools > Products and Catalogs > Products.
  2. Click Advanced.
  3. On the Advanced Product Search page, provide as much filtering information as you want, including extended attributes qualified by values.
  4. Enter standard attributes:
    • Product ID
    • Name
    • Manufacturer
  5. Product Classification: specify additional search criteria.
    Option Description
    Product type for example, Product Bundle, Variation Product, or Variation Master
    Online flag All, Yes or No
    Search status All, Searchable or Not Searchable
    Category Assignment For example, All or <kids>
    Catalog For example, Any or apparel-catalog
    Variants automatically inherit all category assignments of the master product. The result set includes variants without an explicit assignment in the catalog as long as the master product is assigned. This change alters the semantics of an advanced product search if you use the Category Assignment filter. There are more results if you filter for assigned products and fewer for the setting Unassigned if variation products exist in the catalog that are not directly assigned to categories. This behavior mimics the standard storefront browse and search functionality, where variants always inherit the assignments of the respective master.
    You can query a catalog for products not assigned or not assigned to a specific catalog.
  6. Search Term: Specify how you want the search criteria interpreted. These settings are applied for all values in the search mask.
    This setting isn't available when the B2C Commerce beta search feature is enabled.
    Option Description
    Exact phrase This is the default configuration. If you search for product "women's henley top" with search term as exact phrase, Business Manager will return nothing. Switching to case insensitive affects terms for standard and custom attribute conditions.
    Case insensitive If you search with case insensitive, Business Manager returns the product "Women's Henley Top".
  7. Extended Attributes: In the Extended Attributes section, the operator and value choices change depending on the data type of the extended attribute you select as search criteria. For example, when choosing Alarm Clock, the operator choices become equals, not equal, does not exist, and exists. When you choose equals and not equals as the operator, the choices for the value are 0 (False) and 1 (True). When you choose does not exist or exists, there are no choices for value. These are some other considerations when using extended attributes as search criteria:
    • You can search on up to five (5) extended attributes at one time.
    • You can't search on attributes of type password, HTML, text or images.
    • There is no restriction on the length of the search term.
    • You can use AND or OR for an operator.
    A complex search on a large dataset requires many resources; keep this in mind when building search criteria. This functionality is not meant for heavy use on Production instances. Try to perform complex searches on Staging instances instead.
  8. Enter any part of a string and masks into the text boxes. There are no character minimums. These drop downs let you filter the result set.
  9. Use the Operator select box to control a combination of multiple search conditions. The following settings are available:
    Option Description
    Default Conditions on the same attribute are combined using a logical OR and conditions on different attributes using logical AND. This is the standard behavior if no selection is made. Use this for queries such as "lastName = 'Doe' AND (firstName = 'John' OR firstName = 'Jane')".
    OR All configured conditions are combined using logical OR. Use this for queries such as "size = 'XXL' OR color = 'green'.
    AND All configured conditions are combined using logical AND. Use this setting for date range queries such as "birthday > '01/01' AND birthday < '02/01'.
  10. Search Result: Specify how you want the result set to appear (unsorted or sorted by any of the product attributes available; in ascending or descending order; the number of results per page).
X Privacy Update: We use cookies to make interactions with our websites and services easy and meaningful, to better understand how they are used. By continuing to use this site you are giving us your consent to do this. Privacy Policy.