Sometimes the most impactful innovations start with a real world client challenge. That was the case when a Shopify and NetSuite customer needed a way to fully automate returns, exchanges and refunds across their eCommerce and ERP landscape.
The result was a ZangaBee built integration so effective that Celigo decided to turn it into an official, reusable template for its global customer base.
Are you in need of this? Do not hesitate to contact us!
The Challenge
The customer wanted to automate their entire post purchase operation across Shopify, both online and POS, and NetSuite. The requirements were detailed and operationally complex.
For returns, NetSuite needed to automatically create Return Authorizations, Item Receipts and Credit Memos, capturing both online and in store POS returns.
For exchanges, the solution had to support multiple scenarios: like for like swaps, downsells where the customer selects a less expensive item, and upsells where the customer upgrades. This required seamless handling of Sales Orders, Item Fulfillments, Invoices, and depending on the price difference, either Customer Refunds or Customer Payments.
The most challenging part was handling web based exchanges. In this scenario, the exchange order in NetSuite could only proceed after a manual Item Receipt was created. Until that confirmation, the order needed to remain on hold in both Shopify and NetSuite. Only once the Item Receipt existed could the flow automatically release the hold and fulfill the new exchange.
Standard Shopify to NetSuite connectors, including Celigo’s base integration, handle order to cash flows well, but do not support this kind of conditional, event driven workflow across returns, exchanges and refunds. The requirements went far beyond out of the box functionality.
Why It Was Complex
Conditional workflow
An exchange could not be released simply because a customer selected an exchange in Shopify. It had to wait for a specific operational event: the manual creation of an Item Receipt in NetSuite.
Hybrid manual and automated steps
Some steps, such as Item Receipt creation, remained manual by necessity. Everything around those steps had to be fully automated to prevent errors. That included automatic creation of Sales Orders, Fulfillments, Invoices, Refunds and Payments, as well as the controlled release of holds in Shopify.
Financial precision and inventory alignment
The solution had to manage upsells and downsells, tax, discounts, refunds, credit memos and customer payments, all while keeping Shopify and NetSuite perfectly in sync. The outcome needed to be accurate financials and reliable inventory across all channels.
The ZangaBee Solution
ZangaBee designed and built a custom Celigo flow using Shopify’s API to detect return, exchange and refund events.
Returns and exchanges are automated end to end. From Shopify, either online or POS, events trigger flows that push data into NetSuite, creating RMAs, Item Receipts for POS returns, Credit Memos for refunds, or Exchange Sales Orders when applicable. This aligns with Celigo’s supported Shopify returns to NetSuite RMA, exchange and refund framework.
Within NetSuite, scripts, custom fields, saved searches and user event logic were added. For example, when an Item Receipt is manually created for a returned item, a User Event script updates the related Sales Order to Pending Fulfillment. A second Celigo flow then automatically lifts the hold in Shopify, allowing the exchange to proceed without manual intervention.
All exchange scenarios are supported. Even exchanges result in invoices offset by credit memos to a zero balance. Downsells issue a net credit to the customer. Upsells generate a customer payment for the price difference.
POS returns are also fully automated. When a return is processed in Shopify POS and marked closed, the flow automatically creates the RMA, Item Receipt and Credit Memo in NetSuite, even if the original sales order is not available.
From Custom Build to Celigo Asset
When Celigo reviewed this integration, they recognized that it filled a critical functionality gap in their native Shopify NetSuite connector. As a result, the solution was selected to become the Shopify NetSuite Returns, Exchanges and Refunds template, offered in partnership with ZangaBee.
According to the template documentation, the solution automates and synchronizes all post purchase operations, including returns, exchanges and refunds, across Shopify online, Shopify POS and NetSuite.
The template supports even exchanges, downsells and upsells. It enables POS returns without an existing sales order through stand alone RMAs, Item Receipts and Credit Memos. It also supports customer refunds in NetSuite tied to Credit Memos, with Shopify payment methods such as Shopify Payments or PayPal mapped to NetSuite refund methods using lookup tables.
Celigo worked with ZangaBee to convert the original design and implementation into a fully supported, reusable template. The final asset carries the ZangaBee name to reflect the original architecture and delivery.
What This Means
This milestone highlights ZangaBee’s dual strength: deep technical expertise and a trusted partnership with Celigo. By solving a complex client challenge, ZangaBee did not just deliver a single integration, but helped shape a scalable solution that will support many Celigo users globally.
For ZangaBee, it is not just about building integrations. It is about contributing to the ecosystem and improving how platforms work together at scale.
