iPaaS.com <> NetSuite: Background
Introduction to NetSuite
NetSuite is a cloud-based business management suite covering ERP, financials, and other powerful tools into a single platform, widely used by growing and mid-market businesses.
Used by fast-growing SMBs and mid-market companies across retail, manufacturing, distribution, and services.
Popular with businesses that want a unified cloud platform to replace disparate accounting and operational systems.
Connecting NetSuite to iPaaS.com enables orders, customers, inventory, and financial data to sync automatically across your Ecommerce, POS, CRM, fulfillment, and marketing systems without manual exports or re-entry.
Before You Implement: Customization Pre-Check
Most NetSuite accounts connect to iPaaS.com with no special preparation, and standard configurations sync out of the box. The exception is an account that already runs custom scripts, custom workflows, or automated hand-offs to other systems on top of NetSuite. When those customizations touch the same records iPaaS.com syncs (customers, items, inventory, sales orders, and fulfillments), they can interact with the integration in ways that only surface after go-live.
Review the questions below before you install. If the answer to any of them is yes, contact us first so we can review it with you:
When NetSuite generates an invoice or order confirmation, how many parties or systems are involved in producing or receiving it?
How customized are your fulfillment workflows compared with standard NetSuite?
Do any of your workflows call out to third-party systems, and if so, how (API, file transfer, or EDI)?
Is there a timed or scheduled step in the workflow, for example a delay between an order being received, handed to a fulfillment provider (such as ShipBob or ShipStation), and posting back to NetSuite?
Is there an approval step or other point where a person has to act, effectively a workflow inside a workflow?
When a review is needed, remediation is typically a small, scoped effort (on the order of 10 to 20 hours), and we will always give you an estimate before any work begins. If any of the above applies to your account, contact us before you implement: ipaas.com/contact-us.
API Version Support
iPaaS.com connects to NetSuite through Oracle's SuiteTalk REST web services at your account-specific host ({account-id}.suitetalk.api.netsuite.com), using the stable v1 REST record and SuiteQL query services with OAuth 2.0 authentication.
NetSuite is delivered on a twice-yearly versioned release schedule (for example, the 2026.1 release). The integration works against your account's current NetSuite release and was built and validated against NetSuite 2026.1.
It targets Oracle NetSuite through SuiteTalk REST only — not the older SOAP-based SuiteTalk interface, and not other Oracle ERP products such as Oracle Fusion / ERP Cloud, E-Business Suite, or PeopleSoft.
See the NetSuite Connections and Settings and NetSuite API Endpoints articles for details.
Data Flows
The table below shows the data each side exchanges, the direction it moves, and whether the collection can be initialized (seeded from existing NetSuite records) during setup.
iPaaS.com | Direction | NetSuite | Allow Initialization? |
Customer | ←→ | Customer | |
Customer Company | ←→ | Customer (company record) | |
Customer Category | ←→ | Price Level / Pricing Group | ✔️ |
Product | ← | Item (standard and lot-numbered inventory, non-inventory, assembly, kit, and service items) | |
Product | → | Inventory item (standard inventory items, including matrix items) | |
Product Inventory | ← | Inventory | |
Product Inventory | → | Inventory Adjustment (standard inventory items) | |
Product Variant Inventory | ← | Matrix item inventory | |
Product Variant Inventory | → | Inventory Adjustment (standard matrix items) | |
Product Category | ← | Category | |
Location | ← | Location | ✔️ |
Payment Method | ← | Payment Method | ✔️ |
Shipping Method | ← | Shipping Item | ✔️ |
Alternate Id Type | ← | Reference Name / External ID / MPN | ✔️ |
Gift Card | ← | Gift Certificate | |
Employee | → | Employee | |
Timesheet | → | Time Bill | |
Sales Order | ←→ | Sales Order | |
Invoice | ← | Invoice | |
Cash Sale | → | Cash Sale | |
Cash Refund | → | Cash Refund | |
Return | → | Return Authorization (RMA) | |
Transaction Tracking Number | ←→ | Item Fulfillment |
← iPaaS.com captures the record from NetSuite · → iPaaS.com writes the record to NetSuite · ←→ the record syncs in both directions.
As the system of record, NetSuite supplies master data — products and inventory, categories, locations, price levels, and payment and shipping methods — to iPaaS.com. iPaaS.com writes sales orders, cash sales, cash refunds, and returns into NetSuite, and captures invoices and order fulfillment back from it. Customers, companies, products, inventory, and sales orders can flow in both directions. Products written from iPaaS.com become standard inventory items, including matrix items; lot-numbered and serialized items are not created or updated from iPaaS.com. Returns (RMA) were added in version 1.0.10 — see Features by Release below.
Versions and Release Notes
Version | Release Notes |
1.0.25 (current) | Initializing reference data no longer logs a scope error for each record it transfers. Adds the Alternate Id Type Created and Product Category Created events, which the integration uses for initialization and for a product's category transferred ahead of the product; NetSuite does not send them, so subscribing to them in Inbound Data Flows has no effect. Released together with the 1.0.24 return changes. A corrected 1.0.25 build creates a Return Authorization in a single step holding only the returned lines and any shipping and tax refund lines, so NetSuite scripts or workflows that run when a Return Authorization is created (for example, one that creates a credit memo) see the final record. A second return of an item that the order carries on more than one line is linked to the next order line that still has quantity to return, and the Sales Order Duplicate Matching Field setting no longer applies to returns. |
1.0.24 | Return Authorizations created from iPaaS.com returns hold only the returned items and any shipping refund, instead of every order line with the lines not returned at quantity 0, so items NetSuite will not accept at a quantity of zero no longer cause a return to fail. Updates keep a Return Authorization's lines matched to the return. A return's tax is refunded as its own line by default, and tax-only returns are supported. |
1.0.23 | Lot-numbered inventory items are captured into iPaaS.com as products through the inventory item collection, with the same ID format as standard inventory items; each location's quantity is the item's total across its lots. Automatic capture needs the NetSuite webhook script deployed to lot-numbered inventory items, with its subscription parameters checked in NetSuite. Standalone inventory updates carry each location's total across its lots and bins, and with USE BINS (TRUE/FALSE) on, an item without bins at a location carries the location's quantity. Kits capture lot-numbered members as components. |
1.0.22 | Company sub-customer relationships: a company captured from NetSuite can also record its sub-customers on the iPaaS.com company, each labeled from a NetSuite custom field you choose, with any sub-customer not yet in iPaaS.com imported automatically. Messages about a related customer or company that could not be imported now name that record. |
1.0.21 | Return Authorizations carry the transaction-body custom fields mapped on the return collections, on create and update. |
1.0.20 | Returns that refund only shipping, with no returned items, create a Return Authorization carrying the shipping refund. |
1.0.18 | Coded error messages: every error the integration can record in the iPaaS.com error logs now carries a stable, searchable code alongside its message, cause, and resolution, catalogued in the NetSuite Error Messages article. |
1.0.17 | Location address capture on the Location flow, and loop protection so a Sales Order written to NetSuite is not re-imported as a duplicate on bidirectional subscriptions. |
1.0.16 | Inventory Poll Time Adjustment setting that aligns the inventory poll with your NetSuite account's time zone, so inventory changes are captured reliably across time-zone differences. |
1.0.15 | Sales Orders captured from NetSuite keep their payment's external ID, so payment records stay linked when an order re-syncs. |
1.0.14 | Option to exclude specific items from the placeholder lines generated on an order return, plus full documentation of the subscription settings. |
1.0.13 | Order-level discount support on Sales Orders written to NetSuite. |
1.0.10 | Return Merchandise Authorization (RMA) / order-return workflow, and Sales Order lines that let NetSuite apply each item's own base price. |
1.0.8 | Inventory polling reliably captures every change since the last successful poll. |
1.0.7 | More dependable product capture across the NetSuite item types. |
1.0.6 | Gift certificate capture and redemption. |
1.0.5 | Zero-value amounts — such as free items or $0.00 lines — transfer correctly instead of being dropped. |
1.0.4 | Accurate undeposited-funds handling on cash transactions. |
1.0.3 | Customer payments and SuiteQL-based data retrieval. |
1.0.2 | Invoice capture. |
1.0.1 | Access tokens are kept out of process logs for tighter security. |
1.0.0 | Initial release: customers and companies, the full product catalog and inventory, reference data, sales orders, employees, and time bills. |
The current production version is 1.0.25.
Features by Release
The NetSuite integration has grown steadily across its release history. The highlights below group the major capabilities added in each release, newest first, and link to the mapping documentation for each. See the NetSuite Known Limitations article for the behaviors and prerequisites that apply to these capabilities.
Version 1.0.24 — Returns hold only the returned items
Returns hold only the returned items: a Return Authorization created from an iPaaS.com return holds just the returned items and any shipping refund, and each update keeps its lines matched to the return. Items NetSuite will not accept at a quantity of zero no longer cause a return to fail, so the return line exclusion setting is no longer needed.
Tax refund line on returns: by default, a return's tax is refunded as its own Tax Refund line, like the shipping refund, and the returned items are sent non-taxable so the tax is refunded once. Tax-only returns are supported, and removing the tax-refund mappings keeps NetSuite calculating the return's tax.
Version 1.0.23 — Lot-numbered inventory items
Lot-numbered inventory items: a lot-numbered inventory item captured from NetSuite imports as an iPaaS.com product through the inventory item collection, with the same Manual Sync ID format as a standard inventory item (the internal ID followed by _inv). Inventory is captured as each location's total across the item's lots; the lot numbers stay in NetSuite. Lot-numbered matrix items import with their options and variants, like standard matrix items. Lot-numbered items are captured into iPaaS.com only; the integration does not create or update them, or adjust their inventory, from iPaaS.com. Automatic capture needs the NetSuite webhook script deployed to the Lot Numbered Inventory Item record type, with its subscription parameters checked in NetSuite (see NetSuite Installation Instructions).
Inventory updates carry location totals: standalone inventory updates (from polling and webhooks) carry each location's total across all of the item's lots and bins, the same total the full product transfer records.
Inventory quantities without bins: with USE BINS (TRUE/FALSE) on, an item or location without bins now carries the location's quantity instead of 0. The inventory collections' quantity formula changed in the templates; existing subscriptions keep the previous formula and can update it as described in the Product To iPaaS.com mapping documentation.
Kits with lot-numbered members: a kit's lot-numbered and serialized members are captured as kit components, like its other members.
Version 1.0.22 — Company sub-customer relationships
Company sub-customer relationships: a company captured from NetSuite can also record its sub-customers on the iPaaS.com company, each labeled with how it relates to the company (for example Authorized Buyer) from a NetSuite custom field you choose. A sub-customer not yet in iPaaS.com is imported automatically. Set it up in Recording a company's sub-customers in NetSuite Connections and Settings.
Clearer related-record messages: when a related customer or company cannot be imported first, the coded message now names that record.
Returns follow their order's customer: the return collections now identify a return's customer the same way as the Sales Order (company first, then customer, then email), so a return on a company order stays on the company. Existing subscriptions can update their mapping as described in Known Limitations.
Version 1.0.21 — Return custom fields
Return Authorization custom fields: transaction-body custom fields mapped on the return collections are set on the NetSuite Return Authorization when a return is created or updated.
Version 1.0.20 — Shipping-only returns
Shipping-only returns: a return that refunds only shipping, with no returned items, creates a Return Authorization carrying the shipping refund.
Version 1.0.18 — Coded error messages
Coded error messages: every error the integration can record in the iPaaS.com error logs now carries a stable, searchable code (for example
NETS-EXTN-1001) alongside its message, its cause, and a subscriber-actionable resolution. Search a code on the NetSuite Error Messages article to find exactly what it means and how to resolve it.
Version 1.0.17 — Location address capture and loop protection
Location address capture: a NetSuite location's main address — street lines, city, region, postal code, and phone — is captured onto the iPaaS.com location, with the country converted to the canonical iPaaS.com country name.
Sales Order loop protection: when iPaaS.com writes a Sales Order to NetSuite, NetSuite's own change notification is recognized as the integration's own write, so the order is not transferred back as a duplicate on bidirectional subscriptions.
Version 1.0.16 — Inventory poll-time control
Inventory Poll Time Adjustment: an optional setting shifts the inventory poll window to match the NetSuite account's time zone, so inventory changes are not missed when the transfer server and NetSuite differ.
Version 1.0.14 — Return handling controls
Return line exclusions: exclude specific items, by internal item ID, from the placeholder lines generated on an order return. Version 1.0.24 no longer generates placeholder lines, so the exclusion is no longer needed.
Version 1.0.13 — Sales Order discounts
Order-level discount line: an order's discount is written to NetSuite as a dedicated discount line that reduces the order total, reconciled in place on update.
Version 1.0.10 — Returns (RMA)
Return Merchandise Authorization: create and update Return Authorizations from a fulfilled originating Sales Order, with the returned quantities authorized as submitted and refunds processed in NetSuite.
Version 1.0.6 — Gift certificates
Gift certificate capture and redemption: capture NetSuite gift certificates, matched by code, and apply gift-certificate redemptions on transactions.
Version 1.0.3 — Customer payments and query support
Customer payments: apply a customer payment against an existing NetSuite invoice.
Invoice validation: captured invoices are validated against their originating order before they are brought across.
SuiteQL-based retrieval: resolve records, variants, and product options during transfers using NetSuite SuiteQL queries.
Version 1.0.2 — Invoice capture
Invoice capture: capture NetSuite invoices into iPaaS.com.
Version 1.0.0 — Initial release
Established the core synchronization between iPaaS.com and NetSuite over OAuth 2.0, across the following. Each of these carries its full detail:
Customers (both captured from and written to NetSuite) and companies (captured and written): including customer and company addresses, relationships, and pricing categories.
Products across every NetSuite item type — inventory, assembly, non-inventory sale and resale, and service sale, resale, and purchase items — including options, option values, variants, units, and related products, plus writing items and inventory back to NetSuite.
Reference data: locations, payment methods, shipping methods, product categories, customer categories and price levels, and alternate ID types.
Sales Orders (written to and captured from NetSuite): including order lines, addresses, taxes, and payments.
Cash sales and cash refunds: point-of-sale financial transactions written to NetSuite.
Employees and time bills: workforce data written to NetSuite, for example from a payroll system.
