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 Commerce items such as sellable items, promotions, price books, orders, customer records. This topic provides a high level description of the search feature.

The search feature in the Sitecore XC Business Tools is primarily based on an indexed term.

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.

Example of the search area in the Commerce Business Tools.

To filter results when using Solr, ensure you follow Solr syntax. The following list provides common search query examples for Solr when searching by date:

  • orderplaceddate:[NOW-2DAY/DAY TO NOW] to search for all orders placed in the last two days.


    Using NOW without rounding affects the filter cache within Solr and results in every NOW query being different. Solr filter caching is not used and no match will be found.

  • orderplaceddate:[NOW/HOUR TO NOW/HOUR+1HOUR] to search for all orders placed in the last hour.

  • orderplaceddate:date:[NOW/DAY-7DAYS TO NOW/DAY+1DAY] to search all orders placed in the last seven days.

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.

Example of customer search results with sorting options