Sitecore Experience Commerce

Searching for items using the Business Tools


How to search for sellable items, orders, or customer records using the Commerce Business Tools.

The Sitecore Experience Commerce Business Tools provide a search capability to help you find sellable items, orders, customer records or other related items. This topic provides a high level description of the search feature. For detailed information about how to use the search in the context of a specific business tool, see:

Search terms and filters

The search feature in the Sitecore XC Business Tools is primarily based on an indexed term. Optionally, you can refine your search by providing a filter.

A search term is typically an alphanumeric string that corresponds to a field value relevant to the context of your search. For example, when you search for a sellable item in the sample Habitat_Master catalog (in the Merchandising dashboard), you can use any of the following sellable item properties as your search term: sellable item ID, the product name, the product ID, and so on.


The search index determines what fields you can search on.

Consider the following when providing a search term:

  • For an exact match, a search term must be a complete string (alphanumeric). For example, if searching for an item in the sample Habitat_Master catalog:

    • A search for the term camera returns all sellable items with a property value matching that complete word. A search for a partial string, for example camer instead of the complete word camera, does not return any results (this string does not match any properties of sellable items existing in the Habitat_Master catalog). You must use wildcard characters (*) for contains type search.

    • A search for the term 57042075 returns the sellable item with a matching property (for example, a matching Product ID).

  • For a partial match, you can use wildcard characters (*) as part of the search term. For example, a search for the term *amer* returns all sellable items that contain that combination of characters in on of its (indexed) properties, for example, all items with the word camera as part of the display name.

You can further refine your search results by entering a filter. The use of a filter can help narrow down the list of results returned. In general, you can use any additional keyword (a field or property value) as a filter.

The following shows an example of the search area displayed as part of Business Tools dashboards that provide search capability.


Sorting and paging results

In cases where the search presents results in a table format, you can sort results based on certain column headers. Up and down arrows (↓↑) located to the right of a column header indicates that you can sort the table content based on that field value.

The following example shows a table containing results returned by a customer search. The single up arrow located next to the Created header indicates that the table content is sorted based on the date of the customer record was created.