NetSuite Product Categories To iPaaS.com Mapping Documentation
A NetSuite product category can be captured into iPaaS.com as a product category. The integration records the category name and resolves its parent category to maintain the category hierarchy. Product categories are a reference record the item-capture collections depend on — an item's category assignments resolve against the categories created here.
ID Format
Manual Sync ID Format
Enter the NetSuite product category's internal ID on the Manual Sync page.
External ID Format
iPaaS.com records the NetSuite category's internal ID as the external-ID link, so later transfers update the existing category rather than creating a duplicate, and so child categories can resolve their parent.
Deleted Record Support
There is no Product Categories delete collection in this set — category removal is not propagated by this collection.
Mapping Collection Status
Status: Enabled (a single Add/Update collection).
Trigger Events: Create and Update. Captured on demand from Manual Sync and on the category events enabled in Inbound Data Flows (see NetSuite Connections and Settings).
Duplicate or Conflicting Mappings
None. A single Add/Update collection captures product categories.
Supported Child Collections
None. Hierarchy is represented by each category's ParentId resolving to another captured category.
System Caveats
iPaaS.com Caveats
Product Category data type. This collection populates the iPaaS.com Product Category entity.
Parent categories are created automatically (best-effort). If a category's parent is not yet in iPaaS.com, the integration attempts to create it automatically as a prerequisite. Because that parent creation is best-effort — a failure does not block the child category — capturing categories parent-first, or re-running, is the reliable way to guarantee nested categories resolve their parent link.
Prerequisite for item category capture. The item-capture collections (Product, Assembly, Non-Inventory, Service) assign categories via
ConvertNetSuiteProductCategoriesToiPaaS, which matches against the categories created here. That item-side capture also requires the Custom List Script ID preset to be configured in the integration's Subscription Settings in iPaaS.com (it defines the NetSuite source list of categories). See the item-capture docs for details.
Setup Requirements
Sync categories first (parent-first). Establish the category hierarchy in iPaaS.com before relying on item category assignments.
Configure the Custom List Script ID preset (in the integration's Subscription Settings in iPaaS.com) for the item-side category capture to function.
Inbound Data Flows + webhook scripts — enable the NetSuite category events for automatic capture.
Authentication
The integration authenticates to NetSuite using the connection configured for the integration; the webhook scripts that emit NetSuite events are documented in NetSuite Connections and Settings.
Integration Flow
A NetSuite product category is captured — on demand (internal ID) or on category events when Inbound Data Flows and the webhook scripts are in place.
The integration creates or updates the iPaaS.com product category with its name and resolves its parent category (when the parent is already in iPaaS.com) to maintain the hierarchy.
Mappings
Add/Update NetSuite Product Categories TO iPaaS.com
iPaaS.com data type: Product Category
Captures a NetSuite product category into an iPaaS.com product category.
Mapping Type | Source Field (NetSuite) | Destination Field (iPaaS.com) | Description |
Field | Name | Name | Required. The category name. |
Dynamic Formula |
| ParentId | Optional. The iPaaS.com id of the parent category (for nested categories); resolves only when the parent has already been captured. |
Error Handling
Parent category not linked — a category whose NetSuite parent is not yet in iPaaS.com is created without its parent link. Resolution: capture the parent category, then re-sync the child.
Testing & Validation
Test Scenarios
Capture a top-level category. Manually sync a NetSuite category with no parent and confirm an iPaaS.com category with the name.
Capture a nested category. After its parent exists in iPaaS.com, sync a child category and confirm its
ParentIdresolves to the parent.Item assignment. Confirm an item's category assignments match the captured categories (with the Custom List Script ID preset configured).
Validation Checklist
The category hierarchy is captured parent-first.
The Custom List Script ID preset is configured for item-side category capture.
Additional Notes
These categories are what the item-capture docs'
Categoriesmapping resolves against; see the Product / Assembly / Non-Inventory / Service capture docs.Known limitations are collected in NetSuite Known Limitations.