ParcelPilot
Help

Orders Table Columns

This table shows customer orders and their fulfilment progress. Optional columns can be turned on from the column picker.

Default columns

  • Client: Shows which client the order belongs to for roles that can see multiple clients.
  • Order Date: Shows when the order was placed.
  • Source: Shows which ecommerce platform the order came from.
  • Order #: Shows the order number used in ParcelPilot and, where relevant, the upstream platform order number.
  • Payment: Shows the payment status from the ecommerce platform or imported order data.
  • Order Status: Shows the persisted order lifecycle status stored on the order record. This is the existing orders.status value used by tracking projection, accounting-related completion rules, and closed-order filtering.
  • Fulfilment Status: Shows whether the order is Unfulfilled, Partially fulfilled, or Fulfilled based on the canonical fulfilment summary. For partial orders, the badge can also show the outstanding quantity.
  • Shipping Title: Shows the shipping method name from the order.
  • Merge: Shows whether the order is merged or looks like a merge candidate.
  • Suggested shipping: Shows the current suggested carrier service.
  • Latest Shipment: Shows the latest linked shipment number and a badge for that shipment's own tracking state only.

An order can legitimately show all three at once, for example:

  • Order Status: Complete
  • Fulfilment Status: Partially fulfilled - 1 outstanding
  • Latest Shipment Status: Delivered

If you are looking at a corrected or reversed dispatch and need to understand why the badges do not all match one another, see Correcting a dispatched order.

Optional columns

  • Shipping Method: Shows the shipping method name in a separate field.
  • Payment Method: Shows the imported payment method label or code when the channel provides one.
  • Shipping Price: Shows the shipping charge on the order.
  • Requested Delivery: Shows the requested delivery date.
  • Virtual: Shows whether the order is for non-physical goods.
  • Channel: Shows the channel name as a text badge.
  • Replenishment: Shows whether stock needs replenishing before the order can be fulfilled.
  • eCommerce Status: Shows the order status held by the ecommerce platform.
  • Lifecycle: Shows whether the order is active, blocked, read only, suppressed, or archived locally.
  • Ops Mode: Shows whether the order is currently treated as Operational or Monitoring only. See Orders - Ops Mode.
  • History Mode: Shows whether the order is treated as pre-go-live history rather than normal live warehouse work. See Orders - Ops Mode.
  • Accounting: Shows whether the order is retained for accounting/history and whether it is exportable.
  • GDPR: Shows whether customer-identifying data has been anonymised.
  • Serials: Shows serial numbers linked to the order lines.
  • DOM/INT: Shows whether the destination is domestic or international.