The purchase orders list: columns and filters
This reference catalogs every column you can show on the Purchase Orders list, every way to filter it, and the submission-format options that appear as a column and a filter. For how to actually browse, sort, save views, bulk-act, and export, see Browse and manage the list.
The list lives at Orders → Purchase Orders, on the Purchase Orders tab. Examples below use PO-DOCS-0001 (supplier Acme Supplies, destination Main Warehouse): its row shows Acme Supplies in the Supplier column and Main Warehouse in the Destination column.
Words like incoterm, ASN, and nominal code are defined the first time they appear here.
Search fields
The Search box matches your text against several fields at once. A single search term is enough — you don't pick a field first. The searched fields are:
- PO Number (the purchase order number)
- ID (the record's automatic ID number)
- Tracking Number
- Order Status
- Submission Format
- Supplier (name)
- Item SKU (the SKU on any line — SKU is the stock-keeping unit, a product's unique code)
- Invoice Number (a linked supplier invoice number)
Quick filters
Quick-filter dropdowns sit above the Grid view. Pick a value in any of them to narrow the list; combined filters compose (they all apply together). Every dropdown has an All option that clears that filter.
| Filter | Narrows by | Options |
|---|---|---|
| Type | The kind of PO | Standard, Dropship, FBA Inbound, AWD Inbound |
| Status | Order status | Draft, Open, Closed |
| Receipt | Receipt status | Unreceived, Partially Received, Received, Received For Less, Dropship |
| Supplier | Supplier | Your suppliers |
| Destination | Destination warehouse | Your warehouses |
| Shipment | Shipment status | Unshipped, Planned, Partially Shipped, Shipped to Warehouse, Shipped to Customer |
| Invoice | Invoice status | Uninvoiced, Partially Invoiced, Invoiced, Invoice Paid |
| Date | Order (purchase) date range | Pick a start and end date |
- Standard — stock shipped to one of your own warehouses.
- Dropship — the supplier ships directly to your customer instead of to you.
- FBA Inbound — a shipment into FBA (Fulfillment by Amazon), Amazon's warehouse-and-fulfillment network.
- AWD Inbound — a shipment into AWD (Amazon Warehousing and Distribution), Amazon's bulk long-term storage service.
For what each status value means and how it changes, see the purchase order status reference.
Advanced filters
For anything more precise than the quick filters, open Advanced Filters in the toolbar. The builder lets you combine conditions with and / or logic, including nested groups, and each active condition shows as a removable chip beneath the toolbar. Text conditions offer operators such as contains, is, and is not; numeric and date conditions offer between, greater than, less than, and similar. Line Items conditions match a PO when any one of its lines meets the condition.
Filters are organized into these groups:
| Group | Available filters |
|---|---|
| Order Info | PO Number, ID, Order Date, Other Date, Submission Format, Created At, Updated At, ASN Last Sent At, Number of Lines, Tax Included?, ASN Sent? |
| Statuses | Type, Order Status, Receipt Status, Shipment Status, Invoice Status (all chosen from a dropdown); Submission Status (text) |
| Fulfillment | Available ETA, ETD, Tracking Number, Shipping Method, Requested Shipping Method, Fully Received At, Shipment Tracking, Shipment Shipping Method, Shipment Date, Shipment Item Qty, Shipment Received |
| Supplier | Supplier (dropdown), Name, Email, PO Email, Company, Contact, Phone, Address, City, State/Province, State/Province Code, Zip, Country, Country Code |
| Destination | Destination (dropdown), Name, Email, Company, Phone, Address, City, State/Province, State/Province Code, Zip, Country, Country Code |
| Line Items | SKU, Name, Quantity, Price, Received, Supplier SKU, Nominal Code, Tax Rate |
| Totals | Total, Total Quantity, Product Subtotal, Additional Cost, Tax Cost, Discount, Currency |
| Other | Supplier Notes, Payment Term, Incoterm, Tag, Invoice Number |
- Order Date — the purchase (order) date on the PO. Other Date — a spare date field you can set on a PO for your own purposes.
- ETA (estimated time of arrival) and ETD (estimated time of departure) — the expected arrival and dispatch dates for the shipment.
- ASN (Advanced Shipment Notice) — an electronic "here's what's coming" notice sent to a receiving warehouse ahead of a shipment. ASN Sent? and ASN Last Sent At tell you whether, and when, it went out.
- Incoterm (International Commercial Terms) — the shipping-terms code (for example FOB or DDP) that sets who pays freight and insurance, and the point at which responsibility passes from the supplier to you.
- Nominal Code — the accounting ledger code a line's cost is booked against, used when your finances sync to accounting software.
- Payment Term — the agreed time to pay (for example Net 30).
- Submission Format and Submission Status — how a PO is sent to the supplier, and where it's in that process (see Submission format options).
Columns
Choose which columns show from Columns in the toolbar. The list ships with a core set visible and many columns hidden by default. Some columns are display-only and can't sort — Type, Lines, Tags, Invoices, Age, all supplier and destination address fields, Shipping Method, Is Dropship, and Tax Included. Money columns are formatted in the PO's own currency, and an empty value shows as an em dash (—).
Identity and dates
| Column | Shows | Sortable | Default |
|---|---|---|---|
| ID | The PO's ID number, assigned automatically by SKU.io | Yes | Shown |
| PO # | The purchase order number; links to the PO's detail page | Yes | Shown |
| Order Date | The order (purchase) date | Yes | Shown |
| Other Date | A secondary date you can set on the PO for your own use | Yes | Hidden |
| Created At | When the PO was first created | Yes | Hidden |
| Updated At | When the PO was last changed | Yes | Hidden |
| Age | Days the PO has been open, shown as 12d open; blank once the PO is closed | No | Hidden |
Parties
| Column | Shows | Sortable | Default |
|---|---|---|---|
| Supplier | Supplier name; links to the supplier's record page | Yes | Shown |
| Destination | Destination warehouse name; links to the warehouse | Yes | Shown |
Type and statuses
Each of these renders as a colored chip. For the meaning of every value, see the status reference.
| Column | Shows | Sortable | Default |
|---|---|---|---|
| Type | Standard, Dropship, FBA Inbound, or AWD Inbound | No | Shown |
| Status | Order status: Draft, Open, or Closed | Yes | Shown |
| Submission | Submission status (for example Unsubmitted, Submitted, Queued, Finalized) | Yes | Shown |
| Receipt | Receipt status (Unreceived, Partially Received, Received, Received For Less, Dropship) | Yes | Shown |
| Shipment | Shipment status | Yes | Hidden |
| Invoice | Invoice status (Uninvoiced, Partially Invoiced, Invoiced, Invoice Paid) | Yes | Hidden |
Fulfillment and shipping
| Column | Shows | Sortable | Default |
|---|---|---|---|
| Available ETA | Estimated arrival date (ETA — estimated time of arrival) with a relative label; overdue dates are highlighted | Yes | Shown |
| ETD | Estimated dispatch (ship) date — ETD, estimated time of departure | Yes | Hidden |
| Tracking # | Inbound tracking number | Yes | Hidden |
| Shipping Method | The PO's shipping method | No | Hidden |
| Fully Received | When the PO became fully received | Yes | Hidden |
| ASN Sent At | When the last Advanced Shipment Notice (ASN) was sent | Yes | Hidden |
| Is Dropship | Whether the PO is a dropship order (supplier ships straight to your customer) | No | Hidden |
Quantities, totals, and currency
Money columns use the PO's currency.
| Column | Shows | Sortable | Default |
|---|---|---|---|
| Total Qty | Total quantity across all lines | Yes | Shown |
| Lines | Line count (or the single line's SKU); the chevron expands the line-item preview | No | Shown |
| Total | Grand total | Yes | Shown |
| Product Subtotal | Subtotal of product lines | Yes | Hidden |
| Additional Cost | Total of charge and cost lines (for example freight and fees) | Yes | Hidden |
| Tax | Tax total | Yes | Hidden |
| Discount | Discount total | Yes | Hidden |
| Currency | The PO's currency code | Yes | Hidden |
| Currency Rate | The exchange rate captured on the PO | Yes | Hidden |
| Tax Included | Whether line prices already include tax | No | Hidden |
Terms, annotations, and links
| Column | Shows | Sortable | Default |
|---|---|---|---|
| Payment Term | The payment term name (for example Net 30) | Yes | Hidden |
| Incoterm | The incoterm — the International Commercial Terms code (for example FOB or DDP) | Yes | Hidden |
| Supplier Notes | Notes shown to the supplier | Yes | Hidden |
| Submission Format | How the PO is delivered to the supplier (see Submission format options) | Yes | Hidden |
| Tags | Up to three tag chips, plus an overflow count | No | Hidden |
| Invoices | Linked supplier invoice numbers; each links to its purchase invoice | No | Hidden |
Supplier and destination address blocks
These columns are all hidden by default and display-only (not sortable). They show the supplier and destination details as they were copied onto the PO when it was created.
- Supplier: Supplier Email, Supplier PO Email, Supplier Company, Supplier Contact, Supplier Phone, Supplier Address, Supplier City, Supplier State/Province, Supplier State Code, Supplier Zip, Supplier Country, Supplier Country Code.
- Destination: Destination Email, Destination Company, Destination Phone, Destination Address, Destination City, Destination State/Province, Destination State Code, Destination Zip, Destination Country, Destination Country Code.
Extra columns that appear automatically
Two more sets of columns appear based on how your account is set up:
- Custom field columns — one column for each purchase-order custom field you've configured (a custom field is an extra field you add to capture information SKU.io doesn't track by default). See Notes, tags, and custom fields.
- Logistics tracking columns — one column for each logistics-tracking date field you have turned on (for example a customs-clearance or vessel-departure date).
Submission format options
The Submission Format controls how a PO reaches its supplier when you submit it. It appears as the Submission Format column, as an Order Info advanced filter, and as a searchable field — and you set it on the PO itself. New POs default to the format configured in your Purchase Orders settings.
| Option | What SKU.io sends on submit |
|---|---|
| Email PDF Attachment | Emails the supplier a PDF of the PO |
| Email XLSX Attachment | Emails an Excel (XLSX) file |
| Email PDF & XLSX Attachments | Emails both a PDF and an XLSX |
| Email CSV Attachment | Emails a CSV (comma-separated values) file |
| Email PDF & CSV Attachments | Emails both a PDF and a CSV |
| Manual | Sends nothing — you contact the supplier outside SKU.io |
Every email format requires a PO email address on the supplier. Without one, submitting the PO is blocked. Manual doesn't email anyone, so submitting a Manual-format PO marks it Finalized without contacting the supplier through SKU.io.
Plain spreadsheets can garble long numbers as scientific notation (for example turning a barcode into 1.23E+11). The XLSX export pins those columns to text so it never happens — making XLSX the long-number-safe choice.
The combined options (Email PDF & XLSX Attachments, Email PDF & CSV Attachments) attach both files to the one email.
For the submit flow itself, see Approve and submit a PO.
Next steps
- Browse and manage the list — use these columns and filters, save views, and export.
- Exportable purchase order columns reference — which of these columns land in a list export.
- Importable purchase order columns reference — the columns for creating POs from a file.
- Purchase order fields reference — what each field on a PO means.
- Purchase order status reference — every status value and its transitions.
- Purchase orders overview — the full guide set.