Fulfillment
Learn how fulfillment information is synchronized between NetSuite and HotWax Commerce, ensuring accurate order status updates and financial processing.
Fulfillment in NetSuite
When a warehouse fulfills order items in NetSuite, fulfilled order information is synchronized from NetSuite to HotWax Commerce. This synchronization step ensures that orders marked as "fulfilled" in NetSuite are accurately reflected in HotWax Commerce. It ensures that the order status is consistent and updated across both systems.
Actions
A Map Reduce SuiteScript generates a CSV file containing fulfilled orders and places it at an SFTP location.
SuiteScript
SFTP Locations
A scheduled job within HotWax Commerce Integration Platform reads and transforms this CSV file into the JSON format so that OMS can consume this file. This JSON file is then placed at an SFTP location.
A scheduled job within HotWax Commerce OMS reads this JSON file from the SFTP location, marking order items as fulfilled in HotWax Commerce.
Job in HotWax Commerce
Fulfillment in HotWax
The primary difference in this context is the approach to sending fulfillment location data from HotWax Commerce to NetSuite.
While fulfillment locations are indeed transmitted to NetSuite after in-store orders are fulfilled within HotWax Commerce, it's important to understand that this data transmission isn't critical for the actual fulfillment of orders. The fulfillment location data is conveyed to NetSuite once orders are fulfilled within HotWax Commerce. Its significance lies in enabling the subsequent creation of invoices, the application of payments to these invoices, and the accurate marking of orders as completed within the NetSuite system. This step occurs post-fulfillment in HotWax Commerce to ensure proper financial processing and completion of orders in NetSuite.
Actions
A scheduled job within HotWax Commerce Integration Platform retrieves fulfilled order items and creates a feed of outbound shipments as a JSON file and places it at an SFTP location.
to be added
A Scheduled Script in NetSuite reads this JSON file from the SFTP location, allocating locations to the orders within NetSuite by updating order records. Additionally, it creates fulfillment records in NetSuite based on the HotWax Commerce shipment data using the N/Record module of NetSuite.
SuiteScript
SFTP Locations
Upon completion of this process, the orders transition to "pending_billing" status, signifying that they are fulfilled and ready for billing.
The HC_SC_CreateItemFulfillment SuiteScript also generates a CSV file highlighting erroneous records found during processing and uploads the file to the SFTP server. Simultaneously, an email alert is automatically triggered to designated personnel, helping them quickly pinpoint the source of the issue and accelerating troubleshooting.
Overall sync progress
Order fulfillment is completed and now the only step remaining is invoicing.
Last updated
