Returns
Learn about returns in Shopify, Loop, NetSuite and HotWax Commerce.
Last updated
Was this helpful?
Learn about returns in Shopify, Loop, NetSuite and HotWax Commerce.
Last updated
Was this helpful?
In omnichannel retailing, retailers provide customers with the options for online returns as well as in-store returns.
Customers can initiate online returns for both online and in-store purchases.
Buy Online Return Online (BORO): Customers initiate online returns for their eCommerce orders.
Buy In-Store Return Online (BISRO): Customers initiate online returns for their in-store purchases.
Endless Aisle Return Online (EARO): Customers initiate online returns for their in-store ordered items which they received home delivery for.
Retailers we work with use Shopify as their eCommerce platform, NetSuite as their ERP system, Loop as their RMS, and HotWax Commerce as their OMS. This returns management workflow involves downloading returns data, creating Return Merchandise Authorizations (RMAs), processing Item Receipt records, and creating Customer Refunds.
Whenever an online return is processed in NetSuite through HotWax it follows these steps:
The In Progress return is posted to NetSuite as an RMA against the order the customer is returning
The RMA is received at the warehouse
The receipt confimration is used to issue a refund to the customer
This document will break down exactly how HotWax integrates with NetSuite to help execute each of these steps.
A job in HotWax Commerce Integration Platform captures in progress returns from HotWax Commerce OMS or another online returns platform, like Loop, and places them at a designated SFTP location. This enables NetSuite to access and process the data for creating RMAs for further processing.
SFTP Locations
Example for Loop returns:
Every 15 minutes, a scheduled SuiteScript in NetSuite runs to check for new return files at the SFTP location.
If a new RMA JSON file is found, the NetSuite SuiteScript reads and processes the file. An RMA is then created in NetSuite and marked as Pending Receipt.
The newly created RMA is linked to the original sales order. This offers traceability and provides warehouse teams with advance notice that the order item will be returned.
SuiteScript
After a few days, when the customer's returned item is physically received at the warehouse, the following actions take place:
An Item Receipt record is created and linked to the RMA.
Inventory is restocked, and the corresponding inventory count is increased in NetSuite.
The RMA status updates from Pending Receipt to Pending Refund.
As soon as the Item Receipt record is created in NetSuite, a CSV file is generated containing Loop’s return ID for reference. This file is then placed at the designated SFTP location.
This step is important for completing the return process in Loop, let’s see how in the next steps.
SuiteScript
SFTP Locations
SFTP Locations
The Process Return API triggers multiple actions in Loop based on the fetched Loop return IDs:
The RMA status is updated from Open to Closed.
As soon as the RMA in Loop is marked as Closed, multiple actions take place:
If the customer opted to receive a refund on their original payment method, Loop triggers Shopify to process the refund.
If the customer selected "Return for Store Credit," Loop automatically issues a gift card to the customer for the corresponding amount.
If the customer selected "Exchange," Loop creates a new exchange order in Shopify.
Shopify processes the customer refund using the original payment method, updating the return status from In-Progress to Returned in Shopify. At the same time, Shopify syncs the refund details back to Loop.
HotWax Commerce Integration Platform subscribes to Loop’s webhook to fetch and transform refund details.
SFTP Locations
A flow in HotWax Commerce Integration Platform transforms refund data. The JSON file is then placed at the SFTP location.
The file contains details about Loop return ID, Shopify order ID and the refund amount initiated to the customer.
A SuiteScript in NetSuite imports the file from the SFTP location, processes the data and triggers multiple actions:
A Credit Memo is created in Open status and linked to the RMA.
A Customer Refund record is automatically created based on the refund method and linked to the Credit Memo.
Once the Customer Refund record is created, the Credit Memo is updated from Open to Fully Applied, and the RMA is updated from Pending Refund to Refunded.
SuiteScript
A job in HotWax Commerce syncs the newly created Completed returns from Shopify and marks them as Completed in HotWax.
How is returned inventory restocked in HotWax Commerce?
Inventory from returns received in the warehouse is synchronized to HotWax Commerce during its periodic inventory sync with NetSuite. HotWax then also syncs the updated inventory counts of the product to Shopify.
Loop also offers the option to restock inventory. However, HotWax recommends disabling this feature in Loop. The reason is that HotWax and NetSuite handle inventory tracking across all locations, while Shopify only maintains a consolidated inventory at its default location.
With this setup, after HotWax restocks the returned inventory from NetSuite during its periodic inventory sync, a corresponding job in HotWax automatically increases the product's inventory count at the default location in Shopify.
When a customer opts for an exchange through Loop, a new exchange order is automatically created in Shopify once the return is closed in Loop. HotWax Commerce downloads these exchange orders from Shopify as regular orders and syncs them to NetSuite. Here's how different exchange scenarios are handled:
Loop automatically refunds the customer for the price difference and creates a new exchange order in Shopify.
HotWax’s Integration Platform captures this refund data and processes it as discussed earlier, transforming it for NetSuite without additional steps.
The return and exchange data are transformed and synced to NetSuite, as previously discussed.
No refund is issued to the customer because the funds from their return are applied to their exchange order.
Loop includes attribution in the Shopify order notes, indicating that the new exchange order involves an upsell.
HotWax recognizes this attribution and processes the order accordingly.
To post the additional payment, HotWax creates a Customer Deposit in NetSuite.
Suppose a customer initiates a return for a $100 item and chooses to exchange it for a $150 product. Loop processes the exchange, and Shopify records the new order with an additional $50 payment. The order notes include the upsell attribution. HotWax reads these notes, identifies the upsell, and generates a Customer Deposit for $50 in NetSuite, helping maintain accurate financial records.
Retailers' return policies can vary, ranging from one to several months. To accommodate future returns, HotWax imports historical orders from Shopify. However, some retailers accept returns for orders placed over a year ago. If a retailer starts using HotWax Commerce within that year and lacks historical orders in the OMS, here’s how HotWax handles such cases:
When return data is received from Loop, HotWax’s Integration Platform first checks the Shopify order ID in the OMS.
If a corresponding NetSuite order ID is found, the return process proceeds without interruptions.
The RMA is created in NetSuite and linked to the original sales order, maintaining consistency in data and workflows.
In some cases, older orders may not be imported into the OMS, but the corresponding records still exist in NetSuite.
When no matching NetSuite order ID is found in the OMS, HotWax’s Integration Platform runs a search query in NetSuite using the Shopify order ID to locate the original sales order details.
Once the original sales order is retrieved from NetSuite, the necessary return details are synced. This step helps ensure that even older orders, which might not have been part of the initial OMS setup, are accurately linked with the RMA and processed.
HotWax Commerce OMS and NetSuite both need return order data but at different stages of the return lifecycle. NetSuite requires return data early in the process for return authorization and processing, so HotWax’s Integration Platform syncs return orders to NetSuite as soon as they are initiated. However, OMS only needs return data once the return is completed in Shopify, so it downloads completed returns from Shopify at a later stage.
Since NetSuite already has the return order data from the Integration Platform, syncing the same returns again from OMS would create duplicates. To prevent this, when downloading returns from Shopify, HotWax OMS reads the order notes added by Loop and tags the return order with LOOP_RETURN_CHANNEL. This return channel identifier allows OMS to recognize Loop-initiated returns and exclude them from syncing again, keeping NetSuite data clean.
Customers who live near a brick-and-mortar store or those who prefer to get instant refunds opt for returning their purchases directly in-store.
Buy In-Store Return In-Store (BISRIS): Customers return their in-store purchases to a nearby store location.
Buy Online Return In-Store (BORIS): Customers directly return their online purchases to a nearby store location.
Endless Aisle Return In-Store (EARIS): Customers return orders made through an endless aisle feature, such as items ordered in-store for home delivery, to a nearby store location.
Retailers we work with, use Shopify POS as their POS system, NetSuite as their ERP system, Loop as their RMS, and HotWax Commerce as their OMS. Some retailers initiate in-store returns using the Loop Returns POS App, while others opt to use their Shopify POS system. Let's see how these two approaches work:
By leveraging Shopify POS for in-store returns, store associates are not required to navigate through a separate interface. This returns management workflow involves downloading returns data, processing Item Receipt records, and creating Customer Refunds.
Customers visit their preferred store to return a purchase, which may have been made in-store or online. Store associates search for the customer’s order ID, and once identified, they process the in-store return. Here’s how:
Select the order item being returned.
Specify the return reason.
Process refunds to customers.
A scheduled job in HotWax Commerce downloads the return data from Shopify POS. These returns are downloaded as Completed, and the payment is marked as Refunded in HotWax Commerce.
HotWax Commerce also restocks the returned inventory based on visibility into the specific location where the inventory was received.
A scheduled job in HotWax Commerce exports newly created POS returns and a job in HotWax’s Integration Platform imports and transforms this return data for NetSuite.
A scheduled job in the HotWax Commerce Integration Platform then generates a CSV file of the transformed POS returns data and places this file at an SFTP location.
A scheduled SuiteScript in NetSuite reads this CSV file from the SFTP location, triggering multiple actions:
An RMA is created with the Pending Receipt status and linked to the original sales order.
An Item Receipt record is generated, linked to the RMA, and inventory is automatically restocked at the store location where the returned item was received.
Once the Item Receipt record is created, the RMA is automatically updated to Pending Refund status.
A Credit Memo is created in Open status and linked to the RMA.
A Customer Refund record is automatically created based on the refund method and linked to the Credit Memo.
Once the Customer Refund record is created, the Credit Memo is marked as Fully Applied, and the RMA is updated to Refunded.
When customers return items in-store, the return request and receipt are processed simultaneously.
HotWax syncs all return data to NetSuite, enabling all subsequent actions, from RMA generation to customer refund creation, to progress sequentially and automatically in NetSuite. This process also helps maintain accurate GL accounting and posting, simplifying financial reconciliation.
When returning an item a customer can also opt to take the exchange item against it. The exchange item may be of higher value than the original item or may be of lesser value. Learn more about how HotWax commerce handles exchanges on an order.
Loop Returns POS App provides an intuitive interface to create POS returns. When it comes to in-store returns, because customers return their order items directly at the store location, the receiving of the order item and the processing of refunds happen simultaneously.
Once the POS returns are completed in Loop, it syncs them with both Shopify POS and NetSuite.
Loop creates returns in Shopify POS, marks the order item as returned and payment as refunded. Subsequently, the inventory is restocked against the received order item.
Loop with Novamodule also directly creates a Cash Sale return in NetSuite, marks the order item as returned, payment as refunded and generates item receipt records. Subsequently, the inventory is restocked against the created item receipt.
A scheduled job in HotWax Commerce downloads these returns from Shopify POS, including the facility ID where the returned items are received. Subsequently, HotWax Commerce marks the item as returned and payment as refunded. If the restocking flag is enabled, HotWax Commerce also restocks the inventory based on the provided facility ID.
As POS returns are already synced to NetSuite by Loop, they are not synced again by HotWax commerce.
A job in HotWax Commerce Integration Platform runs every 5 minutes to check for new CSV files received at the SFTP location. If any new files are identified, the job extracts the Loop return IDs from the file and subsequently triggers the .
