The Sales Orders list page supports two search modes and a filter panel. Use basic search for quick lookups by ID, customer, SKU, or email, and advanced query when you need to combine specific fields and operators.
For how to save a particular search + filter + column layout for repeat use, see Saved views, filters, and columns.
Basic search
Type into the search box and click Search (or press Enter). Basic search matches across these fields at once:
- Order external ID and external display ID
- Customer email
- Billing and shipping first/last name
- Item SKUs
For example, typing acme returns orders where any of those fields contains “acme”.
Advanced query
Click the </> icon at the right of the search box to switch to advanced mode. The advanced field accepts a Lucene-style query against any of these fields:
| Field | Type | Example |
|---|---|---|
external_id |
text | external_id:abc-123 |
external_display_id |
text | external_display_id:0114530 |
store_id |
integer | store_id:42 |
fulfillment_state |
text | fulfillment_state:shipped |
ordered_at |
date | ordered_at:[2026-01-01 TO 2026-02-01] |
customer_email |
text | customer_email:foo@example.com |
billing_first_name / billing_last_name
|
text | billing_last_name:lowe |
shipping_first_name / shipping_last_name
|
text | shipping_last_name:lowe |
skus |
array | skus:ABC* |
platform |
text | platform:shopify |
Combine fields with AND, OR, and NOT. For example:
fulfillment_state:error AND skus:WIDGET-* AND ordered_at:[2026-01-01 TO *]
Filter panel
Click Filter by to open the filter menu. Each filter is a separate facet that ANDs with the search query.
| Filter | What it does |
|---|---|
| Status | One or more fulfillment statuses. The list shows the 12 user-facing statuses; see Sales order statuses. |
| Merchant | Restrict to one merchant (customer) — useful in 3PL accounts that fulfill for multiple merchants. |
| Connection | Restrict to a single connection between a store and a warehouse. |
| Sales Channel | Restrict to a single store (the source sales channel). |
| SKU | Restrict to orders containing a SKU. Wildcards are supported. |
| Date | Filter on ordered_at — preset ranges (Today, Last 7 days, etc.) or a custom range. |
Selecting a Status filter shows the available options:
Sort
Click a column header with a sort caret to toggle the sort direction. Sortable columns are: External ID, Status, Ordered At, and Imported At.
Reset the search
To clear search, filters, and sort and return to the default view, click Default View at the right end of the toolbar and select Default View from the dropdown — this restores the page to its initial state.
Comments
Please sign in to leave a comment.