Understanding Products in Pipe17

Nazeli Abrahamyan

Products in the app are catalog items that can be ordered, fulfilled, and tracked across your sales channels and fulfillment systems. A product can represent a single SKU or a bundled collection of SKUs. Each product entry serves as a central source of truth for inventory, pricing, and availability across all connected systems.

Products can be pulled automatically from integrated systems, uploaded via CSV, or created via the Pipe17 API. Once added, products are managed from the Products page in the app.

Learn more about Products in this course.

Product Types

The app supports five product types, each with specific behaviors and use cases:

Product Type	Description	Example
Simple Product	A standalone product with no variants or components.	`EMOCK-KETTLE` (Tea Kettle)
Parent Product	A product that serves as a container for one or more variants (child products).	`EMOCK-SOCKS` (Sport socks)
Child Product	A variant of a parent product, such as a specific color or size.	`EMOCK-SOCKS-GRAY-S` (Gray Sport socks, Small)
Bundle Product	A SKU representing a group of products sold together.	`EMOCK-BNDL` (Tea set with teapot and cups)
Bundle Item	A product that is a component of a bundle and may be sold individually.	`EMOCK-TEAPOT` (Part of the tea set bundle)

Note: These example products can be created by adding the Pipe17 Mock Ecommerce integration.

When adding products to Pipe17, the system does not override existing records owned by an integration. If an integration already owns a product, and another integration attempts to create the same record, the action will fail. Ownership remains with the integration that first added the item, and subsequent integrations cannot overwrite it.

If a product is created via UI or CSV import, it does not have this restriction and can be updated by any integration.

Viewing Products

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

Each column includes these key details:

Column	Description
SKU	Stock Keeping Unit – unique identifier for each product. Required, must be unique across your org. Used for inventory tracking, order processing, and integrations.
Name	Display name of the product. Required, shown in interfaces, reports, and what staff/customers see.
Type	Product classification determining system behavior. Possible values: simple, bundle, bundleItem, child, parent.
Vendor	Supplier or manufacturer of the product. Used for supplier reporting, purchasing, and quality tracking.
Cost	Product cost (amount paid to acquire). Used in margin, pricing, and financial reporting.
Created	Timestamp when the product was first created in Pipe17 (ISO 8601). System-generated.
Updated	Timestamp when the product was last modified in Pipe17 (ISO 8601). Auto-updated on changes.
Tags	Custom labels (array) for grouping, filtering, and categorizing products. Useful for campaigns and bulk operations.
Integration	Reference to the integration that created/manages the product (e.g., Shopify). Identifies the system of record.
UPC	Universal Product Code – standardized barcode for retail and inventory scanning.
Part ID	Manufacturer’s part number or internal part identifier. Used for supplier cross-reference and B2B scenarios.
External Product ID	Identifier from the external system that created the product. Critical for sync and mapping across systems.
Do Not Track Inventory	Boolean flag to indicate if inventory should not be tracked. Use for digital, made-to-order, or unlimited-stock items.

Column Customization Options

All columns can be resized.
Use the column selector (squares icon in the top-right corner) to choose which columns are visible.
Drag-and-drop columns to reorder them.
Use the refresh icon to reload data.
Adjust the layout with view modes: Comfortable (default), Compact, or Full.
Enable or disable Word Wrap for easier readability.
Restore default settings anytime using the Restore Defaults option.

Filtering Products

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

Filter Name	Description	Component Used	Options	Field Schema
Created	Filters products by their creation date in the app	Date filter	Date range picker	`createdAt`
Updated	Filters products by their last update date in the app	Date filter	Date range picker	`updatedAt`
Status	Filters products by current status	String (single/multiple selection)	Active Inactive Deleted	`status`
Vendor	Filters products by vendor or supplier	String (keyword searchable)	Free text search	`vendor`
Types	Filters products by product type classification	Array of strings (multiple selection)	Simple Bundle BundleItem Child Parent	`types`
Integration	Filters products by the integration that created or manages them	ID reference to integrations	Activated integrations	`integration`
Exception Categories	Filters products that have exceptions in specific categories	String (category ID)	Another Advisory Blocked Financials Error Fulfillment Creation Failure Fulfillment Insertion Failure Inventory Sync Failure Order Sync Failure Order Validation Error Out of Stock Sent Order Failure Transformation Failure Unexpected Disconnect Automation Error	`exceptionCategoryId`

Advanced Filters

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

