Once a store runs on an ERP, the ERP is usually the source of truth for products, stock and costs, and Shopify becomes one sales channel feeding it orders. That works well for plain variants. It gets trickier when products carry customer personalization, add-on fees or options that don't exist in the ERP item master.
Popular ERP + Shopify
- NetSuite. A common choice for growing brands, usually connected through a packaged connector or an integration platform.
- Microsoft Dynamics 365 Business Central. Popular with companies already on Microsoft tools.
- SAP S/4HANA and SAP Business One. Larger companies, almost always connected through middleware.
- Odoo. Open source and modular; several Shopify connectors are available for it.
- QuickBooks and similar accounting tools. Not a full ERP, but where many small stores start. See syncing options with QuickBooks.
Sync patterns
| Data | Usual direction | Typical frequency |
|---|---|---|
| Products, variants, SKUs | ERP to Shopify | On change, or nightly |
| Inventory levels | ERP to Shopify | Every few minutes to hourly |
| Prices | ERP to Shopify | On change |
| Orders, including personalization | Shopify to ERP | As close to real time as possible |
| Customers, refunds, returns | Shopify to ERP | On change |
| Fulfillment and tracking | ERP or WMS to Shopify | On shipment |
Decide the owner of each field before you connect anything. If both systems can edit a price, sooner or later one will overwrite the other.
Variant matching
ERPs usually model a product as an item with attributes, or as a parent item with child items. Shopify models it as a product with up to three options and their variants. The integration has to translate one into the other, and the SKU is the key that ties them together.
- Give every Shopify variant a unique SKU that matches the ERP item code exactly. Our variant SKU strategy guide suggests a readable pattern.
- Use the same option names and values on both sides: "Navy", not "Navy" in one place and "NVY" in the other.
- Remember Shopify's limit of three options per product. If the ERP has four attributes, one has to be merged or moved elsewhere.
- Run a test sync on a handful of products and compare the results line by line before turning on the full catalog.
Personalization and add-on data
This is where most ERP projects trip up. A custom name, a chosen font or an uploaded photo isn't an ERP item. In Shopify it's stored as line-item properties on the order line, separate from the variant. Read variant vs line-item property if the difference is new to you.
Make sure your connector carries those properties into the ERP sales order, usually as line notes or custom fields, so production can see "Name: Emma, Font: Playfair, Color: Gold". Print It My Way saves every personalization as line-item properties on the order, so any connector that reads order lines can pass it along.
Add-on fees need a plan too. When a store charges, say, $5 for engraving, the fee shows as its own cart line. Map that line to a service or non-stock item in the ERP so revenue lands in the right account and inventory isn't touched.
Integration apps
You have three broad routes:
- Packaged connectors built for one ERP and Shopify. Fastest to set up; less flexible.
- Integration platforms (iPaaS) such as Celigo, Boomi or Workato. Flexible field mapping and error handling, at a higher cost.
- Custom integration built on the Shopify Admin API and webhooks. Full control, and you own the maintenance. Our notes on the Admin API for options are a good starting point for a developer.
Costs vary widely by ERP, order volume and how much custom mapping you need, so get quotes based on your actual catalog and order flow.
Common mistakes
- Letting staff edit products in Shopify when the ERP owns them. The next sync wipes the change.
- Missing or duplicate SKUs, so orders arrive in the ERP with no item to match.
- Dropping line-item properties in the connector, so production gets "Mug, White" with no name.
- No alert on failed syncs. Check the error log daily for the first few weeks, and consider webhooks for variant changes so the ERP hears about edits right away.
Frequently asked questions
How to integrate Shopify with NetSuite?
Most stores use a packaged connector or an integration platform such as Celigo. Larger teams sometimes build a custom integration with SuiteScript and the Shopify Admin API.
Bi-directional sync for options + variants?
Most connectors and integration platforms support two-way sync. Set a clear owner for each field, usually the ERP for products, stock and prices and Shopify for orders.
SAP + Shopify integration?
SAP is usually connected through middleware such as Boomi or MuleSoft, or a connector from an SAP partner. Plan the SKU and attribute mapping carefully before starting.
Odoo + Shopify?
Several Shopify connectors are available for Odoo that sync products, stock and orders. Compare how each one handles variants and order line properties before choosing.
How to handle variant mismatch?
Match every Shopify variant to an ERP item by SKU and use identical option values on both sides. Run a test sync on a few products and fix gaps before syncing the whole catalog.
Real-time or batch sync?
Send orders to the ERP in near real time so production starts quickly. Large catalog and price updates are fine as a nightly batch.
ERP integration cost?
It depends on the ERP, your order volume and how much custom mapping is needed. Packaged connectors cost the least; custom builds cost the most and need ongoing maintenance.
Best for mid-market Shopify + ERP?
There is no single best choice. Mid-sized stores often pair NetSuite, Business Central or Odoo with a packaged connector or an integration platform like Celigo.
Related reading
Sources & further reading
Primary sources referenced in this article. We link to official platform documentation and standards bodies rather than secondary summaries so you can verify claims directly.
- Shopify Help Center: Product variants
- Shopify.dev: Product variant limits
- Shopify Help Center: Line item properties (customization)
Try it free on Shopify
Print It My Way's permanent Free plan includes live preview, custom options, and Cart Transform pricing.
Install Print It My Way