Search and filter purchase orders

Karl Falconer · Updated

The Purchase Orders list page supports two search modes and a filter panel. Use basic search for quick lookups by ID or buyer name, 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.

Purchase Orders list with search and filter controls

Type into the search box and click Search (or press Enter). The placeholder text — Search purchase orders by ID, buyer name… — describes the fields the basic search covers:

  • PO display ID and external ID
  • Buyer first/last name

For example, typing lubowitz returns POs where the buyer’s name contains that text.

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. The placeholder shown in the input — fulfillment_state:received AND external_id:PO* — is a working example you can adapt.

Useful fields:

Field Type Example
external_id text external_id:PO-2026-0042
external_display_id text external_display_id:0114530
store_id integer store_id:481
fulfillment_state text fulfillment_state:received
ordered_at date ordered_at:[2026-01-01 TO 2026-02-01]
due_date date due_date:[2026-04-01 TO 2026-04-30]
skus array skus:WIDGET-*
platform text platform:dsco

Combine fields with AND, OR, and NOT. For example:

fulfillment_state:error AND skus:WIDGET-* AND due_date:[2026-04-01 TO *]

Advanced query field with example syntax

Filter panel

Click Filter by to open the filter menu. Each filter is a separate facet that ANDs with the search query.

Filter by dropdown showing Status, Connection, Sales Channel, and Date

Filter What it does
Status One or more fulfillment statuses. See Purchase order statuses.
Connection Restrict to a single connection between a source system and a warehouse.
Sales Channel Restrict to a single source (the store / drop-ship platform the POs are imported from).
Date Filter on due_date — preset ranges (Today, Last 7 days, etc.) or a custom range.

Selecting a Status filter shows the available options — see Purchase order statuses for what each one means.

Status filter options for Purchase Orders

Sort

Click a column header with a sort caret to toggle the sort direction. Sortable columns on the Purchase Orders list are: Display ID, Fulfillment Status, and Due Date.

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.

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.