Black Friday. Orders are pouring in on Shopify, the logistics team is packing boxes, and meanwhile someone is re-keying orders one by one into NetSuite. The stock shown on the site no longer matches reality, and a customer has just bought a product that is no longer in the warehouse.
Shopify and NetSuite make an excellent pair: the first to sell, the second to manage finance, inventory and operations. But for this pair to work, you need a reliable connection between the two. And that is where things get complicated: several approaches exist, with very different costs, capabilities and limits.
At SuiteVise, we set up and take over Shopify–NetSuite integrations. Here is what you need to know to make the right choice and avoid the costliest pitfalls.
The data flows to sync between Shopify and NetSuite
Before talking about tools, you need to know which data moves, in which direction, and which system is the master.
| Flow | Usual direction | Master system |
|---|---|---|
| Items (products, variants, SKUs) | NetSuite → Shopify | NetSuite for operational data, Shopify for marketing content |
| Prices and price lists | NetSuite → Shopify | NetSuite |
| Inventory | NetSuite → Shopify | NetSuite |
| Customers | Shopify → NetSuite | Shopify at creation, NetSuite afterwards |
| Orders | Shopify → NetSuite | Shopify |
| Shipments and tracking numbers | NetSuite → Shopify | NetSuite (or the logistics tool) |
| Refunds and returns | Shopify → NetSuite | Shopify |
| Payments and payouts | Shopify → NetSuite | Shopify, reconciled in accounting |
The most often forgotten point is the last one: Shopify payouts. A payout groups several sales, minus refunds and fees. Without clear handling, accounting spends hours reconciling the bank with sales.
The four ways to connect Shopify and NetSuite
1. Oracle’s NetSuite Connector
The NetSuite Connector (formerly FarApp) is the connector offered by Oracle. It covers the classic flows: items, inventory, prices, orders, shipments, and handles several sales channels.
Its strengths: an official solution, Oracle support and a relatively fast setup for standard needs.
Its limits: it is less flexible as soon as business rules go beyond the usual. Many companies find it suitable to start with, but limited as volumes or complexity grow.
2. Dedicated Shopify–NetSuite connectors
Several vendors offer connectors specialized solely in this pairing, as a Shopify app or a NetSuite SuiteApp.
Their strengths: an often lower cost, fine handling of Shopify’s specifics, and a fast setup.
Their limits: quality varies widely from one vendor to another. You need to check functional coverage, error handling, the vendor’s solidity and the quality of support.
3. Integration platforms (iPaaS)
Celigo is the most cited platform in the NetSuite ecosystem, with a Shopify–NetSuite integration app that includes ready-to-use flows (orders, items, inventory, shipments, refunds). Other platforms such as Boomi, Workato or Jitterbit are also used.
Their strengths: preconfigured flows, advanced error handling, strong customization capabilities, and the ability to connect other systems (marketplaces, logistics, CRM) on the same platform.
Their limits: a higher cost, and one more platform to master. For a simple store, it can be oversized.
4. Custom integration
An integration developed specifically between Shopify’s API and NetSuite’s APIs (REST or RESTlets).
Its strengths: total freedom to handle very specific rules or large volumes.
Its limits: the development cost, but above all maintenance. Shopify’s and NetSuite’s APIs change regularly, and the integration depends on the skills of whoever built it.
How to choose the right option?
A few questions to ask yourself:
- How many orders per day, and what peaks (sales, Black Friday)?
- How many stores, countries, currencies and warehouses?
- Which flows are essential from day one, and which will come later?
- Which other systems will need to be connected in the future?
- Who will monitor the integration and handle errors day to day?
- What budget, counting licenses, setup and maintenance over several years?
| Your situation | Option that often fits best |
|---|---|
| One store, standard flows, moderate volumes | NetSuite Connector or dedicated connector |
| Several stores, several countries or currencies | Robust dedicated connector or iPaaS |
| Shopify + marketplaces + logistics + CRM | iPaaS (Celigo, Boomi…) |
| B2B sales with specific price lists and terms | iPaaS or connector with advanced B2B handling |
| Very specific business rules or very high volumes | Customized iPaaS or custom integration |
The pitfalls we see most often
- Forgetting payout reconciliation. Sales reach NetSuite, but Shopify payouts, fees and refunds are not handled. The result: growing suspense accounts and hours of reconciliation every month.
- Neglecting tax. Shopify calculates one tax, NetSuite applies another. You need to decide which system calculates VAT, how it is carried into NetSuite, and check consistency with your tax engine (Legacy Tax or SuiteTax).
- Poorly linked items. Variants, kits, lots, different SKUs in the two systems: without clear mapping, orders fail or inventory becomes wrong.
- Discounts, gift cards and shipping fees. They are often poorly reflected in accounting if their handling is not defined from the start.
- No error handling. An order silently rejected is a customer who will never receive their delivery. The integration must alert and make replaying easy.
- Inventory syncs that are too slow. During peaks, stock updated every hour is enough to create sales that can’t be fulfilled.
- API limits. Simultaneous calls to NetSuite are limited and shared across all your integrations. A poorly tuned connector can block other flows.
- Forgetting French obligations. B2B sales made through Shopify are subject to e-invoicing, and sales to consumers to e-reporting. The Shopify → NetSuite → approved platform chain must be designed end to end.
Our method for a successful integration
- Map the flows and rules. For each flow: the direction, the frequency, the master system, and the transformation rules (taxes, discounts, shipping fees, items).
- Involve finance from the start. The handling of payouts, fees, refunds and VAT is decided with accounting, not after go-live.
- Prepare master data. Items, SKUs, customers, price lists: a clean base in NetSuite prevents most errors.
- Choose the tool based on real needs and how they will evolve, not just the initial price.
- Test real cases. Simple order, order with a discount, gift card, partial refund, return, B2B order, volume peak: each scenario is tested in a test environment.
- Set up monitoring. An error dashboard, alerts, and a named owner to handle them every day.
- Go live gradually. For example by enabling flows one at a time, or by starting with a single store.
Frequently asked questions
How do you connect Shopify and NetSuite?
Four approaches exist: Oracle’s NetSuite Connector, a dedicated Shopify–NetSuite connector, an integration platform such as Celigo, or a custom integration through the APIs. The right choice depends on volumes, the number of stores and the complexity of business rules.
What is the best Shopify–NetSuite connector?
There is no single answer. The NetSuite Connector and dedicated connectors work well for standard needs. A platform such as Celigo is better suited to complex or multi-system environments.
Which data should be synced between Shopify and NetSuite?
Items, prices and inventory from NetSuite to Shopify; customers, orders, refunds and payouts from Shopify to NetSuite; shipments and tracking numbers from NetSuite to Shopify.
How long does a Shopify–NetSuite integration take?
From a few weeks for a well-prepared standard connector to several months for a complex or custom integration.
How should Shopify payouts be handled in NetSuite?
By defining with finance a clear treatment of sales, fees, refunds and payouts, ideally automated, so that bank reconciliation is no longer manual.
In short: the right connector, but above all the right rules
Connecting Shopify and NetSuite is not just about choosing a connector. It is about defining which system is the master for each piece of data, how finance handles payouts and VAT, and how errors are monitored. The NetSuite Connector, a dedicated connector, a platform such as Celigo or a custom integration can all work, provided they are chosen for your real needs and properly configured.
Launching your Shopify store, or your current integration generates too many errors? SuiteVise can help: flow mapping, choice of connector, configuration, testing and follow-up. Let’s take 30 minutes to talk it through.