NetSuite commerce provides eCommerce and point-of-sale solutions all in one.
In this article
Overview
-
The NetSuite E-commerce connector is primarily used when you are pulling orders from NetSuite to be sent out to fulfillment channel(s)
- Supported flows:
- Pull sales orders OR item fulfillments from NetSuite
- Push item fulfillments to NetSuite from fulfillment channel
- Pull product catalog from NetSuite
- Push inventory to NetSuite
- Pull locations from NetSuite
- Pull transfer orders from NetSuite
- Push transfer order receipts to NetSuite
- Pull purchase orders from NetSuite
- Push purchase order receipts to NetSuite
- Note: there is another connector called NetSuite ERP, which is primarily used for pushing orders INTO NetSuite from selling channel(s). This use case requires some more advanced setup. Work with your Pipe17 rep to get this going!
- Support flows for NetSuite ERP connector:
- Push Sales Orders + Customer Deposits AND/OR Cash Sales into NetSuite from selling channel(s)
- Pull inventory from NetSuite
- Pull fulfillments from NetSuite
- Support flows for NetSuite ERP connector:
- Flow example - NetSuite Ecommerce:
- Flow example - NetSuite ERP:
Getting Started
- Ensure that you have a Pipe17 account. If you do not yet have a Pipe17 account, book a demo with a Pipe17 team member to get started.
- Make sure you are licensed to use the Pipe17 NetSuite ERP Connector. If you're not certain, reach out to your Pipe17 onboarding manager or contact our sales team to ensure you are ready to begin setup.
- Follow the steps below to add your connectors.
Configure NetSuite & Fulfillment Channel
- Add the NetSuite connector
- Go to the "Integrations" tab on the left side of your Pipe17 portal, and click "Add Integration"
- Select the NetSuite E-commerce connector
- Input your credentials (follow the steps HERE)
- Once credentials are successfully entered, and the connector status shows "Connected" click over to the "Settings" tab within the connector. Step through the numbered steps below
- Sync products from NetSuite to Pipe17
- Enable the settings called "Pull products to Pipe17 (full catalog sync)"
- Products will begin to sync to Pipe17 and can be viewed from the Products tab in your portal
- Products must exist in Pipe17 before orders can be ingested into Pipe17 and sent to a fulfillment channel
- Configure the fulfillment connector
- If you are planning on sending a test order from NetSuite to a fulfillment channel, configure the fulfillment channel now
- Enable the setting for "Send Shipping Requests" to allow the orders from NetSuite to sync to the fulfillment channel once you've completed the other setup steps
- Validate that inventory has synced from the fulfillment connector into Pipe17 successfully
- Inventory should display correctly in the Pipe17 Inventory > All Inventory tab
- Make sure to link the NetSuite location to the fulfillment connector's location in the Inventory tab > Locations list. Do this by editing the NetSuite location and merging to the fulfillment locations
- Set up order routing
- If you would like to respect the location NetSuite has assigned to a Sales Order, then enable the setting by going to Integrations tab > Automations: Order Routing Engine > "Create Shipping Request for Pre Routed Orders/Items". This will automatically generate a shipping request to the linked location when an order is ingested to Pipe17 from NetSuite
- If you would like to set up order routing rules in Pipe17 instead (and ignore the location provided by NetSuite), go to the Configuration tab > Order Routing and set up logic here for automatic order routing in Pipe17
- Pull Sales Orders from NetSuite to Pipe17
- Ensure correct field mapping is used so that Order ID and Order Source match up with original order from the selling channel. Go to the "Entities" tab of the connector, select Entity = Orders: From NetSuite and set the target fields "External Order ID" and "Order Source" like below:
- Request help from Pipe17 if a custom field mapping is required:
- Ensure correct shipping methods are setup in NetSuite & the fulfillment channel
- Enable the setting in the NetSuite Ecommerce connector for "Pull Sales Orders to Pipe17" to allow orders to sync
- Use the setting "Sales Order filter" to filter to just the orders you need to ingest from NetSuite to be fulfilled i.e. filter by location/status/subsidiary etc. Use the "?" icon to see all filtering options
- Orders will sync to Pipe17 based on these settings, and automatically route based on routing configuration
- Ensure correct field mapping is used so that Order ID and Order Source match up with original order from the selling channel. Go to the "Entities" tab of the connector, select Entity = Orders: From NetSuite and set the target fields "External Order ID" and "Order Source" like below:
- Enable fulfillments to sync back to NetSuite
- Enable the setting "Create Item Fulfillments in NetSuite from Pipe17 (3PL)" to allow fulfillments and tracking numbers to sync back to NetSuite once an order is fulfilled
- Enable inventory to sync to NetSuite
- Enable the setting "Push inventory updates to NetSuite" to create inventory adjustments in NetSuite to reflect any inventory differences shown in the fulfillment location
- Update the mapping to use your desired inventory adjustment account by going to the Entities tab > Entity: Inventory > Onto NetSuite E-commerce > Adjustment account section
Testing
- Add a new product in NetSuite, confirm the product gets created automatically in Pipe17
- When inventory becomes available in the fulfillment location, confirm inventory reflects accurately in Pipe17
- Adjust inventory in Pipe17, confirm an inventory adjustment gets created automatically in NetSuite
- Create an order in NetSuite, confirm order gets created automatically in Pipe17
- Confirm shipping request gets created automatically (based on order routing setup) against the order in Pipe17
- Confirm order gets created automatically in fulfillment system
- Once order is fulfilled, confirm fulfillment syncs to Pipe17
- Confirm fulfillment syncs to NetSuite
Comments
0 comments