---
title: "Searching for items using the Business Tools"
slug: "searching-for-items-using-the-business-tools"
abstract: "How to search for sellable items, orders, or customer records using the Commerce Business Tools."
---
# Searching for items using the Business Tools

The Sitecore Experience Commerce Business Tools provide a search capability to help you find Commerce items such as [sellable items](https://doc.sitecore.com/xp/en/users/101/sitecore-experience-commerce/work-with-a-sellable-item.html "Work with a sellable item"), [promotions](https://doc.sitecore.com/xp/en/users/101/sitecore-experience-commerce/work-with-promotions.html "Work with promotions"), [price books](https://doc.sitecore.com/xp/en/users/101/sitecore-experience-commerce/work-with-price-books.html "Work with price books"), [orders](https://doc.sitecore.com/xp/en/users/101/sitecore-experience-commerce/work-with-orders.html "Work with orders"), [customer records](https://doc.sitecore.com/xp/en/users/101/sitecore-experience-commerce/work-with-customer-accounts.html "Work with customer accounts"). This topic provides a high level description of the search feature.

<details>
<summary><h2>Search terms</h2></summary>

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.

> [!note]
> 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.

</details>

<details>
<summary><h2>Search filters</h2></summary>

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.](https://doc.sitecore.com/api/markdown-image/xp/en/users/101/sitecore-experience-commerce/images/Search_Term_filter.png)

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.

    > [!note]
    > 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.

</details>

<details>
<summary><h2>Sorting results</h2></summary>

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](https://doc.sitecore.com/api/markdown-image/xp/en/users/101/sitecore-experience-commerce/images/Search_results_sortable.png)

</details>