Shopify & NetSuite

Introduction

The Patchworks Shopify and NetSuite B2B blueprint enables the synchronisation of customer, order, product, and inventory data between the two systems. It can be used for different setups, including B2B and D2C. Data syncing is summarised below:

Flow Type	Sync direction	Purpose
Contacts & locations	↔	Keep company and contact records aligned.
Orders & payments	→	Push new orders, payments, and invoices into NetSuite
Products & pricing	↔	Sync catalogue, SKUs, and price lists.
Inventory	↔	Maintain accurate stock across all locations.
Fulfilments & refunds	↔	Update fulfilment status and credit memos.

Customer & company data

• Two-way synchronisation of companies, locations, and contacts.

• Detects new or updated records using SuiteQL and GraphQL queries.

• Ensures address books, payment terms, and contact details stay aligned across both systems.

Orders, payments & refunds

• Creates sales orders and payments in NetSuite when orders are placed in Shopify.

• Handles both paid and pending orders with intelligent branching logic.

• Synchronises refunds and RMAs back into NetSuite with full credit-memo creation.

• Supports partial fulfillments and multi-location order handling.

Products, catalogs & pricing

• Keeps your product catalogue and pricing consistent across platforms.

• Creates and updates parent/child matrix items in NetSuite, directly from Shopify.

• Manages multiple price lists and catalog assignments.

• Daily or on-demand pricing updates supported out of the box.

Inventory & fulfilment

• Synchronises stock levels between NetSuite and Shopify.

• Creates and updates fulfillment records and tracking numbers.

• Manage fulfillment locations in both directions to ensure accurate order routing.

For detailed information, please refer to the Available process flows section.

How it Works

Each flow is powered by the Patchworks API-first integration platform, where:

• SuiteQL queries drive data extraction from NetSuite.

• The Shopify GraphQL API drives data extraction from Shopify.

• Patchworks custom scripts handle data comparisons, mapping, deduplication, and transformation.

• Fully customisable cross-reference lookups allow automatic data conversions for your specific business rules.

Out of the box, the Patchworks Shopify and NetSuite blueprint includes:

• 13 ready-made integration flows covering the complete order-to-cash and fulfilment cycle.

• Reusable scripts for data grouping, matrix item handling, contact injection, and refund detection.

• Configurable flow variables (date filters, subsidiaries, price levels, etc.) to tailor behaviour.

• Built-in handling for Shopify Plus GraphQL nuances and NetSuite SuiteQL constraints.

Key benefits

• Faster time-to-value. Pre-configured, tested flows deploy in days, not months.

• Fully customisable. Extend or modify mappings and filters to suit your business logic.

• Low maintenance. Built on the Patchworks platform with built in retries, error handling, and monitoring.

Available process flows

For detailed information, please refer to the Available process flows section.

Assumptions

• NetSuite knowledge. This blueprint is provides base functionality/logic to sync data between Shopify & NetSuite. However, NetSuite is highly customisable - as such, it's important to review flow configuration in the context of your own NetSuite setup. Guidelines are provided in the Available process flows section of this documentation.

• Patchworks knowledge. Process flows included with this blueprint include advanced functionality such as custom scripting, SuiteQL/GraphQL queries, and mapping transform functions. It is assumed that you have a good working knowledge of these features.

Installation

For installation instructions, please refer to our Installation guide.