Category	Example Criteria
Basic Product Information	SKU, UPC, Name, Description, Status, Types
External System Fields	Integration, External Product ID, External Product API ID, Part ID, Vendor
Pricing & Cost	Price Name, Price Currency, Price Value, Cost, Cost Currency
Physical Attributes	Weight, Weight Unit, Height, Length, Width, Dimensions Unit, Taxable, Country of Origin, Harmonized Code
Product Relationships	Parent External Product ID, Bundle Items SKU, Bundle Items Quantity, Variant Options Name/Value
Channel Publishing	Published SKU, Published Name, Published Integration ID, Published External Product ID, Published Status, Published Buffer Inventory, Published Inventory Not Tracked
Metadata & Tracking	Tags, Image URLs, Custom Fields Name/Value, Inventory Not Tracked, Hide in Store, Auto Eng Update Status
Dates	Created At, Updated At, External Product Created At, External Product Updated At, Auto Eng Update Status Updated At
Exceptions	Exceptions (types), Exception Category ID

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 products by SKU and vendor across multiple integrations
Segmenting bundles with specific component SKUs or quantities
Identifying products missing publication data in a sales channel
Filtering products with outdated cost or price information
Locating items tied to specific exception categories

Saved Filters

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

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.

Clear All Filters

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

Searching Products

The search bar at the top of the Products page allows you to quickly locate products by scanning across multiple data fields. It supports partial text matches and is useful for pinpointing single or any type of product.

Product Details Page

Clicking a product in the list opens the Product Details page. Here, you can:

View product fields such as SKU, weight, dimensions, price, and UPC
Review variant relationships (for parent/child products)
Manage bundle configurations (for bundle products)

Product data cannot be edited directly in the portal. Changes must be made through the source integration or CSV upload.

Bulk Actions for Products

Bulk actions allow you to manage large sets of products efficiently. Available actions include deleting products, pushing products to integrations, and enabling or disabling inventory tracking.

Delete Products

Aspect	Details
What It Does	Permanently removes selected products from your catalog. Products are typically soft-deleted (marked as deleted, data preserved).
When to Use	Discontinued, duplicate, test, or obsolete products.
Important Considerations	Check dependencies first: ensure products aren’t in active orders, bundles, inventory, or integrations.
Best Practices	Filter carefully, export backup, start small, verify selection before deletion.
Process	Filter products → 2. Select products → 3. Choose Delete → 4. Confirm deletion → 5. Provide email for results → 6. Monitor email results.

Push Products

Aspect	Details
What It Does	Syncs selected products to connected integrations/channels. Equivalent to clicking Sync individually but in bulk.
When to Use	After bulk updates, new launches, price updates, inventory corrections, or channel setup.
How It Works	Pushes to integrations with “Sync Product to Channel” enabled. Applies channel-specific settings (SKU mapping, buffer inventory, names, publication status).
Process	Filter products → 2. Select products → 3. Choose Push Products → 4. Provide email → 5. Monitor sync results.

Update Products: Enable/Disable Inventory Tracking

Aspect	Details
What It Does	Modifies `inventoryNotTracked` in bulk: Enable Tracking: Sets `inventoryNotTracked = false` Disable Tracking: Sets `inventoryNotTracked = true`.
When Inventory IS Tracked	Stock levels monitored, orders consume inventory, stock-outs block fulfillment, included in reports, reorder alerts enabled.
When Inventory is NOT Tracked	Changes in inventory are not registered. For example, if the inventory was set to 0 before locking, then the availability would always be 0 and thus this inventory location will be skipped.
When to Enable	Physical products with limited stock, new products requiring control, transition from dropship to stocked.
When to Disable	Digital/services (licenses, downloads, consulting), made-to-order items, dropship products, gift cards.
Process	Filter products → 2. Select products → 3. Choose “Enable” or “Disable Inventory Tracking” → 4. Provide email → 5. Verify changes.
Impact on Integrations	Enable: Requires inventory counts, triggers syncs, may affect availability. Disable: Products always available, inventory preserved but ignored, channel buffers still apply.

Troubleshooting

Why can’t I edit products in the portal?
Product information is synced from integrations or CSV imports. To update data, make changes at the source or re-upload a CSV.

Why doesn’t the inventory buffer field appear?
The field is only available for e-commerce integrations where sellable inventory applies (e.g., Shopify, Walmart).

My bundle inventory shows zero. Why?
Check whether any component has insufficient inventory. Bundle availability is based on the lowest available quantity of required components.

Need Help?

If you need additional assistance:

Use Ask Pippen, our AI agent, located at the top of the platform 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.

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.