Getting Started with Netsuite
How to pair Connex Ecommerce and Netsuite
What touchpoints are available?
Here is a list:
- Two way order sync: We can sync sales to and from Netsuite
- Two way customer sync: If customers do not exist in Netsuite, Connex will create them.
- Two way product sync: We can sync stock updates from Netsuite to a 3rd party system.
How do I pair Netsuite?
Connex Ecommerce uses ApiDeck as middleware. Sales flow from your selling channel, through Connex, then ApiDeck and to Netsuite. To pair Connex, follow these steps:
- Login to Connex Ecommerce.
- Go to add selling channel on our dashboard.
- Add a channel.
- On the next page, choose other.
- Choose Netsuite.
- Please read this guide on obtaining Netsuite credentials for Connex.
- In Connex, complete the form in the Netsuite dialog.
Can I map custom fields?
You must find the custom field ID in Netsuite, then create a Connex rule.
To find the custom field ID in Netsuite, follow these instructions:
Option A - NetSuite UI: Go to Customization > Lists, Records, & Fields > Entity Fields (or Transaction Body Fields / Transaction Column Fields depending on the field type). The ID column shows the script ID (e.g., custbody_project_code), and the internal ID is shown in the Internal ID column (you may need to enable this column in View > Set Preferences).
In Connex, add a rule. In this example, we will map the order number to a field called custbody_project_code
- Login to Connex Ecommerce.
- Go to rules engine.
- Click add new rule.
- Scroll down and select add rule without order number.
- Add these vales:
- Title is map custbody_project_code
- Action is map custom field
- Conditions: Order number, map all, custbody_project_code
- Value to change: custbody_project_code
How do fields map?
| Netsuite | Connex | Notes |
| Bill To | Customer name or company | |
| Ship To | Ship to address | |
| Customer name and Email | Customer name and email | We can match customers by company or customer full name. |
| Order Date | Order Date | |
| Due Date | Due Date | |
| Reference | Order Number | |
| Amount Due | Amount Due | Connex can mark orders as paid or unpaid. |
| Item ID | Product SKU | |
| Item Quantity | Quantity | |
| Item Price | Item Price | |
| Order Discount | Order Discount | Connex can add a single or multiple discounts to a sale. |
| Shipping Amount | Shipping Amount | |
| Shipping Method | Shipping Method | |
| Customer Note | Customer Note | i.e. Thanks for doing business |
| Private Note | Private Note | i.e. Please ask Joe to ship this order early. |