Web Returns with Loop
The Web Return Lifecycle BPM illustrates how returns are managed between RMS, eCommerce, ERP, and HotWax Commerce.
Last updated
The Web Return Lifecycle BPM illustrates how returns are managed between RMS, eCommerce, ERP, and HotWax Commerce.
Last updated
HotWax Commerce simply downloads completed returns for auditing purposes, ensuring reconciliation of returns in both Shopify and NetSuite. To explain the return lifecycle, we've taken Loop as the RMS, Shopify as eCommerce platform, and NetSuite as the ERP system, while HotWax Commerce serves as the OMS.
Loop lets customers directly initiate returns against their web orders. When customers complete initiating the return process, a Return Merchandise Authorization (RMA) is created in Loop in the "Open" status.
Loop updates the order details in Shopify by creating a return under order, reflecting that a return has been requested by the customer.
Many retailers use third-party integration apps like Novamodule to synchronize returns from Loop to NetSuite.
Loop generates the RMA in the "Pending Receipt" status in NetSuite using a third-party integration app. This gives the warehouse teams a heads-up that an order item will be coming back.
Customers print the shipping label provided by loop and prepare the return package to ship their return items back to the retailer so that they can receive a refund.
When the return package reaches the warehouse, the warehouse teams initiate receiving of the return item against the RMA and the following actions take place:
Item receipt records are created in NetSuite against the RMA, and the returned inventory is restocked.
The status of RMA is updated from "Pending Receipt" to "Pending Refund".
Now that the customer has shipped the return item back, its item receipt has been processed against the RMA in NetSuite, refunds should be processed to the customer.
Item receipt records created in NetSuite are synchronized to Loop using a third-party integration app. Consequently, return receipt records are generated in Loop. This means that refunds can now be initiated to customers.
Processing refunds to the customers marks the completion of returns. During this process, multiple actions take place in Loop, NetSuite, and Shopify. Let’s understand them:
Return receipt records trigger the creation of refund records in Loop. Once refund records are created, Loop creates a credit memo in “Open” status using a third party integration app. Creating credit memo marks the completion of RMA in NetSuite, with its status updating from “Pending Refund” to “Refunded”.
Loop also creates a customer refund record to reflect that the customer has received the refund against the credit memo and then the status of the credit memo is updated from “Open” to “Fully Applied”.
The creation of refund records in Loop also marks the completion of RMA in Loop, with its status updating from "Open" to "Closed".
Return receipt records in Loop triggers the refund process on Shopify and refunds are then issued to the customer. This marks the completion of return in Shopify, with the creation of payment records in "Refunded" status and the return under order marked as “Returned”.
Refunds issued from Shopify are received by the customer. This concludes the refund process.
When the return process is completed on Shopify, a scheduled job in HotWax Commerce downloads the return data. These returns are downloaded in "Completed" status and the payment in "Refunded" status in HotWax Commerce.
HotWax Commerce does not automatically increase the inventory count of the returned item after downloading the return order from Shopify. This is because HotWax Commerce lacks visibility into the specific location where the inventory is received. Instead, inventory is updated only when new item receipt records are synchronized to HotWax Commerce from NetSuite.
A scheduled job in HotWax Commerce performs a daily sync of inventory data from NetSuite, this ensures that inventory updates from any new receipts that are received in warehouses from returns or purchase orders are accurately synchronized in HotWax Commerce.
HotWax Commerce also performs regular inventory synchronization to Shopify by comparing the inventory totals between HotWax Commerce and Shopify. Following the comparison, HotWax Commerce updates Shopify with any differences in inventory numbers, ensuring that any changes in inventory in HotWax Commerce, such as increases resulting from returns, are accurately reflected on Shopify.
To ensure data integrity, HotWax Commerce provides an auditing tool OReSA that automatically compares returns totals of the eCommerce platform with the ERP.
In case any inconsistencies are found, the returns audit dashboard provides a gap analysis report that highlights the monetary gaps in both systems.
