NetSuite as a Channel
Summary
NetSuite as a channel in Flxpoint lets you sync and link product listings, pull Purchase Orders and Sales Orders from NetSuite into Flxpoint, and push shipment data back. Because NetSuite is an ERP rather than a marketplace, the connection uses Token-Based Authentication (TBA) - an Account ID plus a consumer key/secret and access token/secret that must be configured in NetSuite first.
Go to Channel → + Add Channel, search NetSuite, choose NetSuite Purchase Order, then enter these on the connection screen. Click Test Connection → Save Connection.
| Field | What to enter |
|---|---|
Connection NameSetting | A label you choose to identify this NetSuite connection inside Flxpoint.
Any name; used only within Flxpoint. |
Client ID / Client SecretRequired | The consumer key and consumer secret from your NetSuite integration record, created when you enable Token-Based Authentication in NetSuite.
Generated in NetSuite on the integration record - not issued by Flxpoint. |
NetSuite Store ID (Account ID)Required | Your NetSuite Production Account ID. Enter it here to target Production.
Must match your NetSuite environment exactly. |
Token ID / Token SecretRequired | Your Token-Based Authentication access token and secret, generated in NetSuite via the Settings portlet → Manage Access Tokens → New My Access Token (choose your Integration and role, then Save).
Copy the Token ID and Token Secret at creation time - the secret is shown only once. |
Sandbox Store IDOptional | Your NetSuite Sandbox Account ID. Leave blank to target Production; enter a value to point the connection at Sandbox instead.
Leave empty for Production. |
Four NetSuite SuiteCloud features must be enabled before connecting
In NetSuite go to Setup → Company → Enable Features → SuiteCloud and confirm all four are active: SuiteScript, SuiteTalk (Web Services), REST Web Services, and Token-Based Authentication. Connecting without these enabled causes authentication errors that are easy to misread as credential problems.
Get Orders filters by creation date only - no custom-field filters by default
The standard NetSuite PO query filters by createdDate, pulling all POs created after the configured date. To restrict by a custom field (e.g. custbody_ready_for_flxpoint = true) or by lastModifiedDate, contact Flxpoint support - this needs a custom query configuration and is not a self-service setting.
FFL expiration date fails if NetSuite exposes it as a string, not a date field
If NetSuite returns the FFL expiration as plain text rather than a date/datetime field, Get Orders fails with a "provided string value" error on Expires At. Use the Custom FFL Number + Derived FFL Expiration Date From FFL Number mapping fields with derivation rules, or ask your NetSuite admin to expose the field as a proper date type.
PO-SO linking requires the correct PO Item Association Key
For Send Accounting to match Purchase Orders to their originating Sales Orders, set the PO Item Association Key in Flxpoint to the exact NetSuite custom transaction column that links PO lines to SO items (e.g. custcol_mt_linked_po). An incorrect or missing key causes Send Accounting jobs to fail with association errors.
Syncs quantity, price, custom fields and variant attributes to NetSuite and links products to their NetSuite items
Pulls Purchase Orders and/or Sales Orders from NetSuite into Flxpoint, saving order and item IDs to keep future syncs aligned
| Field | Notes |
|---|---|
| Purchase Orders / Sales Orders | Download POs and/or SOs; order & payment statuses, receipts/invoices, currency, and weight & dimensions come across. Fetches are filtered by creation date from the Get Orders settings, and order & item IDs are saved to keep future syncs aligned. |
Custom fields (custbody_*) | Map NetSuite order custom fields (e.g. custbody_*) to Flxpoint order fields as needed. |
| Custom FFL Number | String. Map to the NetSuite custom field holding the FFL licence number; Flxpoint applies rule logic to derive the expiration year and month from the licence characters (typically characters 9-10). |
| Derived FFL Expiration Date From FFL Number | Date. Stores the derived FFL expiration as a proper Date value, regardless of how NetSuite exposes the original field. For Palmetto-style tenants the value is retrieved via SuiteQL so it arrives in the correct format. |
| PO Item Association Key | For Send Accounting, set to the exact NetSuite custom transaction column that links each PO line to its SO item (e.g. custcol_mt_linked_po) so each PO matches its originating SO. One Sales Order can have multiple Purchase Orders. |
| Not supported | Order acknowledgement, shipping selection, digital items/donations, and FFL/expiration values NetSuite exposes only as plain text (not date/datetime). |
Pushes shipment and tracking data back to NetSuite at the item level
"Invalid login attempt" or authentication error when creating the NetSuite connection
Price not syncing from Flxpoint to NetSuite - NetSuite shows outdated prices
"Unable to parse value '11.62' (String) from the Number field (custbody_ca_tax_cost)"
custbody_ca_tax_cost) is mapped as a numeric type, not text. For calculated or formula fields, confirm the output type matches the NetSuite field's data type."There are multiple sublist lines with the same identifier. Make sure every line is unique."
"Failed to send sales order to NetSuite. Reason: 500 Internal Server Error: UNEXPECTED_ERROR"
mmpb2najdc01a6c2sw2u) lets a NetSuite admin look up the exact cause in the NetSuite system log - common causes include a SuiteScript firing on the record and failing, a required field missing on the order, or a scripting conflict. Share the error ID with your NetSuite admin or implementation partner to diagnose on the NetSuite side.Shipment sync error: "404 Not Found: [no body]" or "Index 0 out of bounds for length 0"
Integration job automatically paused or terminated?
Job failures due to NetSuite maintenance or quota limits (503 errors)
Error while accessing a resource. Please choose an item to add. (During Send Invoice)
Shipping Label cannot be purchased without all required dimensions and weight information
How do I filter which NetSuite POs Flxpoint imports?
Can I push variant descriptions and custom fields to NetSuite through listing sync?
custitem_jcs_variantdescription) to the corresponding NetSuite item fields in the Sync Listings mapping template. Parent and variant fields can be mapped independently.