Browse all articles
FAQ

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

Updated on

Here you find the filters of order reports that users ask about most often. You add a filter with Add filter in the report: select the field, set the condition and click Add filter.

1. Fulfillment filters

Fulfillment Status:

  • Unfulfilled
  • Partially fulfilled
  • Unfulfilled or Partially fulfilled
  • Fulfilled
  • Fulfilled or Partially fulfilled

The filter Fulfillment Status with the value Unfulfilled

Is Fulfillable:

  • The first option incorporates 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.

Line items: Fulfillment assigned location:

The warehouse or location that has been chosen to fulfill the line item.

Line items: Fulfilled at:

Filters by the date a line item was fulfilled. Uses the date filters, see below.

Line items: Fulfillment in transit at:

Indicates when the shipment left the warehouse and is on its way to the customer. Uses the date filters.

Line items: Fulfillable quantity:

The number of units of a line item that can still be fulfilled. Uses the number filters: equals, less than, more than, equals or less than, equals or more than.

Line items: Fulfillment service name:

The service or system responsible for fulfilling a line item. Uses the text filters, e.g. equals to any of, starts with, includes.

2. Refund filters

  • Refunds: Amount: The money returned to the customer for a refund. Uses the number filters.
  • Refunds: Created at: The date and time when the refund was issued. Uses the date filters.
  • Refunds: Refund line items quantity: How many units of a product were refunded. Uses the number filters.
  • Refunds: Transactions Kind: Type of the refund transaction: AUTHORIZATION, CAPTURE, CHANGE, EMV_AUTHORIZATION, REFUND, SALE, SUGGESTED_REFUND or VOID.
  • Refunds: Transactions Status: Status of the refund transaction: AWAITING_RESPONSE, ERROR, FAILURE, PENDING, SUCCESS or UNKNOWN. See Can I Export Only Orders with a Specific 'Transaction Status'?

The filter Refunds: Refund line items quantity with more than 10

There is a difference between these two filters:

Line items: Refunded quantity → the total refunded quantity of a line item. (Example: You ordered 5 units of Product A and refunded 4 in total → this field shows 4.)

Refunds: Refund line items quantity → each refund separately. (Example: You refunded 3 units first, and then 1 unit later → you will see two refund entries: 3 and 1)

3. Date filters

Date fields offer these conditions: after, before, between, current, is empty, last, older than and on.

Created at:

Examples:

  • Orders from yesterday: → Created at → last → 1 → days
  • Orders from last month: → Created at → last → 1 → months
  • Orders between 1st May and 15th May: → Created at → between → 1 May – 15 May

last covers the complete days, months or years before the current one. Tick include current day if today should be included as well.

The filter Created at with last 1 days

Line items: Fulfilled at: line items which have been fulfilled today → Line items: Fulfilled at → current → day

The filter Line items: Fulfilled at with current day

4. Other filters

Only line items whose name starts with "PC" should be exported: → Line items: Name → filter lines → starts with → PC

The filter Line items: Name with filter lines, starts with and PC

The second list decides what happens with the other line items of an order:

  • match all: the order is only exported if all of its line items match.
  • match any: the order is exported with all its line items if at least one of them matches.
  • filter lines: the order is exported if at least one line item matches, and only the matching line items are exported.

5. Date placeholders

Export only orders with Tag → equals to any of → %m/%d/%Y:

The filter Tag with equals to any of and the value %m/%d/%Y

%m/%d/%Y is automatically converted to today's date (e.g. "11/18/2026"), and only orders with this exact tag are exported.

Further information about the date format can be found here: File Name

Check out the article for a general explanation of Filters.

Still need help?

We're happy to help you set up your report. Usually we reply within a few hours.

hello@datachamp.io