Connecting Shopify to Business Central
Microsoft Business Central is a popular ERP for growing businesses. Connecting it to Shopify synchronizes ecommerce operations with broader business management: finance, inventory, purchasing, and fulfillment.
This integration is well-trodden ground with multiple approaches. Understanding the options helps you choose correctly.
Integration Approaches
Three main approaches exist for connecting Shopify and Business Central.
Native Microsoft connector
Microsoft provides a built-in Shopify connector in Business Central. It handles:
- Product sync from Business Central to Shopify
- Inventory sync between systems
- Order import from Shopify to Business Central
- Customer sync
Advantages:
- No additional licensing cost
- Supported by Microsoft
- Integrated into Business Central UI
Limitations:
- Fixed data model with limited customization
- May not handle complex variant structures
- Limited error handling visibility
- Updates depend on Microsoft's roadmap
Middleware platforms
iPaaS platforms like Celigo, Boomi, or Workato provide pre-built connectors for both systems with configuration options.
Advantages:
- More flexible data transformation
- Visual configuration interfaces
- Monitoring and alerting capabilities
- Vendor support for both connectors
Limitations:
- Additional licensing cost
- Still limited by connector capabilities
- May require customization for complex logic
Custom integration
Building custom integration using Shopify and Business Central APIs provides maximum control.
Advantages:
- Exact data mappings for your requirements
- Custom business logic implementation
- Full error handling control
- No connector limitations
Limitations:
- Higher development cost
- Ongoing maintenance responsibility
- Requires expertise in both platforms
Data Flows to Consider
Plan which data flows between systems and in which direction.
Products
Typically Business Central is the product master. Products are created and managed there, then synced to Shopify. Consider:
- Which product data syncs (title, description, price, weight)
- How variants map between systems
- Whether product images sync or are managed separately
- How product updates propagate
Inventory
Inventory usually flows from Business Central (or warehouse systems feeding BC) to Shopify. Questions to answer:
- Sync frequency: real-time, hourly, daily?
- How to handle multiple locations
- Buffer stock: reduce displayed inventory by safety margin?
- What happens when sync fails
Orders
Orders flow from Shopify to Business Central for fulfillment and accounting. Consider:
- When orders sync: immediately, hourly, on payment capture?
- How to map Shopify payment methods to BC payment terms
- Handling of discounts and promotions
- Tax calculation consistency
Customers
Customer sync direction depends on your business. Ecommerce-first businesses may have Shopify as customer master. Traditional businesses may have BC as master.
- Which system creates customer records?
- How do you match customers between systems?
- Which customer fields sync?
Fulfillment
Once orders are fulfilled in Business Central, tracking information needs to return to Shopify.
- How fulfillment status updates Shopify
- Tracking number transmission
- Partial fulfillment handling
Common Challenges
Specific issues frequently arise in Business Central integrations.
Product identifier mismatch
Shopify uses product IDs and variant IDs. Business Central uses item numbers. Mapping between them is essential. Options:
- Store BC item number in Shopify SKU field
- Use a mapping table maintained in your integration
- Store Shopify ID as a custom field in BC
Variant complexity
Shopify variants (size, color) may not map cleanly to BC item variants or attributes. Plan the mapping carefully for products with multiple options.
Pricing tiers
Business Central supports complex pricing with customer groups, quantity breaks, and time-based pricing. Shopify's pricing model is simpler. Decide how BC pricing translates to Shopify, especially for B2B scenarios.
Tax handling
Tax calculations differ between systems. Shopify calculates tax at checkout. BC has its own tax engine. Ensure consistency to avoid discrepancies in financial records.
Multi-currency
If you sell in multiple currencies via Shopify Markets, plan how currencies flow to BC. BC handles multi-currency but configuration is required.
Implementation Recommendations
Based on experience with these integrations:
Start with native connector
If your requirements are standard, try Microsoft's native connector first. It may be sufficient and costs nothing additional.
Document data mapping exhaustively
Before building or configuring anything, document exactly which fields map between systems. Gaps in mapping cause integration failures.
Plan for errors
Sync will fail sometimes. Plan how failures are detected, logged, and resolved. Silent failures are worse than loud ones.
Test with realistic data
Test with production-like data volumes and edge cases. What works with 10 products may fail with 10,000.
For integration planning, see Shopify integrations.
Working with LiftKit Digital
LiftKit Digital has implemented Shopify to Business Central integrations using native connectors, middleware, and custom development. We assess your requirements and recommend the right approach.
To discuss your integration needs, get in touch.