> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://help.datachamp.io/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# What Are the Most Commonly Used Filters and How Do They Work?

#### ${color}[#1a63ba](Most Asked Filters Explained:)

Here you'll find detailed explanations of the most commonly used filters:

1. ${color}[#1a63ba](**Fulfillment Filter:**)  

You can use different fulfillment filters:

**Fulfillment Status:**
* Unfulfilled
* Unfulfilled or Partially fulfilled
* Partially fulfilled
* Fulfilled 
* Fulfilled or Partially fulfilled 
![](https://storage.crisp.chat/users/helpdesk/website/-/d/0/0/f/d00f55635133d800/fulfilment-filter_ryw0zq.png)

**is Fulfillable:**
* __Incorporate other orders__: DataChamp checks the inventory across all orders to see if this order is fulfillable.
* __Independent of other orders:__ DataChamp checks only this single order to see if it is fulfillable.

**Fulfillment assigned location:**
The warehouse or location that has been chosen to fulfill the order. 

**Fulfilled at:**
Filters by the date an order was fulfilled: exact date, before/after a date, between two dates, within the last X days, or if empty.

**Fulfillment in transit at:**
Indicates when the shipment left the warehouse and is on its way to the customer. Can be filtered using date filters.

**Fulfillable quantity:**
The number of product units in an order that are still available to be fulfilled. Filter with quantity filters.

**Fulfillment service name:**
The service or system responsible for fulfilling an order. Filter with character filters.


2. ${color}[#1a63ba](**Refunded Filter**)

There are different Filters: 
* **Refunded Amount:** The money returned to the customer for a refund. Uses quantity filters.
* **Refund Created At:** The date and time when the refund was issued. Uses date filters.
* **Refunded Line Item Quantity:** How many units of a product were refunded. Uses quantity filters.
* **Transaction Kind:** Type of refund transaction (e.g. `refund`, `sale`, `authorization`)
* **Transaction Status:** Status of the refund (e.g., `success`, `pending`, `failed`).

![](https://storage.crisp.chat/users/helpdesk/website/-/d/0/0/f/d00f55635133d800/refunds_1xhtcwb.png)
||| There is a difference between the two filter:
||| Line items: Refunded quantity → shows the total refunded quantity for a line item. *(Example: You ordered 5 units of Product A and refunded 4 in total → this field shows 4.)*
||| Refunds: Refunded line items quantity → shows each refund separately. (*Example: You refunded 3 units first, and then 1 unit later → you will see two refund entries: 3 and 1*)


3. ${color}[#1a63ba](**Date Filters**)

**Created at**: 
Examples:
* Orders from yesterday: → Created at → last → 1 day
* Orders from last month: → Created at → last → 1 month
* Orders between 1st May and 15th May: → Created at → between → 1 May – 15 May

![](https://storage.crisp.chat/users/helpdesk/website/-/d/0/0/f/d00f55635133d800/orders-yesterday_7sxecm.png)

**Fulfilled at**: Line items, which have been fulfilled today: 
![](https://storage.crisp.chat/users/helpdesk/website/-/d/0/0/f/d00f55635133d800/heute-fulfilled_w4j2ov.png)

4. ${color}[#1a63ba](**Other Filters:**)

Only Line Items, that start with "S" should be exported: 
![](https://storage.crisp.chat/users/helpdesk/website/-/d/0/0/f/d00f55635133d800/beginnt-mit-s-filter_8w93sj.png)

5. ${color}[#1a63ba](**Date placeholders**)${color}[#1a63ba]( )

Export only orders with "Tag" "equals to any of" "%m/%d/%Y":
![](https://storage.crisp.chat/users/helpdesk/website/d00f55635133d800/filter_xksrpk.png)

"%m/%d/%Y" will be automatically converted to today's date (e.g., "11/25/2025"), and only orders with this exact Tag will be exported.

| Further information about the date format can be found here:  [File Name](/en/article/file-name-1j04n6h/)

| Check out the article for a general explanation of [Filters](/en/article/filter-153bh8k/).