Viewing, Searching, and Filtering Orders

Nazeli Abrahamyan

The Orders page in the app gives you full visibility into all transactions ingested into your Pipe17 workspace. From here, you can:

- Monitor your order flow across systems

- Identify fulfillment or sync issues

- Drill into individual order details

- Apply filters to find exactly what you need

Whether you're tracking down a specific order or resolving exceptions, this page is your operational hub.

If you’re unable to find an expected order, it may have been skipped due to configuration settings, ingestion filters, or connector-level rules. To review skipped orders, navigate to the Events → Skipped Entities section within the relevant integration for more details.

Viewing Orders

By default, the Orders list displays all ingested orders, sorted by date (newest first). Click on any order to open the Order Detail Page, where you’ll see full data and sync history for that transaction.

Each column includes these key details:

Column	Description
Order ID (required)	Unique identifier from the source system
Source	Connector from which the order was ingested
Status	Lifecycle state (e.g., New, Fulfilled, Canceled)
Exceptions	Displays any sync or routing issues detected
Tags	Tags imported from the source system
Ordered	Date the order was imported into Pipe17
Location	Fulfillment location assigned to the order
Source Integration	Integration that originated the order
First Name	Customer's first name
Last Name	Customer's last name
State	State or province in the shipping address
Country	Country in the shipping address
Total	Full order amount including shipping, tax, and discounts
Expected Delivery Date	Estimated date of delivery if available

Additional columns:

Company
Ingested
Updated
Routing Status
Order API ID
Shipping Code
Shipping Carrier
Shipping Class
Source Type
Email
Connector Name
SKUs
Line Item Count
Total Quantity

Column Customization Options

Use the Refresh icon to reload data.
Resize columns directly on the page.
Drag-and-drop columns to reorder them.
Open the column selector (squares icon in the top-right corner) to manage display settings:
- Show or hide specific columns
- Adjust layout with view modes: Comfortable (default), Compact, or Full
- Enable or disable Word Wrap
- Restore default settings at any time with Restore Defaults

Filtering Orders

Pipe17 provides flexible filtering options so you can quickly segment and investigate your orders.

Standard Filters

Use the filter bar at the top of the Orders page to apply quick filters.

Name	Description	Usage	Component Used	Field in Schema
Ordered	Filter orders based on when they were created in Pipe17	Select a specific date or range using the date picker	Date range picker	`createdAt`
Ingested	Filter by the order’s creation date in the external app	Select a specific date or range using the date picker	Date range picker	`extOrderCreatedAt`
Source	Filter orders based on the channel/app they came from	Select one or more sources from the dropdown	Multi-select dropdown	`orderSource`
Order Source Type	Filter by the type of source (e.g., online, POS, wholesale)	Select one or more types from the dropdown	Multi-select dropdown	`orderSourceType`
Status	Filter by the current order status	Choose one or more statuses from the dropdown (e.g., fulfilled, onHold)	Multi-select dropdown	`status`
Tags	Filter by tags assigned to the order	Enter one or more tags using the input field with autocomplete	Tag input with autocomplete	`tags`
Location	Filter orders by the assigned fulfillment location	Choose one or more locations from the dropdown menu	Multi-select dropdown	`locationId`
Exception Categories	Filter orders with specific exception types	Choose one or more exception categories	Multi-select dropdown	`exceptionCategories`
Integration	Filter orders by the integration that ingested the order	Choose one or more integrations from the dropdown menu	Multi-select dropdown	`integration`

Advanced Filters

Advanced Filters allow more complex conditions and logical operators to locate specific orders with precision.

Category	Example Criteria
Customer Information	Name (`firstName`, `lastName`), Email, Company, Customer Type
Order Details	Order ID, External Order ID, Status, Source, Source Type, Currency, Total Price, Payment Status
Shipping Information	Country, State, City, Carrier, Method, Expected Delivery Date
Routing Information	Routing Status, Location ID, Disposition
Line Items	SKU, Product Name, Quantity, Price
Date and Time Fields	Created Date, Updated Date, Ship By Date, Hold Until Date
Exceptions	Exception Types, Exception Categories

Advanced filters support:

Multiple conditions
Logical operators (AND / OR)
Comparison operators (equals, not equals, contains, greater than, etc.)

Use Advanced Filters for tasks like:

Finding orders for a specific SKU and shipping country
Segmenting B2B orders over a certain total price
Identifying orders stuck in a specific routing state

Saved Filters

Pipe17 allows you to save frequently used filters for future use, making it easier to consistently apply complex filtering criteria.

Feature	Description
Save Filter	Save your current set of filters for reuse. Click Save Filter, name it, and confirm.
Access Saved Filters	Saved filters are available from a dropdown menu in the filter panel.
Use Cases	Save time with frequently used filters like “Ready for Fulfillment US Orders” or “Orders with Exceptions.”

Clear All Filters

Feature	Description
Clear All	Removes all applied filters instantly. Use when starting a new search or resetting results.

Both Standard and Advanced Filters support powerful workflows. Use saved filters for quick retrieval and “Clear All” to maintain efficiency.

Searching Orders

The search bar at the top of the Orders page allows you to quickly locate orders by scanning across multiple data fields. It supports partial text matches and is useful for pinpointing individual transactions or sets of related orders.

You can search by:

Searchable Field	Description
Order IDs	Search by Pipe17 internal order IDs or external order IDs from your sales channels
Customer Information	Includes customer name, email address, and company name (if provided)
Product Information	Searchable by SKUs or product names listed in line items
Order Notes	Returns results that match text within any notes or comments added to the order
Custom Fields	Any custom field that contains a text value is searchable

Combining Search and Filters

To refine your results, you can combine the basic search with both standard filters and advanced filters.

How it works:

The search term is applied first across the supported fields.
Filters are then layered on top to further narrow the results.

This allows for powerful combinations such as:

Find all orders containing “Product X” that are in “Fulfilled” status and were created within the last 30 days.

By using search and filters together, you can isolate orders with precision for review, action, or troubleshooting.

Bulk Actions for Orders

Pipe17 allows you to perform bulk actions on selected orders directly from the Orders table. This helps to optimize repetitive tasks and reduce manual effort when managing high volumes of transactions.

Available Bulk Actions

Action	Description
Set Order Hold	Temporarily place selected orders on hold. You can specify hold duration (in days, hours, and minutes).
Update Status	Change the lifecycle status of multiple orders. Supported statuses include: New, Review Required, Ready For Fulfillment, Sent To Fulfillment, Fulfilled, Canceled, Archived.
Update Exception Status	Update how the system handles exceptions for selected orders. Available statuses: Active, Dismissed, Resolved
Run Routing	Triggers the Order Routing Engine to reprocess selected orders. Use this when: Orders were previously on hold Routing issues have been fixed Manual routing is needed
Push Orders	Sends selected orders to their destination connectors (e.g., 3PLs, ERPs). Useful when: Orders failed to sync previously Changes were made that need to be pushed

How to Use Bulk Actions

Filter or search to narrow down the set of orders you want to act on.
Select individual orders using checkboxes or click the header checkbox to select all visible orders.
Choose the appropriate bulk action from the toolbar.

Need Help?

If you need additional assistance:

Use Ask Pippen, our AI agent, located at the top of the app page.
Submit a support request with as much relevant detail as possible. Learn how to submit a request.
For urgent issues, email us directly at support@pipe17.com.

We're here to help you succeed with your operations.

Related to:

Orders

Was this article helpful?

0 out of 0 found this helpful

Comments

0 comments

Article is closed for comments.

Have more questions?

Submit a request

Share it, if you like it.