NetSuite Item to Commerce Cloud Product Add/Update

The data flow 'NetSuite Item to Commerce Cloud Product Add/Update' enables you to automatically export your product catalog from NetSuite to Commerce Cloud. This data flow enables you to manage your listings directly from within NetSuite and keep the product data in sync with Commerce Cloud. The data flow can be set up to pick up newly created items (in NetSuite) as well as updates to already linked items and export them to Commerce Cloud. Currently, the flow supports export of Inventory items and Matrix items. This topic provides information about export of simple inventory items.

Process: The connector (automatically or on scheduled basis) pulls NetSuite Item information and moves it into a Celigo Container (folder) within Cloud Commerce (impex/src/celigo). A job Scheduler within Cloud Commerce then moves the Item information to the backend site and the storefront. The job scheduler can be automated to run at certain frequencies or maybe triggered manually. The steps are elaborated below:

Steps: (refer screens below)

1. Create Item in NetSuite (and set up mandatory Celigo custom fields)
2. Run Product data flow in the connector
3. Run Catalog Job Scheduler in Commerce Cloud 
4. Verify Item info in Commerce Cloud site backend and storefront

Step 1: Create Item in NetSuite.

Celigo custom fields must be set up in NetSuite when creating a new item.

Settings in NetSuite: Go to the item creation page. In the eTail sub section, set up the following fields.

• ETail Channel: Select 'Salesforce Commerce Cloud'
• SCC Catalog Id: Select appropriate Catalog id (as set up in Commerce Cloud)
• SCC Primary Category: Select appropriate Category (as set up in Commerce Cloud)

Step 2: Next, run the Product data flow in the connector. Click Play button. Before running the flow, select and save the (Item Export) Saved Search in the Advanced Settings section.

The connector dashboard provides the status of the flow.

Once the flow is successful, the Item data moves into Cloud Commerce and resides in the Celigo Container (impex/src/celigo: Catalog folder).

Open the Catalog folder to view the Item file (in xml format). Files containing errors are created in the errored files folder. Next, run the appropriate job scheduler (Catalog) from the Admin section to create the product in the storefront and site backend.

Step 3: Go to Administration >Job Schedules. Run the Catalog Job Scheduler in Cloud Commerce Cloud. 

The Job Schedules section displays the list of Celigo Job schedules. Locate Celigo Catalog Import schedule. Select the checkbox and Run the flow as shown. When the job schedule is successfully completed (displays ‘OK’ mark), verify that the product is visible in the backend or storefront.

Step 4: Verify that the Item is created and is visible in the Commerce Cloud site backend and storefront. The following sample screen depicts items displayed in the Products list.