Sync Customer

Explore the synchronization process of customer data between HotWax Commerce and NetSuite.

If the order contains a new customer not present in Netsuite, the system won't allow the order to be pushed. Therefore, it's vital to synchronize customer data from HotWax Commerce to Netsuite before order creation.

Historical Customers

If HotWax is being deployed in an environment where NetSuite already has a historical record of customers from Shopify and their Shopify internal ID, these need to synced into the OMS before orders can be synced.

Duplicate customers will be created in NetSuite and HotWax if this sync is not completed before order import.

SuiteScript to run manually to export all existing customers in NetSuite and their Shopify ID

Generate CSV

HC_SC_GenerateHistoricalCustomerCSV

Move to SFTP

HC_SC_UploadHistoricalCustomerCSV

SFTP Locations

/home/{sftp-username}/netsuite/historicalshopifycustomer/csv

Job to import historical customers into HotWax with both a NetSuite and Shopify identification to avoid duplicate customers.

Import Historical Shopify Customers

Export customers from HotWax

Scheduled job in HotWax Commerce generates a CSV file comprising customers who have not been synchronized to Netsuite.

This job is scheduled in the integration layer and not executed natively in the OMS.

To change this job's frequency, connect with the integration team.

SFTP Location

/home/{sftp-username}/netsuite/customer/export

Import customers into NetSuite

Schedule the following SuiteScript to export a feed of recently created customers from NetSuite

HC_SC_ImportCustomer

Export customer IDs from NetSuite

Schedule this SuiteScript to export a file of recently created customers in NetSuite.

HC_MR_ExportedCustomerCSV

Verify that the generated file is placed at this SFTP Location

/home/{sftp-username}/netsuite/customer/import/

Import NetSuite Customer into HotWax

Enable this job in HotWax Commerce to consume the file generated by HotWax

Import Party Identification
FTP Config: IMP_PARTY_IDENT