Orders Filters

In the Orders section, you can use filters to find orders with more precision and reduce the time needed to investigate transactions. The Orders view includes basic filters and advanced filters that help you narrow results using payment, card, fraud, processor, and amount information. The Orders section allows you to search and filter orders using multiple criteria at the same time.

Advanced filters work together with the existing filters in the Orders table. Results continue to respect the current table behavior, including pagination, sorting, and order count.

Available filters

The Orders section includes the following filters.

Basic filters

Filter	Description	Type
Email	Search by customer or billing email	Text
Order ID	Search by order ID	Text
Order date	Filter orders by creation date and time range	Date/time range
Payment status	Filter by payment lifecycle status	Multi-select
Payment method	Filter by payment method type	Multi-select
Processor	Filter by processor used in the payment	Multi-select
Fraud status	Filter by fraud decision or status	Multi-select
Group ID	Search by group ID when available	Text
Store ID	Filter orders for one or more stores when applicable	Multi-select

Additional filters

Select Filters to open the advanced filters panel.

Filter	Description	Type
Total amount	Filter orders by minimum and maximum order amount	Numeric range
Currency	Filter by currency code	Multi-select
MPP credential	Filter by merchant payment processor credential	Multi-select
Fraud provider	Filter by fraud provider	Multi-select
Authorization code	Search by authorization code	Exact text
External transaction ID	Search by external transaction ID	Exact text
Payment created at	Filter by payment creation date and time	Date/time range
Brand	Filter by card brand	Multi-select
Card type	Filter by card type	Multi-select
Routing strategy	Filter by routing strategy	Multi-select
BIN (first 6–8)	Search by one or more BIN values	Exact numeric text
Last 4	Search by one or more last 4 values	Exact numeric text
Issuer bank	Filter by issuer bank	Multi-select
Installments	Search by installments value	Text
3DS	Filter orders by whether 3DS was used	Select
AVS result	Filter by AVS result	Multi-select

How filters work

Consider the following behavior when using filters in Orders:

Behavior	Description
Across different filters	Filters are applied with AND logic
Within the same multi-select filter	Selected values are applied with OR logic
Numeric ranges	Minimum and maximum values are inclusive
Text fields	Standard text searches use a contains match
Exact text fields	Some fields use exact match, such as Authorization code and External transaction ID
BIN and Last 4	Values are matched exactly
Date and time ranges	Ranges are inclusive
Time zone	The date and time selector supports time zone selection

Examples

Example	Result
Processor = Worldpay and Payment status = Captured, Refunded	Returns only orders processed by Worldpay with either Captured or Refunded payment status
Brand = Visa, Mastercard	Returns orders with Visa or Mastercard
Total amount = 100000 to 250000	Returns orders with total amount within that range, including both values
BIN = 434769, 510510	Returns orders that match either BIN exactly
Last 4 = 2361, 0005	Returns orders that match either last 4 value exactly

Open advanced filters

To open the advanced filters panel:

Go to Orders.
Use the top filter bar to review the visible filters.
Select Filters.
Review or complete the additional filters in the side panel.
Apply the values you want to use for the search.

The Orders table updates the results based on the selected filters.

Use filters in Orders

To search using one or more filters:

Go to Orders.
Enter or select one or more filter values.
Combine filters as needed.
Review the updated results in the Orders table.

You can use basic filters and advanced filters together in the same search.

Search with text filters

Text filters allow you to search for specific values.

Standard text search

The following fields use a contains match:

Email
Order ID
Installments

For these fields, the result can include orders where the entered value appears within the stored value.

Exact text search

The following fields use an exact match:

Authorization code
External transaction ID
BIN (first 6–8)
Last 4

For BIN and Last 4, you can enter more than one value.

Use BIN and Last 4 filters

The BIN and Last 4 filters support multiple values in a single search.

To use these filters:

Open the advanced filters panel.
Locate BIN (first 6–8) or Last 4.
Enter one or more values separated by commas.
Apply the search.

Each value is matched exactly.

Use date and time filters

Date filters allow you to narrow the search using an inclusive date and time range.

The Orders section supports time zone selection in the date component. By default, the time zone of the merchant's country is selected, but you can choose a different time zone when needed.

To filter by date and time:

Select the date filter you want to use, such as Order date or Payment created at.
Choose the start date and time.
Choose the end date and time.
Review the selected time zone.
Apply the search.

Multi-select filters

Multi-select filters allow you to choose more than one value in the same filter.

These filters include options such as:

Payment status
Payment method
Processor
Fraud status
Currency
MPP credential
Fraud provider
Brand
Card type
Routing strategy
Issuer bank
AVS result

When you select multiple values in the same filter, Orders returns results that match any of those values for that filter.

Filter availability

Some filters are shown only when they apply to the merchant configuration.

Filter	Availability
Store ID	Shown only when the merchant has more than one store
Group ID	Shown only for merchants enabled through feature flag

Active filters and results

When filters are applied:

Active filters are displayed in the Orders view.
The table shows the results that match the selected criteria.
Pagination and sorting continue to work normally with the filtered dataset.

Clear filters

To remove filters from the Orders search:

Go to Orders.
Select Clear in the top filter bar to remove the current filters.
If you are using the advanced filters panel, select Clear all to reset all filters.

After clearing filters, the Orders table returns to the default search state.

Orders table behavior

Applying filters changes the results in the table, but it does not change the table columns automatically.

Consider the following:

Behavior	Description
Filtered results	The table updates based on the selected filters
Columns	Columns remain unchanged unless you edit them manually
Edit columns	Use Edit columns to show, hide, or reorder columns
Order detail navigation	When you open an order and return to the list, the applied filters remain available

For example, if you filter by Fraud status, the Orders table will return the correct results, but the Fraud status column will only appear if it has been added through Edit columns.

Empty results and loading states

When a search is in progress, the Orders table shows a loading state.

If no orders match the selected filters, the empty state is displayed.

State	Behavior
Loading	The table shows a loading state while results are being retrieved
No results	The page shows an empty state indicating that no orders match the selected filters
Timeout	If the search takes too long, the page shows a timeout message

Considerations

Filters in Orders are combined using AND logic across different filters.
Multi-select values in the same filter are combined using OR logic.
Total amount ranges are inclusive.
The minimum value must be lower than the maximum value when using range filters.
BIN and Last 4 support multiple exact values separated by commas.
Columns and filters work independently.
Some filters are available only for specific merchants or configurations.
The Orders section keeps the current filters when you open an order and return to the list.
The date and time filter supports time zone selection.