DataFlow : LoopReturns to NetSuite Customer Refund Add with Multiple Refunds & Refund Methods 

Important Note: 

Before enabling the new flow for handling multiple customer refunds, please disable the existing customer refund flow in Loop.

The new flow is designed to manage both single and multiple customer refunds.

Overview

Loop Returns IA  now supports handling multiple refunds and refund methods for orders paid with multiple payment methods. When a customer returns items from such an order, Loop automatically splits the refund amount proportionally across the used payment methods.

Here's how it works:

• Based on the payment methods used in the original order, Loop Returns IA creates separate customer refunds in NetSuite for each corresponding credit memo associated with the return.
• If the return involves multiple payment methods, Loop Returns IA creates multiple customer refunds, each with the respective amount apportioned from the total refund. This functionality is enabled by a new flow implemented within the Loop Returns IA.

Configuration

The new customer refund flow leverages the existing "saved search" flow. Therefore, no additional configuration settings are required for this functionality.

Mappings: Customer Refund Import - New Flow

The existing mappings for the single-customer refund import process need to be adapted to accommodate the new multiple refund flow. These adaptations will primarily involve changes to the mapping path within the import process.

Below are the required mappings:

(Refund Method/gateway Static Lookup mapping sample below)

Shopify UI: Sample Order with Multiple Payment Methods

This section showcases a sample Shopify order where the customer used multiple payment methods to complete the purchase.

Loop Returns: Handling Partially/Full Returns with Multiple Payment Methods

When a customer partially/fully returns an order originally paid for with multiple payment methods, the Loop return backend data now reflects this. The data will contain details of the returned items and the corresponding payment methods used for those items, along with their respective amounts.

NetSuite UI: Credit Memos and Multiple Refund Methods

This section demonstrates how NetSuite handles credit memos for returns involving multiple refund methods.

Sample Scenario:

• A customer returns items from an order originally paid for with multiple payment methods.
• The corresponding credit memo is imported into NetSuite (shown below).
• Since the credit memo has not yet been refunded, its status remains "OPEN."

New Functionality:

The recently implemented flow now creates separate customer refunds in NetSuite. Each customer refund will be associated with a specific refund method and its corresponding amount.

Example:

As illustrated in the previous screenshot, the Loop return backend data for this credit memo indicates multiple refund methods used. Consequently, two separate customer refunds will be created, reflecting the individual payment methods and their amounts.

Credit Memo: Un-Refunded State

Credit Memo: Refunded State

Credit Memo: Multiple Customer Refunds

Customer Refund - 1: Ignore Refund Methods - Just for illustrative purposes

Customer Refund - 2: