Configure Advanced Product Search

Use the Advanced Product Search flexible query options to find product information.

  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 other search criteria.
    Table 1.
    Option Description
    Product type For example, Product Bundle, Variation Product, or Base Product
    Online flag All, Yes or No
    Search status All, Searchable or Not Searchable
    Category Assignment or example, All or >kids>
    Catalog For example, Any or apparel-catalog

    Variants automatically inherit all category assignments of the base product. The result set includes variants without an explicit assignment in the catalog as long as the base product is assigned. This change alters the semantics of an advanced product search if you use the Category Assignment filter. If you filter for assigned products, more results are returned. If variation products exist in the catalog that are not directly assigned to categories, fewer results are returned for the setting Unassigned. This behavior mimics the standard storefront browse and search functionality, where variants always inherit the assignments of the respective base product.

    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.
    Table 2.
    Option Description
    Exact phrase The default configuration. If you search for product "women's henley top" with search term as exact phrase, Business Manager returns nothing. Switching to case insensitive effects 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. Other considerations when using extended attributes as search criteria include:
    • 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 the resources 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.

    See Advanced Search Extended Attribute Data Types.
  8. Enter any part of a string and masks into the text boxes. There are no character minimums. These dropdowns 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:
    Table 3.
    Option Description
    Default Conditions on the same attribute are combined using a logical OR and conditions on different attributes using logical AND. This application of the logical conditions is the standard behavior if no selection is made. Use for queries such as "lastName = 'Doe' AND (firstName = 'John' OR firstName = 'Jane')".
    OR All configured conditions are combined using logical OR. Use 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 available product attribute
    • Ascending or descending order
    • 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.