Connect NetSuite to Amazon MCF

This document contains instructions to configure and connect the NetSuite E-commerce connector with the Amazon MCF connector within Pipe17.

Note: There are two separate NetSuite connectors in Pipe17. The NetSuite E-commerce connector is to be used for this use case, which allows orders to be pulled from NetSuite and sent to MCF for fulfillment. 

In this article

• Getting Started
• Configure NetSuite & MCF
• Testing

Getting Started

• Pipe17 Account - 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.
• Once your logged into your Pipe17 account, follow the steps below to add your NetSuite and Amazon MCF connectors.

Configure NetSuite & MCF

1. 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 
2. 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 sent to fulfillment
3. Add the Amazon MCF connector
   • Go to the "Integrations" tab on the left side of your Pipe17 portal, and click "Add Integration"
   • Select the Amazon MCF connector

     • Do not confuse the MCF integration with the Seller Central integration. The Seller Central integration is for pulling Amazon orders into Pipe17, not fulfilling them. For fulfilling your Shopify orders, you need to add the Amazon MCF connector.

     • If you have access to multiple Seller Central accounts, make sure you are logged into the correct one. Click the "Connect" button, and if prompted, log into the Amazon Seller Central account you want to connect.
     • A Seller Central window will open in your browser, prompting you to Authorize Pipe17. Click "Confirm" to give Pipe17 the requested Amazon Seller Central Account permissions.
   • In Pipe17, click on the "Settings" tab of the Amazon MCF Integration and turn on the following settings:
     
     • Pull Locations from Amazon
     • Pull Fulfillment Information from Amazon
     • Pull Inventory Information from Amazon
     • Push Shipping Requests to Amazon
     • Ensure correct Shipping Methods are mapped in the Shipping Requests section. Input the NetSuite value if you would like to map that to the equivalent MCF option
     • See additional configuration steps HERE for more in-depth explanation of the different settings
4. Validate that inventory synced from MCF to Pipe17 successfully
   • Inventory should display correctly in the Pipe17 Inventory > All Inventory tab
   • Make sure to link the NetSuite location to the MCF location in the Inventory tab > Locations list. Do this by editing the Amazon.com (MCF) location and adding in the NetSuite location internal ID to the External Locations at the bottom
5. 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 <COMPANY NAME> tab > Order Routing and set up logic here for automatic order routing in Pipe17
6. Pull Sales Orders from NetSuite to Pipe17
   • 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 by MCF i.e. filter by location/status/subsidiary etc. Use the "?" icon to see all filtering options and formatting required to use these
   • Orders will sync to Pipe17 based on these settings, and automatically route to MCF if successful
7. 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 by MCF
8. 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 MCF.
   • 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

1. Add a new product in NetSuite, confirm the product gets created automatically in Pipe17
2. Confirm inventory reflects accurately in Pipe17 from MCF
3. Adjust inventory in Pipe17, confirm an inventory adjustment gets created automatically in NetSuite
4. Create an order in NetSuite, confirm order gets created automatically in Pipe17
5. Confirm shipping request gets created automatically (based on order routing setup) against the order in Pipe17
6. Confirm order gets created automatically in MCF
7. Once order is fulfilled in MCF, confirm fulfillment syncs to Pipe17
8. Confirm fulfillment syncs to NetSuite