Documents
HomeGlossary
Learn NetSuite
Learn NetSuite
  • Introduction
  • Integration Tools and Methodologies
    • SuiteScript
      • N/Task Module
      • N/Record Module
      • N/Search Module
      • N/File Module
    • Saved Search
    • Integration Methodologies
    • NetSuite
    • HotWax
  • Integration Flows
    • Inventory
    • Sales Orders
      • Order Approval
      • Order Allocation
      • Fulfillment
      • Invoicing
      • Shipping Methods
      • Gift Card Orders
      • POS Orders
      • Send Sale Orders
      • Reports
    • Returns
    • Exchanges
    • Kit Products
    • Transfer Orders
      • Warehouse to Store
      • Store to Warehouse
      • Store to Store
      • Reports
    • Cycle Count
    • Purchase Orders
  • NetSuite Deployment
    • Deployment
    • SDF Bundle Setup
      • Install SDF
      • Setup SFTP
      • Date Time Format
    • Prerequisites
      • Install NetSuite Jobs
      • Product Store Settings
      • SFTP Locations
      • Historical Customers
      • Shipping Methods
      • Price Level
      • Payment Methods
      • Promo Codes
      • NetSuite Facility Group
  • Synchronization Flows
    • Auditing
    • Products and Inventory
      • Product IDs
      • Inventory Reset
    • Orders
      • POS Cash Sales
      • Sync Customer
      • Sync Order IDs
      • Approve Orders
      • Reports
    • Allocation & Fulfillment
    • Transfer Orders
    • Purchase Orders
    • Integration Mappings
      • Payment Methods
      • Discount Codes
      • Price Levels
      • Shipping Methods
      • Facility Group
  • Troubleshooting
    • Failed SuiteScripts
    • Error Logs
    • Failure Notifications
    • Order Sync Failure
Powered by GitBook
On this page
  • Order Rejection from NetSuite
  • Order Rejection from HotWax Commerce

Was this helpful?

Edit on GitHub
Export as PDF
  1. Integration Flows
  2. Sales Orders

Order Allocation

Learn how HotWax syncs order items allocated to stores and warehouses.

PreviousOrder ApprovalNextFulfillment

Last updated 3 months ago

Was this helpful?

After an order's items are allocated, the OMS begins syncing them to systems that are responsible for fulfillment of those items. When items are allocated to stores for fulfillment, they show up in the HotWax Store Fulfillment or BOPIS Apps.

If the facility where an item is allocated uses NetSuite for fulfillment, usually a warehouse, then the OMS syncs those items' allocation with NetSuite.

It's important to remember that if items are not allocated to a NetSuite Facility their allocation is not synced to NetSuite until after fulfillment is complete.

Actions

  1. A scheduled job in HotWax Commerce Integration Platform generates a CSV file containing order line items with their respective fulfillment locations and places this file at an SFTP location.

SFTP Location

/home/{sftp-username}/netsuite/salesorder/update
  1. A SuiteScript in NetSuite reads this CSV file from the SFTP location and updates fulfillment locations in sales orders by using the task.CsvImportTask of N/task module.

SuiteScripts

Import NetSuite fulfillment item allocations:

HC_SC_UpdateSalesOrders

Order Rejection from NetSuite

If a NetSuite fulfillment location cannot fulfill an order item that has been allocated to them, it is moved to a Rejected Orders facility. The Rejected Orders facility is an "undefined" type of facility, which means it is not mapped to a physical location. A SuiteScript periodically exports all the order items at this facility and places them at an SFTP location.

A scheduled job in HotWax Commerce imports this rejected order item feed and moves those items back to the brokering queue to be reallocated to a new facility.

SuiteScripts

HC_MR_ExportedRejectedSalesOrderItemCSV

SFTP Location

/home/{sftp-username}/netsuite/salesorder/rejectedorderitem

Job in HotWax Commerce

IMP_ORDER_ITM_RJCT

Order Rejection from HotWax Commerce

If an order is rejected from the HotWax Store Fulfillment App with a valid inventory issue reason, then inventory delta's are also pushed to NetSuite. These are the valid inventory variance reasons to be pushed to NetSuite:

  • VAR_STOLEN

  • VAR_DAMANGED

  • VAR_FOUND

SFTP Locations

Inventory variance of actual vs programmatic:

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

SuiteScripts

HC_SC_ImportInventoryAdjustment
196B
Brokered Order Items Sample Feed.csv
Items' allocations synced from HotWax Commerce to NetSuite