The Shopify – NetSuite D2C template expands how you implement and customize your Shopify - NetSuite integration using Celigo’s integrator.io platform. Built on Shopify’s GraphQL APIs, this template is based on the proven flows from the existing Shopify-NetSuite integration app, now delivered in a more flexible, extensible format.
This template synchronizes the full order-to-cash lifecycle, including: Orders, Customers, Fulfillments, Billing, Inventory, Products, Refunds, Returns and exchanges, Cancellations, Payouts, and Inventory transfers.
Unlike the managed integration app, this template is delivered as an unmanaged solution, giving you full access to the underlying integration assets. You can directly modify flows, mappings, and business logic to align the integration with your operational and financial requirements.
In complex environments, integrations often require customization beyond standard configurations. You may need to:
-
Customize business logic for order, fulfillment, or return handling
-
Adapt transaction flows to match internal business processes
-
Configure financial mappings to meet accounting and reporting requirements
A standardized managed integration may not provide the flexibility needed to support these scenarios.
This template serves as a strong accelerator and foundation. It provides greater flexibility and control, enabling you to directly modify flows, mappings, and business logic to align the integration with your operational and financial requirements.
This template uses the Shopify Admin GraphQL API, enabling:
-
More efficient and flexible data retrieval
-
Alignment with Shopify’s API roadmap and transition away from REST
-
2,048 product variants per item: Uses GraphQL productSet mutation, removing REST limitations
-
Efficient order and fulfillment queries: Retrieves order line items, metafields, and fulfillment details in a single API call
-
Native Shopify Returns API support: Supports online and POS exchange workflows
-
Delta-based pagination: Uses cursor-based pagination with after and updated_at filters
-
Inventory transfers support: Syncs NetSuite Transfer Orders with Shopify and processes receipts
All Shopify-side operations use the Shopify Admin GraphQL API. All NetSuite-side operations use SuiteScript restlets and saved searches via Celigo’s native NetSuite adaptor.
The template includes 32 integration flows organized into 10 functional modules, plus 3 one-time setup (generic) flows.
Module-wise flow breakdown
|
Module |
Flows |
Direction |
|---|---|---|
|
Orders |
Shopify order to NetSuite sales order or cash sale (add) Shopify order to NetSuite order (cash sale or sales order) - Exchanges Shopify order transaction to NetSuite custom transaction record (add) Shopify order transaction to NetSuite customer deposit (add) NetSuite order to Shopify order (add) |
Bi-directional |
|
Customers |
Shopify customer to NetSuite customer (add or update) NetSuite customer to Shopify customer (add or update) |
Bi-directional |
|
Fulfillments |
NetSuite fulfillment to Shopify fulfillment (add) Shopify fulfillment to NetSuite fulfillment (add) |
Bi-directional |
|
Products & Inventory |
NetSuite Item to Shopify Product (add or update) NetSuite matrix item to Shopify product (add or update) NetSuite item metafields to Shopify Product metafields NetSuite inventory to Shopify inventory (add or update) Shopify products to item ID map (add/update) |
NetSuite to Shopify |
|
Billing |
NetSuite sales order to NetSuite invoice or cash sale (add) NetSuite billing to Shopify billing (add) |
NetSuite internal + NetSuite to Shopify |
|
Refunds |
Shopify refund to NetSuite refund (add) NetSuite refund to Shopify refund (add) |
Bi-directional |
|
Returns & Exchanges |
Shopify requested returns to NetSuite return authorization (add) NetSuite pending receipt RMA to approved return in Shopify NetSuite received RMA to process return and exchange in Shopify Shopify hold fulfillments on payment pending release |
Bi-directional |
|
Cancellations |
Shopify order cancellation to NetSuite cancellation (add) NetSuite cancellation to Shopify cancellation (add) |
Bi-directional |
|
Payouts |
Shopify payout to NetSuite custom records (add) Shopify payout transactions reconciliation Shopify payouts to NetSuite bank deposits |
Shopify to NetSuite |
|
Inventory Transfers |
NetSuite Transfer Orders to Shopify Inventory Transfer (add or update) Shopify received Inventory Transfer to NetSuite Item Receipt for Transfer (add) |
Bi-directional |
|
Generic (run once) |
Shopify store to NetSuite custom record (add) Shopify markets to NetSuite (add) · Shopify business entity to NetSuite (add) |
Shopify to NetSuite |
Important
All 32 flows are disabled by default after installation. You must run the three setup flows first, then enable transactional flows in the recommended order.
The template uses Shopify and NetSuite connections.
Shopify connection (Auth: OAuth 2.0 and API type: GraphQL)
-
Primary connection used by all order, customer, fulfillment, product, inventory, refund, return, and cancellation flows
-
Endpoint: https://{your-store}.myshopify.com/admin/api/2025-07/graphql.json
-
Requires store owner authorization
Important
Known limitation: The Shopify connector does not currently support all GraphQL API scopes required by this template. To ensure access to the necessary scopes, authenticate the Shopify connection using a local iClient. We are actively working to add support for the remaining scopes. If you encounter errors due to missing scopes, re-authenticate using a local iClient and include the required scopes
NetSuite connection (Token-based authentication)
-
Uses Celigo’s native NetSuite adaptor
-
Requires:
-
integrator.io bundle (20038)
-
Shopify Connector bundle (81289)
-