Orders, inventory, fulfilment, refunds, and payouts flowing between Shopify and NetSuite without anyone re-keying them. Built and supported by a NetSuite Alliance Partner.
Shopify is where customers buy. NetSuite is where the business is run: inventory, fulfilment, accounting, and the numbers the board sees. Left unconnected, every order is typed twice, stock levels on the storefront drift from what is on the shelf, and month-end means reconciling Shopify payouts against deposits by hand. A properly built integration makes NetSuite the single source of truth and lets Shopify do what it is good at. The work is in deciding exactly what flows, in which direction, and what happens when something does not match.
| Data | Becomes | Direction | Notes |
|---|---|---|---|
| Orders | Sales order or cash sale | Shopify → NetSuite | Including POS, draft, and B2B orders; discounts and gift cards mapped to lines |
| Customers | Customer record | Shopify → NetSuite | Matched on email; guest checkouts handled by rule |
| Products & variants | Items and matrix items | NetSuite → Shopify | NetSuite is the item master; SKUs must match exactly |
| Inventory levels | Available quantity by location | NetSuite → Shopify | Per Shopify location, from one or more NetSuite locations and 3PLs |
| Fulfilments | Fulfilment with tracking | NetSuite → Shopify | Triggers the customer’s shipping notification |
| Refunds & cancellations | Credit memo, refund, or closed order | Shopify → NetSuite | Line-level partial refunds are the test of a good connector |
| Payouts | Deposit with fee lines | Shopify → NetSuite | Shopify Payments payouts reconciled to the bank, fees to expense |
| Tax | Tax line or Avalara call | Either | Shopify-calculated tax imported as lines, or NetSuite/Avalara as the system of record |
NetSuite Connector. Oracle’s own connector, sold and supported by NetSuite. It covers the standard flows well, including Shopify POS, refunds, gift cards, and multi-location inventory, and upgrades are managed by Oracle. It is the lowest-friction option for a single store with conventional processes.
Celigo. An integration platform with the deepest prebuilt Shopify library: orders, customers, items, inventory, fulfilments, refunds, Shopify B2B price lists, OneWorld and multi-currency support, and flows that can be extended when a business does something the standard ones do not cover. It is the usual choice for multi-store, multi-channel, or fast-growing brands, and for anyone who also needs Amazon, a 3PL, or a marketplace connected to the same NetSuite account.
Custom SuiteScript. Built directly on NetSuite’s APIs. Full control, full ownership, and no subscription, at the cost of building and maintaining it. It makes sense when the business logic is unusual enough that a connector would need heavy customisation anyway, or when a single specific flow, such as payout reconciliation, needs to sit alongside a connector.
Consule works with all three and recommends based on your order volume, number of stores and channels, B2B requirements, and who will own the integration after go-live. The recommendation is not always the same tool.
SKUs that almost match. The single most common day-one failure. A trailing space, a different case, or a variant SKU that exists in Shopify but not NetSuite, and orders land in an error queue. Consule audits the item catalogue before anything is connected.
Payouts nobody reconciles. Shopify Payments deposits the net of fees, refunds, and chargebacks. If the integration only posts orders, finance is left matching gross sales to net deposits at month-end. Payout reconciliation is designed in from the start, not added later.
Inventory from the wrong place. A storefront showing plant stock that is allocated to wholesale orders, or ignoring a 3PL. Which NetSuite locations feed which Shopify location is a business decision, and it is made explicitly.
Every flow, field by field, in a mapping document your team signs off: what an order becomes, how customers are matched, which locations feed the store, how tax, discounts, and gift cards post.
Connector configured or scripts written to the mapping, in a sandbox, with error handling and alerting so a failed order is visible within minutes rather than at month-end.
Live-shaped test cases: multi-line orders, partial refunds, exchanges, POS sales, a payout. Finance signs off the accounting before anything goes live.
Cutover timed around your order cycle, hypercare for the first week, and ongoing monitoring and change requests under the Consule CARE program.
Selling on Shopify from a plant or a warehouse?
Consule’s clients are manufacturers and distributors, which changes the integration: storefront stock has to respect what is allocated to wholesale, B2B customers need their price lists, and the same NetSuite account often runs a Shopify store, an Amazon channel, EDI customers, and a 3PL. We design the Shopify flow as one part of that picture, not in isolation.
Not out of the box. Oracle sells a NetSuite Connector for Shopify that provides prebuilt flows, and Celigo and other platforms offer alternatives. All of them need configuration and mapping decisions; none is plug-and-play for a real business.
A single store on standard flows with a clean item catalogue is typically live in four to eight weeks. Multiple stores, B2B pricing, POS, a 3PL, or unusual accounting add time. Consule scopes it after discovery rather than quoting before.
Yes. Shopify B2B companies, price lists, and payment terms map to NetSuite customers, price levels, and terms, and B2B orders can post as sales orders with invoicing rather than as cash sales.
They should post to NetSuite as deposits with the fees, refunds, and adjustments broken out, so the deposit matches the bank and the fees hit expense. This is the part most connectors handle weakly by default, and the part Consule designs in.