Syncing the NetSuite internal ID for products from NetSuite ensures that subsequent product dependent syncs like order, transfer shipment, and cycle counts are always successful. Trying to reliably use a well known name of products like SKU or UPC, often leads to conflicts with customizations of the CSV import forms in NetSuite. To avoid having to handle these custom identification formats for each deployment, HotWax syncs NetSuite’s internal product ID.

To get NetSuite’s internal product ID, it requires a schedule suite script to export product ID

SuiteScript name: HC_SC_GenerateProductCSV.js

A schedule suite script will then put this export product IDs on the SFTP location for OMS to consume

SuiteScript name: HC_SC_GenerateProductCSV.js

SFTP Location: /home/{sftp-username}/netsuite/product/csv

To import product in OMS, a import job need to be configured in OMS with recommended frequency 1 hour

Config ID: IMP_PROD_IDENT

Job name: Product Identification

NetSuite is often the system of record for inventory at all locations. The OMS usually syncs a full inventory reset from the OMS once a day. This requires a scheduled export from NetSuite and an import job into the OMS be scheduled.

To learn more about the inventory sync integration with NetSuite read the full documentation

Generate inventory items from NetSuite

HC_generateCSV_InventoryItems

Place inventory items at SFTP

HC_uploadCSV_InventoryItems

Import inventory into HotWax

Import inventory
FTP Config: RESET_INVENTORY