Store to Store
Last updated
Last updated
Stores looking to transfer surplus inventory to another store in need of it work alongside the warehouse manager to create a store-to-store transfer order in NetSuite. This facilitates the transfer of inventory from one store location to another.
Now, let’s look at how store to store transfer orders are processed:
Warehouse managers create transfer orders in NetSuite, specifying the source location as the designated store and the destination location as also a store. These transfer orders are automatically assigned a Pending Fulfillment
status.
These transfer orders are synchronized to HotWax Commerce so that they can be fulfilled from stores. Once transfer order items are shipped from stores, their status is updated from Approved
to Completed
and subsequently inventory count for the shipped items is reduced in HotWax Commerce.
The transfer order items shipped from the store are synchronized to NetSuite and the corresponding item fulfillment records are generated and marked Shipped
in NetSuite. This step also ensures that inventory counts for the corresponding items are automatically reduced in NetSuite and the transfer order status is updated from Pending Fulfillment
to Pending Receipt
.
These item fulfillment records are synchronized to HotWax Commerce and inbound shipments are automatically created so that the store can receive the transferred inventory. When the store associates verifies the inbound shipments and receives them, inventory counts for the corresponding items are automatically increased in HotWax Commerce.
Upon successful receipt of inventory, HotWax Commerce synchronizes item receipts with NetSuite. This ensures that the inventory count at store is accurately increased in NetSuite and the status of transfer orders status is updated from Pending Receipt
to Received
.
Export Created Transfer Orders from NetSuite:
Warehouse managers create transfer orders in NetSuite, specifying the source location as the designated store and the destination location as also a store. These transfer orders are automatically assigned a Pending Fulfillment
status.
At regular intervals, a Map Reduce script runs a specific Saved Search in NetSuite and identifies transfer orders with a Pending Fulfillment
status that have a source location set as the Store
. This script compiles the relevant data into a CSV file, which is then securely placed at an SFTP location.
SuiteScript
Export Transfer Orders to SFTP
SFTP Location
Import Transfer Orders into HotWax Commerce:
Once the store to store transfer orders are created and exported from NetSuite, they are imported into HotWax Commerce.
The process of approving transfer orders in HotWax Commerce, fulfilling them from the designated store location, reducing inventory counts in HotWax Commerce for fulfilled transfer order items, exporting store fulfilled transfer order items from HotWax Commerce and finally importing them into NetSuite mirrors the store to warehouse transfer order flow discussed earlier.
Job in HotWax Commerce
Import Transfer Orders from SFTP
Approve Transfer Orders
Export Fulfilled Transfer Order Items to SFTP
SFTP Location
SuiteScript
Import Fuflilled Transfer Order Items from SFTP
Generate Item Fulfillment Records in NetSuite:
Once fulfilled transfer orders are imported into NetSuite, item fulfillment records are generated and are automatically marked “Shipped”. Whenever an item fulfillment record is marked “Shipped”, the inventory count for corresponding items is reduced in NetSuite. These records signify that the destination store location can now start receiving the transfer order items.
A Map Reduce script runs a specific Saved Search to identify item fulfillment records in Shipped
status, where both the source and destination locations are Store
locations. Subsequently, the script compiles the relevant data into a CSV file, which is securely placed at an SFTP location.
SuiteScript
Export Item Fulfillment Records to SFTP
SFTP Location
Receive Transfer Orders in HotWax Commerce:
The process of importing item fulfillment records in HotWax Commerce, receiving inbound shipments in the store, increasing inventory counts in HotWax Commerce against inbound shipments, exporting item receipts from HotWax Commerce, importing item receipts into NetSuite and finally increasing inventory count at store in NetSuite mirrors the warehouse to store transfer order flow discussed earlier.
Job in HotWax Commerce
Import Item Fulfillment Records from SFTP
Export Item Receipts to SFTP
SFTP Location
SuiteScript
Import Item Receipts from SFTP
Following this approach, store associates at the destination store can efficiently receive inbound shipments at their store, synchronize the item receipts with NetSuite, and ultimately mark the completion of store to store transfer orders, with the transfer order status updating in NetSuite from Pending Receipt
to Received
.
Here's how transfer order fields are mapped in NetSuite and HotWax Commerce for store fulfillment:
Here's how transfer order fields are mapped in NetSuite and HotWax Commerce for receiving in store:
S.No. | Fields in NetSuite | Fields in HotWax Commerce |
---|---|---|
S.No. | Fields in NetSuite | Fields in HotWax Commerce |
---|---|---|
1
Internal ID
External ID
2
Transfer Order Name
Transfer Order Name
3
Date
Date
4
Item
Product
5
Quantity
Qty
6
Source Location
Ship From
7
Destination Location
Ship To
8
Shipping Address
Ship To Address
9
Shipping Method
Shipping Method
1
Item Fulfillment Internal ID
External ID
2
Transfer Order Name
Transfer Order Name
3
Items
SKU
4
Quantity
Ordered Quantity
5
Destination Location
Facility
6
Tracking #
Tracking ID