Shopify ERP Integration: How It Works + 10 Best ERPs (2026)
Get an AI summary of this post:
It usually starts small. A wholesale order gets typed into the ERP twice. A best-seller shows "in stock" on Shopify an hour after the warehouse ran out. Finance spends the first week of every month matching Shopify payouts to bank deposits line by line.
Shopify ERP integration ends that by connecting your store to the system that runs inventory, purchasing and accounting, so orders, stock, prices and payouts move between them on their own. This guide explains how the integration works, which system should own which data, the four ways to connect, the API limits that decide what is possible, and the 10 best ERPs for Shopify. It finishes with the 7-step plan, field-mapping template and go-live checklist we use on real projects.
Key takeaways
-
Shopify is not an ERP. It runs your storefront, checkout and orders; the ERP should own inventory valuation, purchasing and the general ledger.
-
The first decision is not which ERP to buy. It is which system owns each type of data. Two systems both editing stock is one of the most common causes of overselling.
-
Shopify's Global ERP Program launched with certified connectors for Microsoft Dynamics 365 Business Central, Oracle NetSuite, Infor, Acumatica and Brightpearl (Shopify announcement).
-
Shopify's GraphQL Admin API allows 100 points per second on standard plans and 1,000 on Shopify Plus (Shopify rate limits). Your sync design has to fit inside that budget.
-
Webhooks can arrive more than once, so every integration needs duplicate protection and a reconciliation job (Shopify webhook docs).
-
For most brands, a certified connector or an iPaaS beats custom code. Custom builds pay off for unusual workflows, on-premise ERPs or very high volume.
What is Shopify ERP integration?
Shopify ERP integration is a two-way connection between your Shopify store and an enterprise resource planning (ERP) system. Orders, customers, refunds and payouts flow from Shopify into the ERP. Inventory levels, prices, product data and tracking numbers flow back to Shopify. The connection runs through a connector app, an integration platform (iPaaS) or custom code built on Shopify's Admin API.
An ERP is the back-office system that holds accounting, inventory, purchasing, warehousing and often manufacturing in one database. Shopify is where you sell. The ERP is where you account for what you sold, what it cost, and what to buy next.
Is Shopify an ERP? Shopify vs ERP vs inventory app
No, Shopify is not an ERP. It is a commerce platform that manages products, checkout, orders, payments and stock counts per location. It does not run a general ledger, landed costs, multi-entity accounting or production planning. Many growing brands don't need a full ERP yet, so check which tool your problem actually calls for.
|
Tool type |
What it covers |
Examples |
Choose it when |
|---|---|---|---|
|
Commerce platform |
Storefront, checkout, orders, payments, stock per location |
Shopify, Shopify Plus |
Always: this is your sales channel |
|
Accounting app |
Ledger, invoices, tax, bank feeds |
QuickBooks Online, Xero |
One channel, simple stock, finance is the main pain |
|
Inventory or order management system |
Multichannel stock, purchase orders, light manufacturing |
Cin7, Katana, Extensiv |
Several channels or warehouses, but one legal entity and simple finance |
|
ERP |
Finance, inventory, purchasing, warehousing, manufacturing in one system |
NetSuite, Business Central, Acumatica, Odoo |
Several entities, warehouses or currencies, wholesale terms, or manufacturing |
Let’s work together to build your store
We are one of the world’s most trusted and experienced Shopify Plus Partners.
Get in touch7 signs your Shopify store needs an ERP integration
-
Someone re-keys Shopify orders into accounting or the ERP, or imports CSV files every day.
-
You oversell or find "ghost stock" more than once a month.
-
You sell the same stock across Shopify, marketplaces, retail POS and wholesale.
-
Month-end close takes days because Shopify payouts, fees and refunds don't match the books.
-
You run B2B with customer-specific price lists, net terms or credit limits.
-
You've opened, or plan to open, a second store, a new country or a Shopify Plus expansion store.
-
Your purchasing team reorders from spreadsheets because nobody trusts the stock numbers.
If two or more are true, manual work is already costing more than an integration would. [ADD: one real client example, e.g. "A Crawlapps apparel client was spending X hours a week re-keying wholesale orders before integration."]
How Shopify ERP integration works: what syncs and who owns it
Every working integration follows the same loop. Shopify fires a webhook when something happens (an order is paid, a refund is issued). The integration queues that event and writes it to the ERP. When something changes in the ERP (stock is received, a price list updates), the integration writes the change back to Shopify through the Admin API. A scheduled reconciliation job then compares both systems and catches anything that slipped through.
Before any of that is built, agree who owns each type of data. Get operations and finance to sign off on this table first.
|
Data |
Owner (source of truth) |
Direction |
Notes |
|---|---|---|---|
|
Orders (online, POS, draft) |
Shopify |
Shopify to ERP |
Include sales channel and location on every order |
|
B2C customers |
Shopify |
Shopify to ERP |
Sent with the first order, not as a bulk sync |
|
B2B companies, catalogs, payment terms |
ERP |
ERP to Shopify |
Credit limits stay in the ERP |
|
Available inventory per location |
ERP or WMS |
ERP to Shopify |
Push available quantity, not on-hand |
|
Core product data (SKU, cost, weight, HS code, barcode) |
ERP or PIM |
ERP to Shopify |
SKU is the matching key in both systems |
|
Marketing content (descriptions, images, SEO fields) |
Shopify or PIM |
Stays in Shopify |
Don't sync it; it causes overwrite fights |
|
Prices (B2C) |
ERP or Shopify, pick one |
One direction only |
Compare-at prices need a clear owner too |
|
Fulfillment and tracking |
ERP, WMS or 3PL |
To Shopify |
Triggers the customer's shipping email |
|
Refunds, returns, exchanges |
Shopify |
Shopify to ERP |
Map each to a credit note, not a negative order |
|
Gift cards and store credit |
Shopify |
Shopify to ERP |
A liability on sale, revenue on redemption |
|
Payouts, processing fees, taxes |
Shopify Payments |
Shopify to ERP |
Post daily so deposits match the bank |
The last three rows are the ones teams forget. Orders sync fine on day one; refunds, gift cards and payouts are what bring finance back to spreadsheets a month later.
Real-time vs batch: how often Shopify and your ERP should sync
There is no single right interval. Sync frequency should follow how fast each product sells, because a product can oversell inside any gap between a sale and the next stock update.
|
Data or product type |
Example |
Recommended sync |
|---|---|---|
|
Slow movers and long tail |
Spare parts, seasonal basics |
Scheduled, every 15 to 60 minutes |
|
Core range |
Steady weekly sellers |
On change (event-driven) |
|
Fast movers, drops, flash sales |
Limited editions, BFCM doorbusters |
On change, plus a safety buffer held back from Shopify's available quantity |
|
B2B prices and terms |
Wholesale price lists |
On change, with a nightly full check |
|
Financial postings |
Payouts, fees, refunds |
Daily batch, matched to bank deposits |
Pro tip: a safety buffer of a few units on fast sellers means the storefront sells out slightly before the warehouse does. That costs you a handful of sales on launch day and saves you from cancelling paid orders.
Benefits of Shopify ERP integration (and the KPI that proves each one)
Most guides list the benefits. Few tell you how to prove them. Measure each KPI for one month before go-live so you have a real baseline.
|
Benefit |
What actually changes |
KPI to track |
|---|---|---|
|
Accurate inventory |
The ERP pushes available stock per location as it changes |
Oversold orders per month; cycle-count accuracy % |
|
Faster fulfillment |
Paid orders create ERP sales orders and pick lists automatically |
Order-to-ship time in hours |
|
Less manual entry |
Nobody re-keys orders, refunds or tracking numbers |
Staff hours per week on data entry |
|
Faster month-end close |
Sales, refunds, fees and payouts post to the ledger daily |
Days to close the month |
|
Better B2B service |
ERP price lists, terms and credit limits drive Shopify B2B |
B2B order corrections per month |
|
Scale without extra headcount |
New stores, markets and channels plug into one back office |
Orders processed per operations staff member |
[ADD: before/after numbers from one Crawlapps project for at least one of these KPIs. This is the single most citable thing you can add.]
4 ways to connect Shopify to an ERP
There are four routes. Most brands should check for a certified connector first, then move to an iPaaS when workflows or system count outgrow it.
|
Method |
How it works |
Best for |
Typical timeline |
Main trade-off |
|---|---|---|---|---|
|
Certified or native connector |
The ERP vendor's own app from the Shopify App Store |
Mainstream ERP, standard flows |
Days to a few weeks |
Only syncs the fields and flows the app supports |
|
iPaaS (Celigo, Boomi, MuleSoft, Workato) |
Cloud platform with prebuilt Shopify and ERP connectors plus your own mapping rules |
Three or more connected systems, custom business rules |
3 to 8 weeks |
Ongoing subscription; needs an internal owner |
|
Specialist middleware |
A third-party app built for one ERP pairing |
Older or on-premise ERPs such as Sage 100, Epicor, SYSPRO |
1 to 4 weeks |
You depend on a smaller vendor's roadmap |
|
Custom API integration |
Developers build on Shopify's GraphQL Admin API and the ERP's API |
Unusual workflows, very high volume |
2 to 4+ months |
Highest cost to build and maintain |
[ADD: replace the timelines with Crawlapps' own project averages.]
How to pick the right method
-
Certified connector: your ERP has one, and your order, stock and refund flows look like everyone else's.
-
iPaaS: you also connect a WMS, 3PL, CRM or marketplaces, or you need rules like "route B2B orders over $5,000 to manual approval".
-
Specialist middleware: your ERP is older, heavily customized or on-premise, and has no certified Shopify app.
-
Custom build: the workflow itself is a competitive advantage, and you have a team that will own it for years.
The tie-breaker is maintenance. Shopify ships a new Admin API version four times a year (Shopify API versioning). Ask who will update the integration after the next four releases. If the honest answer is "nobody", pay for an option with a vendor behind it.
What is the Shopify Global ERP Program?
The Shopify Global ERP Program lets selected ERP vendors build direct, Shopify-certified integrations listed in the Shopify App Store. It launched in October 2021 with Microsoft Dynamics 365 Business Central, Oracle NetSuite, Infor, Acumatica and Brightpearl, with more partners promised (Shopify announcement). It is an extension of the Shopify Plus Certified App Partner Program, and Shopify's engineers support partners as they build (KMWorld coverage).
Why it matters to you: a certified connector comes from the ERP vendor itself, so it is more likely to keep pace with Shopify's API changes than a one-off custom build. Industry analysts noted the program mainly helps lower mid-market brands that have outgrown QuickBooks but don't run SAP or Oracle (TechTarget analysis).
Shopify API limits every ERP integration must respect in 2026
These limits apply to every connector, iPaaS and custom build equally. They decide which sync patterns are even possible, so check them before you compare vendors.
|
Limit |
What Shopify documents |
What it means for your ERP sync |
|---|---|---|
|
GraphQL Admin API rate limit |
100 points/second on standard plans, 200 on Advanced, 1,000 on Plus, 2,000 on Commerce Components (Shopify GraphQL rate limits) |
Polling the full catalog every few minutes won't fit. Use webhooks and update only what changed. |
|
Maximum cost of one query |
1,000 points, on any plan (Shopify query cost limits) |
Large reads must be paginated or run as bulk operations. |
|
Bulk operations |
Not subject to the single-query cost and rate limits (Shopify bulk operations guidance) |
Use them for the first catalog load and nightly reconciliation. |
|
Array inputs |
Maximum 250 items per array on every Shopify API (Shopify input limits) |
Batch stock and price updates in chunks of 250. |
|
Webhook delivery |
Duplicates are possible; failed deliveries are retried 8 times over 4 hours (Shopify webhook delivery docs) |
Make every handler duplicate-safe using the delivery ID, and run a reconciliation job for anything missed. |
|
REST Admin API |
Legacy since October 1, 2024; new public apps must use GraphQL since April 1, 2025 (Shopify REST Admin API status) |
Build any new integration on GraphQL. Ask vendors which API they use. |
|
Variants per product |
Up to 2,048, up from 100 (Shopify 2,048 variants announcement) |
Confirm your connector handles large product families without dropping SKUs. |
|
Protected customer data |
Apps using customer name, address, phone or email must meet Level 1 and Level 2 data-protection requirements (Shopify protected customer data rules) |
Ask whether the connector is approved for customer fields before you rely on customer sync. |
|
API versions |
A new Admin API version four times a year (Shopify API versioning) |
Budget a quarterly maintenance check. |
What Shopify Flow can and can't do: Flow is great for simple rules, like tagging B2B orders or alerting staff when stock is low. It is not an integration platform. Keep ERP logic in your connector or iPaaS so there is one place to debug.
The 10 best ERP systems for Shopify in 2026
The best ERP for Shopify depends on your business model (retail, wholesale, manufacturing or a mix) far more than on feature lists. Here is how the ten we see most often compare.
|
ERP |
Best for |
How it connects to Shopify |
Global ERP Program launch partner |
Relative cost |
|---|---|---|---|---|
|
Oracle NetSuite |
Multi-entity, fast-growing mid-market brands |
NetSuite Connector, Celigo or other iPaaS |
Yes |
High |
|
Microsoft Dynamics 365 Business Central |
SMB and mid-market teams on Microsoft 365 |
Built-in Shopify Connector |
Yes |
Mid |
|
Acumatica |
Mid-market distributors and light manufacturers |
Acumatica Commerce Edition connector |
Yes |
Mid |
|
Brightpearl by Sage |
Omnichannel retail and wholesale |
Native Shopify integration |
Yes |
Mid |
|
Infor CloudSuite |
Enterprise, industry-specific operations |
Infor's certified Shopify integration |
Yes |
High |
|
SAP Business One / S/4HANA |
SMB (B1) to large enterprise (S/4HANA) |
iPaaS, SAP partner add-ons or custom |
No |
High |
|
Odoo |
Cost-conscious brands wanting modular apps |
Third-party connectors or iPaaS |
No |
Low to mid |
|
QuickBooks Enterprise |
US SMBs needing accounting plus advanced inventory |
Third-party sync apps |
No |
Low |
|
Oracle Fusion Cloud ERP |
Large enterprises with complex finance |
iPaaS or custom |
No |
High |
|
Aptean, Apprise, Blue Cherry |
Food and process manufacturing, consumer goods distribution, fashion |
Middleware or custom |
No |
Mid to high |
1. Shopify NetSuite integration (Oracle NetSuite)

NetSuite is a cloud ERP covering accounting, order management, inventory, warehouse management and production planning in one system. It shines for brands running several subsidiaries, currencies or Shopify expansion stores.
- Connects via: Oracle's NetSuite Connector, Celigo or another iPaaS.
- Watch out for: total cost. Licences and implementation are significant, and custom logic (SuiteScript) needs a NetSuite partner.
2. Shopify and Microsoft Dynamics 365 Business Central integration

Business Central ships with a built-in Shopify Connector made by Microsoft. It supports more than one Shopify shop and syncs items, variants, barcodes, prices, inventory, metafields, customers and B2B companies. It imports orders, syncs shipments back to Shopify and receives Shopify Payments payout data (Microsoft Learn: Shopify Connector overview).
- Connects via: the free built-in connector, installed from the Shopify App Store.
- Watch out for: testing. Microsoft recommends pairing a Shopify sandbox with a Business Central sandbox, and turning off "Allow Data Sync to Shopify" if you test a Business Central sandbox against a live store (Microsoft Learn: get started).
3. Shopify Acumatica integration

Acumatica is a cloud-native ERP for mid-market distributors, manufacturers and retailers. Pricing is based on resources used rather than per user, which helps when many warehouse and finance staff need access.
- Connects via: Acumatica's Commerce Edition Shopify connector.
- Watch out for: it is implemented through Acumatica partners, so partner quality matters as much as the software.
4. Brightpearl Shopify integration (Brightpearl by Sage)

Brightpearl was built for retailers and wholesalers selling across Shopify, marketplaces and physical stores. It automates order routing, inventory, purchasing, accounting and returns. Sage acquired Brightpearl in 2022.
- Connects via: a native Shopify integration.
- Watch out for: it is strongest for retail and wholesale, weaker for manufacturing.
5. Shopify Infor integration (Infor CloudSuite)

Infor sells industry-specific ERP suites for sectors such as distribution, fashion and food and beverage. It was one of the five Global ERP Program launch partners.
- Connects via: Infor's certified Shopify integration.
- Watch out for: an enterprise-scale project that usually needs a systems integrator.
6. Shopify SAP integration (SAP Business One and S/4HANA)

SAP Business One serves small and mid-sized companies; S/4HANA serves large enterprises. Neither was a Global ERP Program launch partner, so most Shopify SAP integrations run through an iPaaS, an SAP partner add-on or a custom build.
- Connects via: iPaaS (MuleSoft, Boomi, Celigo) or SAP partner connectors.
- Watch out for: budget for an integration partner who knows both SAP and Shopify's GraphQL API.
7. Shopify Odoo integration

Odoo is a modular suite with apps for accounting, inventory, CRM, manufacturing and ecommerce, available in the cloud or on-premise. It is often the most affordable route to a full ERP.
- Connects via: third-party connectors from the Odoo Apps store, or an iPaaS.
- Watch out for: connector quality varies widely. Test refunds, multi-location stock and taxes before go-live.
8. QuickBooks Enterprise and Shopify

QuickBooks Enterprise is accounting software with advanced inventory, pricing rules and reporting. It is a sensible step for US SMBs that aren't ready for a full ERP.
- Connects via: third-party sync apps.
- Watch out for: brands with several warehouses, legal entities or manufacturing usually outgrow it.
9. Shopify Oracle Fusion Cloud ERP integration

Oracle Fusion Cloud ERP is Oracle's enterprise suite, with deep financials and built-in AI. It suits large organizations already standardized on Oracle.
- Connects via: iPaaS or a custom integration.
- Watch out for: it is overkill for most Shopify brands; NetSuite is Oracle's practical mid-market option.
10. Industry ERPs for Shopify: Aptean, Apprise and Blue Cherry

Aptean covers process manufacturing and food and beverage, with recipe management, lot traceability and compliance tools. Apprise targets consumer goods distributors and importers, with built-in EDI, chargeback management and landed-cost profitability. Blue Cherry serves fashion, apparel and footwear, with production planning and size-and-colour inventory.
- Connects via: middleware or custom integration.
- Watch out for: confirm the vendor has live Shopify customers before you sign.
Let's Build Your Custom Shopify Store
We help you build a Shopify store that fits your brand perfectly.
Get in touchHow to choose the best ERP for your Shopify store
Start with your business model, then check the connector, then compare price. Buying the ERP first and discovering connector gaps later is the most expensive order to do it in.
|
Your situation |
ERPs to shortlist |
|---|---|
|
Mostly DTC, one warehouse, accounting is the main pain |
QuickBooks Enterprise, Odoo, or an inventory app before a full ERP |
|
DTC plus wholesale, one to three warehouses |
Brightpearl, Business Central, Acumatica |
|
Several entities, currencies or Shopify Plus expansion stores |
NetSuite, Business Central, Acumatica |
|
Manufacturing, recipes or regulated products |
Aptean, Acumatica, Infor, Odoo |
|
Fashion with size and colour matrices and wholesale seasons |
Blue Cherry, Infor, Brightpearl |
|
Enterprise already running SAP or Oracle |
Keep the ERP; integrate through an iPaaS |
Then ask every connector vendor these questions. The right-hand column is what a good answer sounds like.
|
Question to ask |
A good answer |
|---|---|
|
How do you handle partial refunds, exchanges and returns to another location? |
"Each becomes a credit note against the original order, at the right location." |
|
Do you support Shopify B2B companies, catalogs and payment terms? |
"Yes, and ERP credit limits and terms drive what the buyer sees." |
|
Do you sync inventory per location? |
"Yes, available quantity per location, with optional buffers." |
|
Which Shopify API do you use, and do you support 2,048 variants? |
"GraphQL Admin API, with bulk operations for large catalogs." |
|
What happens when a sync fails at 2 a.m.? |
"It's queued, retried without duplicates, logged with the payload, and a named person is alerted." |
|
Who updates the connector when Shopify releases a new API version? |
"We do, every quarter, at no extra cost." |
How to integrate Shopify with an ERP: a 7-step process
This is the order we follow on integration projects. Most blown budgets trace back to skipping steps 1 and 2, because mapping problems found after go-live get fixed with live orders on the line.
|
Step |
Typical duration |
Who's involved |
Deliverable |
|---|---|---|---|
|
1. Agree data ownership |
1 to 2 weeks |
Operations, finance, integration partner |
Signed data ownership table |
|
2. Clean and map data |
1 to 3 weeks |
Operations, ERP admin |
Completed field-mapping sheet |
|
3. Choose the method and vendor |
About 1 week |
Leadership, integration partner |
Signed connector or iPaaS contract |
|
4. Set up sandboxes |
2 to 5 days |
Developer, ERP admin |
Connected test store and ERP test company |
|
5. Build and configure |
1 to 6 weeks |
Developer or connector vendor |
Working flows for every row of the ownership table |
|
6. Test the awkward orders |
1 to 2 weeks |
Operations, finance |
Signed-off test log |
|
7. Go live and reconcile |
2 weeks of close monitoring |
Everyone above |
Daily reconciliation reports, error alerts live |
- Agree who owns each data type. Use the ownership table above. One signed page prevents most later arguments.
- Clean and map your data. SKUs must match exactly in both systems, with no blanks or duplicates. Map tax codes, locations, payment and shipping methods, discounts, gift cards, B2B companies and metafields. Map Shopify order statuses to ERP statuses. Use the template below.
- Choose the method. Certified connector first, iPaaS second, custom last, using the decision rules above.
- Set up sandboxes. Connect a Shopify development store to an ERP test company. Never test against your live ledger.
- Build and configure. Create API credentials with only the access scopes you need. Use webhooks for orders, refunds and fulfillments; bulk operations for the first catalog load; and scheduled jobs for low-priority data. Make every webhook handler duplicate-safe.
- Test the awkward orders. Run split shipments, partial refunds, exchanges, stacked discounts, gift cards, multi-currency orders through Shopify Markets, POS orders, B2B orders on net terms, and cancellations after fulfillment. Each one must land in the ERP correctly.
- Go live, then reconcile. Launch in a quiet trading week, never in the run-up to Black Friday. For two weeks, compare order counts, revenue and stock between Shopify and the ERP every day, and route sync errors to a named person.
Shopify B2B and wholesale ERP integration
B2B is where generic connectors break most often, because wholesale logic lives in the ERP: account terms, credit limits, contract prices and invoices. Shopify's native B2B features model buyers as companies with locations, catalogs and payment terms, so the job is to map ERP accounts onto that structure. Check which B2B features your Shopify plan includes.
|
ERP concept |
Shopify B2B concept |
Direction |
|---|---|---|
|
Customer account |
Company |
ERP to Shopify |
|
Ship-to address |
Company location |
ERP to Shopify |
|
Price list or customer price group |
Catalog |
ERP to Shopify |
|
Payment terms (net 30, net 60) |
Payment terms |
ERP to Shopify |
|
Credit limit and account balance |
Stays in the ERP |
Checked before order release |
|
Customer PO number |
Order PO number |
Shopify to ERP |
|
Invoice and accounts receivable |
Stays in the ERP |
Invoice status can be shown in Shopify |
Our Shopify B2B and wholesale services page covers the storefront side of this.
Shopify Plus ERP integration: multi-store, Markets and POS
Shopify Plus brands usually have three extra problems: several stores feeding one ERP, several currencies, and retail POS.
- Expansion stores: treat each store as its own sales channel in the ERP, with a store code on every order. Business Central's connector, for example, supports more than one Shopify shop (Microsoft Learn).
- Shopify Markets and multi-currency: send both the customer's currency and your shop currency to the ERP, and decide which one finance books in. Get this wrong and revenue reports won't match payouts.
- POS orders: include the retail location on each order so stock is deducted from the right store, not the warehouse.
- More API headroom: Plus raises the GraphQL Admin API limit from 100 to 1,000 points per second (Shopify rate limits), which makes high-volume sync far easier, but it doesn't remove the need for webhooks and bulk operations.
See our Shopify Plus development services if you're moving to Plus as part of an ERP project.
Worked example: how one Shopify order should hit your ERP ledger
This is where integrations quietly go wrong. Here is one order traced end to end. The numbers are illustrative: an 8% sales tax and a 2.9% + $0.30 card fee, not your actual rates.
A customer buys two T-shirts at $40 each with a 10% discount code, pays $10 shipping and $5.76 tax. Total charged: $87.76. Shopify Payments takes a $2.85 fee, so the payout is $84.91. A week later, one shirt is returned and refunded at $36 plus $2.88 tax.
|
Event |
ERP account |
Debit |
Credit |
|---|---|---|---|
|
Order paid |
Shopify Payments clearing |
$87.76 |
|
|
Order paid |
Sales discounts |
$8.00 |
|
|
Order paid |
Product revenue |
$80.00 |
|
|
Order paid |
Shipping income |
$10.00 |
|
|
Order paid |
Sales tax payable |
$5.76 |
|
|
Payout lands |
Bank |
$84.91 |
|
|
Payout lands |
Payment processing fees |
$2.85 |
|
|
Payout lands |
Shopify Payments clearing |
$87.76 |
|
|
Partial refund |
Sales returns |
$36.00 |
|
|
Partial refund |
Sales tax payable |
$2.88 |
|
|
Partial refund |
Shopify Payments clearing |
$38.88 |
The common mistake is posting the $84.91 payout as revenue. That understates revenue, hides $2.85 of fees, and mixes tax you owe into sales. A clearing account, as above, keeps every Shopify payout matched to the bank to the cent.
How much does Shopify ERP integration cost in 2026?
Shopify ERP integration cost has four parts: the ERP licence, the connector or iPaaS subscription, one-time implementation (mapping, configuration, testing), and ongoing maintenance for Shopify's quarterly API releases. A certified connector on standard flows sits at the low end; a custom build across several stores and entities sits at the high end.
|
Cost line |
One-time or ongoing |
What drives it up |
|---|---|---|
|
ERP licence |
Ongoing |
Users, modules, entities |
|
Connector or iPaaS subscription |
Ongoing |
Order volume, number of flows and connected systems |
|
Implementation |
One-time |
Data cleanup, custom mapping, B2B and multi-store logic |
|
Maintenance and support |
Ongoing |
API version updates, new channels, error monitoring |
Hidden costs teams forget to budget: cleaning duplicate SKUs before launch, staff time for testing, ERP partner hours for custom fields, extra iPaaS flows added after go-live, and someone on call during peak season.
Common Shopify ERP integration problems and how to fix them
|
Problem |
What you'll notice |
Fix |
|---|---|---|
|
Two systems both editing stock |
Counts drift; oversells |
One owner for inventory; the other is read-only |
|
SKU mismatches |
Orders fail to import for some products |
Lock SKU creation to one system; block blank or duplicate SKUs |
|
Duplicate webhook processing |
Double orders or double stock deductions |
Store each webhook delivery ID and skip repeats |
|
Missed webhooks during an outage |
Orders missing from the ERP |
Nightly reconciliation job using Shopify's API |
|
Full-catalog polling |
Rate-limit errors; slow apps |
Sync on change; bulk operations for large reads |
|
Refunds and payouts not mapped |
Finance back on spreadsheets |
Map refunds to credit notes and payouts to a clearing account |
|
Theme or app customizations clash with ERP data |
Missing or wrong fields in orders |
List every app that writes order data (bundles, subscriptions) and map its fields |
|
Integration scales badly |
Lag at 1,000+ orders a day |
Load-test with peak volume before BFCM |
|
No error owner |
Silent failures for days |
Alerts to a named person, with the failed payload attached |
|
Budget overruns |
Change requests pile up |
Freeze scope after the mapping sheet is signed |
Shopify ERP go-live checklist
- Data ownership table signed by operations and finance
- Field-mapping sheet complete and reviewed
- Every SKU matches in both systems; no blanks or duplicates
- Awkward-order test log signed off (refunds, exchanges, gift cards, multi-currency, B2B, POS)
- Webhook handlers tested for duplicate deliveries
- Nightly reconciliation job running
- Error alerts going to a named person and a backup
- Rollback plan written, with who can trigger it
- Plan for orders placed during the cutover window
- Launch date outside your peak season, with the team available for the first three days
KPIs to track after your Shopify ERP integration goes live
These are sensible starting targets; tune them to your volume.
|
KPI |
How to measure |
Starting target |
|---|---|---|
|
Order sync time |
Minutes from Shopify payment to ERP sales order |
Under 5 minutes |
|
Sync error rate |
Failed transactions / total transactions |
Under 1%, none unresolved after 24 hours |
|
Reconciliation differences |
Orders or revenue that differ between systems each day |
Zero after week two |
|
Oversold orders |
Orders cancelled for lack of stock |
Zero on buffered SKUs |
|
Inventory accuracy |
Cycle count vs system quantity |
98% or higher |
|
Days to close |
Working days to close the month |
Down from your baseline |
For peak-season prep, our Shopify BFCM checklist covers what to freeze before traffic spikes.
Shopify ERP integration FAQs
Q: Is Shopify an ERP system?
No. Shopify is a commerce platform that runs your storefront, checkout, orders, payments and stock per location. It does not include a general ledger, multi-entity accounting, landed costs or production planning. Brands that need those connect Shopify to an ERP such as NetSuite, Business Central or Acumatica.
Q: Can Shopify integrate with an ERP?
Yes. Shopify connects to ERPs through certified apps in the Shopify App Store, integration platforms such as Celigo or Boomi, specialist middleware, or custom builds on the GraphQL Admin API. Its Global ERP Program launched with certified connectors for Business Central, NetSuite, Infor, Acumatica and Brightpearl.
Q: What is the best ERP for Shopify?
There is no single best ERP for Shopify. NetSuite suits multi-entity growth brands, Business Central suits Microsoft-based SMBs, Brightpearl suits omnichannel retail and wholesale, and Acumatica suits mid-market distributors. Choose by business model first, then by connector quality, then by price.
Q: What is the best ERP for a small Shopify business?
Many small Shopify businesses don't need a full ERP yet. An accounting app plus an inventory app often covers one warehouse and one entity. When you outgrow that, Odoo, QuickBooks Enterprise and Business Central are the usual first ERPs because of lower cost and simpler setup.
Q: Does Shopify integrate with NetSuite?
Yes. Oracle NetSuite was a Global ERP Program launch partner and connects through Oracle's NetSuite Connector or iPaaS platforms such as Celigo. It is a common choice for brands with several subsidiaries, currencies or Shopify Plus expansion stores.
Q: Does Shopify integrate with SAP?
Yes. SAP Business One and SAP S/4HANA connect to Shopify through iPaaS platforms, SAP partner add-ons or custom integrations. SAP was not a Global ERP Program launch partner, so plan for an integration partner who knows both systems.
Q: Does Shopify integrate with Microsoft Dynamics 365?
Yes. Dynamics 365 Business Central includes a built-in Shopify Connector from Microsoft that syncs products, inventory, prices, customers, B2B companies, orders, shipments and Shopify Payments payouts, and supports more than one Shopify store.
Q: Do I need Shopify Plus for ERP integration?
No. Most ERP connectors work on standard Shopify plans. Shopify Plus raises the GraphQL Admin API limit from 100 to 1,000 points per second and adds expansion stores, which matters for high-volume, multi-store or international brands.
Q: How long does Shopify ERP integration take?
A certified connector on standard flows can go live in days to a few weeks. An iPaaS project usually takes three to eight weeks. A custom integration often runs two to four months or more, with most of the time spent on data mapping and testing.
Q: How much does Shopify ERP integration cost?
Cost depends on four parts: the ERP licence, the connector or iPaaS subscription, one-time implementation, and ongoing maintenance for Shopify's quarterly API releases. A certified connector on standard flows is the cheapest route; a custom multi-store build is the most expensive. [ADD: Crawlapps price ranges.]
Q: How often should inventory sync between Shopify and an ERP?
It depends on how fast each product sells. Slow movers can sync every 15 to 60 minutes. Core products should sync on every change. Fast movers, drops and flash-sale items need event-driven sync plus a small safety buffer held back from Shopify's available quantity.
Q: Can I connect multiple Shopify stores to one ERP?
Yes. Treat each store as its own sales channel in the ERP and tag every order with a store code. Several connectors, including Business Central's, support multiple Shopify shops, and iPaaS platforms can route any number of stores into one ERP.
Your next step
Before you speak to any ERP vendor, fill in the data ownership table and the field-mapping template above with your operations and finance leads. Those two documents will tell you which ERP fits, which connection method you need, and how big the project really is. Want a second pair of eyes? Get a free Shopify audit from Crawlapps and we'll review your setup.