Salesforce Commerce Cloud (FTP) – NetSuite integration template

The Salesforce Commerce Cloud (FTP) – NetSuite integration template prebuilt integration flows let you automate and synchronize items, price books, item inventories, orders, fulfillments, cancellations, and refunds between Salesforce Commerce Cloud and NetSuite. 

Supported integration flows

The Celigo quickstart bundle contains workflows you can easily configure and deploy without coding or IT support. The following built-in flows sync from the specified source data to the corresponding destination.

NetSuite to Salesforce Commerce Cloud (FTP)

Salesforce Commerce Cloud (FTP) to NetSuite

Gather your credentials

Keep your Salesforce Commerce Cloud (FTP) and NetSuite account credentials ready:

• Salesforce Commerce Cloud (FTP) – verify APIs and Authorization
  • Before you set up an FTP connection below, ensure that you have the API and authentication details for your Salesforce Commerce Cloud (FTP) app. 
• NetSuite – verify APIs and Authorization
  • Before you set up a NetSuite connection below, ensure that you have the API and authentication details for your NetSuite app. 
  • Refer to the NetSuite help documentation to learn more about APIs and Authorization. 

Install the Salesforce Commerce Cloud (FTP) – NetSuite template

1. From the FTP Marketplace options, select the NetSuite template and click Preview.
2. Review the template’s contents and ReadMe and click Install now to begin.
3. Add your credentials and install the NetSuite integrator.io bundle.
4. Install the template. 

Install NetSuite custom bundle (422784)

After installing the Salesforce Commerce Cloud (FTP) – NetSuite template, you must install the NetSuite custom bundle (ID 422784) in NetSuite:

1. Sign in to your NetSuite account.
2. From the Customization menu, select Suite bundler > Search and install bundles.
3. Enter the bundle ID 422784 into the Keywords field, and click Search.
4. Select this bundle, and click Install.

Configure the Salesforce Commerce Cloud (FTP) – NetSuite flows

Additional record mapping is required to integrate the template’s exports and imports with your  Salesforce Commerce Cloud (FTP) and NetSuite apps.

Note that all of your flows are disabled when first installed. After configuring the flows, you may enable them in your Flows dashboard or Flow Builder with the Off/On toggle button and then run or schedule each flow. 

NetSuite customer refunds to Salesforce Commerce Cloud refunds

This integration flow syncs NetSuite customer refunds with the Salesforce Commerce Cloud refunds. When a refund is added in the NetSuite, this integration flow exports refunds from NetSuite to Salesforce Commerce Cloud refunds.

NetSuite inventories to Salesforce Commerce Cloud item inventories

This integration flow syncs NetSuite inventories with the Salesforce Commerce Cloud item inventories. When an inventory is added in the NetSuite, this integration flow exports inventories from NetSuite to Salesforce Commerce Cloud item inventories.

NetSuite items to Salesforce Commerce Cloud items

This integration flow syncs NetSuite items with the Salesforce Commerce Cloud items. When an item is added in the NetSuite, this integration flow exports items from NetSuite to Salesforce Commerce Cloud items.

Setup instructions

Configure the mapping for isMonogram, specialPricingItem, discountExclude, oversizedItem, shipToCanada, ClearanceItem, CannotShiptoCA, CannotShiptoOR, CannotShiptoME, CannotShiptoWA, CannotShiptoVT, webLTLItem, excludeFreeShipping according to your business requirements in Import Salesforce Commerce Cloud items, before running the flow.

NetSuite price books to Salesforce Commerce Cloud price books

This integration flow syncs NetSuite price books with the Salesforce Commerce Cloud price books. When a price book is added in the NetSuite, this integration flow exports price books from NetSuite to Salesforce Commerce Cloud price books.

NetSuite sales orders cancellations to Salesforce Commerce Cloud orders cancellations

This integration flow syncs NetSuite sales order cancellations with the Salesforce Commerce Cloud order cancellations. When a sales order cancellation is added in the NetSuite, this integration flow exports sales order cancellations from NetSuite to Salesforce Commerce Cloud orders cancellations.

Before you begin

• The NetSuite sales orders and Salesforce Commerce Cloud orders should be the same.
• The NetSuite Items and Salesforce Commerce Cloud items should be the same.

Setup instructions

Configure mapping for order status.

NetSuite sales orders to Salesforce Commerce Cloud orders

This integration flow syncs NetSuite sales orders with the Salesforce Commerce Cloud orders. When a sales order is added to the NetSuite, this integration flow exports sales orders from NetSuite to Salesforce Commerce Cloud orders.

NetSuite shipments to Salesforce Commerce Cloud fulfillments

This integration flow syncs NetSuite shipments with the Salesforce Commerce Cloud fulfillments. When a shipment is added to the NetSuite, this integration flow exports shipments from NetSuite to Salesforce Commerce Cloud fulfillments.

Setup instructions

Configure mapping for order status.

Salesforce Commerce Cloud cancellations to NetSuite sales order cancellations

This integration flow syncs Salesforce Commerce Cloud cancellations with the NetSuite order cancellations. When an order cancellation is updated in the Salesforce Commerce Cloud, this integration flow exports cancellations from Salesforce Commerce Cloud to NetSuite sales order cancellations.

Before you begin

• The NetSuite sales orders and Salesforce Commerce Cloud orders should be the same.
• The NetSuite Items and Salesforce Commerce Cloud items should be the same.

Setup instructions

Configure dynamic mapping for items according to your business requirements in Import NetSuite sales order, before running the flow.

Salesforce Commerce Cloud orders to NetSuite sales orders

This integration flow syncs Salesforce Commerce Cloud orders with the NetSuite sales orders. When an order is added/ignored in the Salesforce Commerce Cloud, this integration flow exports orders from Salesforce Commerce Cloud to NetSuite sales orders.

Setup instructions

1. Add subsidiary mapping according to your business requirements in Import NetSuite customers and Import NetSuite inventories, before running the flow.
2. Configure the following static mapping according to your business requirements in Import NetSuite sales orders, before running the flow.

   Source record field (FTP)	Destination record field (NetSuite)
   currency	Currency (InternalId)
   payments.payment.credit-card.card-type	paymentmethod.internalid
   shipments.shipment.shipping-method	Ship Via (InternalId)
   status.order-status	Status (InternalId)

3. Configure the mapping for Individual according to your business requirements in Import NetSuite customers, before running the flow.
4. Configure the following mapping according to your business requirements in Import NetSuite sales orders, before running the flow.