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.
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 (inventory, non-inventory, assembly, kit, and service items) | |
Product Inventory | ←→ | Inventory / Inventory Adjustment | |
Product Variant Inventory | ←→ | Matrix item inventory | |
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. Returns (RMA) were added in version 1.0.10 — see Features by Release below.
Versions and Release Notes
Version | Release Notes |
1.0.17 (current) | 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.17.
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.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.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.