Skip to content
SAP, DATEV and Dynamics experts

Microsoft Dynamics 365 Shop Integration: Data Flows Instead of Silos

We connect Microsoft Dynamics 365 Business Central bidirectionally with your online shop — product master data, price lists, stock levels and orders synchronize automatically. Fixed price from 6,900 € net after an upfront system analysis.

Dynamics connection from 6,900 € net Cloud and on-premises Real-time synchronization

since 2013

integration experience

6

core data flows bidirectional

2 weeks

hypercare after go-live

50+

integration projects

Fixed price · net plus VAT

from 6,900 € fixed price net
  • Fixed price per standard connection instead of an open estimate
  • Cloud and on-premises through the same abstracted shop adapter
  • Products, stock, prices and orders synchronized bidirectionally
  • Ongoing Microsoft and connector licenses shown separately

Standard scope (products, stock, prices, orders) as a fixed price. Custom extensions and AL custom APIs on a time basis, project day 990 € net (hourly rate 119 €). The system analysis is credited toward the project on commissioning. All prices net plus VAT. The project day is a package price for a reserved working day and therefore deliberately not a multiple of the hourly rate — the rationale is on the pricing overview.

Microsoft Dynamics 365 Business Central (formerly Dynamics NAV/Navision) is the ERP solution deployed in many mid-market trading and service companies. Integration with an online shop is among the most common requirements from our clients. As a specialized integration agency, we know the Dynamics API landscape in detail: OData endpoints, custom APIs, webhooks and the specifics of the cloud and on-premises variants.

Bidirectional Data Flow Between Shop and Dynamics 365

Bidirectional data flow
Shop and Dynamics 365 in automatic sync
Orders flow into Business Central; products, stock and prices flow back into the shop — through a middleware with queue and retry. Illustrative representation — values are examples.
Online shop
Middleware hub
Dynamics 365 BC
Shop → Dynamics 365write
Orders as sales orders
New customers as debtor accounts
Payment and status feedback
Dynamics 365 → Shopread
Product master data and variants
Price lists, discounts, tiers
Stock levels per location
Sync success rate99.7 %last 24 hours
Avg. OData latency0.8 swithin rate limit
Orders today1,284+12 % vs. yesterday
Recent synchronization runs
Item master · 2,847 records OK · 0.6 s
Stock levels · 12,091 records OK · 1.1 s
Price lists · 487 records OK · 0.4 s
Queue & retryno data loss during updates
Fixed priceDynamics connection from 6,900 € net
Orders flow into Business Central; products, stock and prices flow back into the shop — through a middleware with queue and retry. Fixed price from 6,900 € net. Illustrative representation — values are examples.

The six core data flows of a Dynamics shop integration

Product master data

Item numbers, names, descriptions, units, weights and variants are synchronized from Dynamics to the shop. Item categories and attributes are mapped so the shop navigation reflects the ERP structure.

Price lists and discounts

Dynamics price lists with customer price groups, line discounts and time-limited campaign prices are mapped in the shop. Synchronization considers currencies, tax rates and volume tiers.

Stock levels and locations

Available quantities per location, incoming orders and reserved stock are synchronized at defined intervals. Multi-location management and location-based availability displays are implementable.

Order processing

Shop orders are created as sales orders in Dynamics. Order confirmations, delivery notes and invoices flow back to the shop and inform the customer about the processing status.

Debtors and contacts

Customer master data, delivery addresses, payment terms and credit limits are bidirectionally synchronized. New customer registrations in the shop automatically create debtor accounts in Dynamics.

Invoices and documents

Dynamics invoices are made available as PDF downloads in the shop. Payment receipts update the document status in Dynamics. Optional: forwarding to DATEV for financial accounting.

Dynamics 365 Business Central: cloud and on-premises

Two deployment variants, one integration approach

Microsoft offers Dynamics 365 Business Central both as a cloud solution (SaaS) and as an on-premises installation. The integration architecture differs by deployment, but the goal stays the same: end-to-end data flows without manual transfer.

  • Cloud (SaaS): standardized REST/OData APIs, authentication via Azure Active Directory
  • On-premises: additionally SOAP web services and direct database access available
  • We choose the optimal approach based on your specific installation
Cloud (SaaS)Standard
Microsoft-hosted · semi-annual updates
APIREST / OData v4
AuthAzure AD / OAuth 2.0
EventsWebhooks + polling
Rate limit6,000 calls per hour
On-PremisesFlexible
Customer-hosted · full control
APIREST + SOAP
AuthCertificate / VPN
DataDirect DB access
Rate limitno central limit
One middleware adapter abstracts both variants — the shop code stays identical

Abstraction lowers maintenance effort

Our middleware encapsulates the Dynamics-specific API details. When Microsoft adjusts the cloud interfaces as part of the semi-annual updates, shop-side changes stay reduced to a minimum. With on-premises installations, you control the update timing yourself and gain additional planning security for the interfaces.

Technical integration options for Dynamics 365

Dynamics 365 Business Central offers multiple integration paths that can be combined as needed. The choice of the optimal approach depends on data volume, latency requirements and the specific Business Central version.

REST/OData web APIs

Business Central's standard API endpoints provide access to master data and transactions via REST. Ideal for CRUD operations with moderate data volume. OAuth 2.0 authentication via Azure AD.

Custom APIs and extensions

For business logic that goes beyond the standard APIs, we develop AL-based custom APIs as Business Central extensions. These extend the API surface with project-specific endpoints and data structures.

Webhooks and event-driven

Business Central supports webhooks for real-time notifications on data changes. Combined with message queues, this enables event-driven integration with minimal latency and maximum decoupling.

Typical challenges in Dynamics integrations

The flexibility of Business Central brings three recurring themes that we account for architecturally from the start.

Customizations in the data model

Customized fields, user-defined tables and industry-specific extensions modify the data model. We analyze your specific Business Central configuration in detail and map all customizations in the integration architecture.

Complex pricing

Price lists with customer price groups, line discounts and time-based validity are evaluated in a hierarchy. For stable prices, we synchronize the calculated values; for highly dynamic scenarios, we call the Dynamics pricing in real time via the API.

Multi-location availability

Dynamics maintains separate stock per location. Together with you, we define which locations feed into the availability display and how reserved quantities are handled, then implement these business rules in the integration layer.

Unsure which data flows make sense for your Dynamics landscape?

We analyze your Business Central installation and outline a concrete integration strategy at a fixed price from 6,900 € net.

Our project approach for Dynamics integrations

Dynamics as part of an interchangeable architecture

One data hub instead of point-to-point sprawl

In many projects, Dynamics 365 is not the only system that needs to be connected to the shop. CRM data, PIM systems, logistics partners and DATEV accounting are frequent additional targets. Our middleware architecture embeds Dynamics as one of several data sources in a central platform.

  • New target systems such as marketplaces or B2B portals continue to use the existing Dynamics connection
  • The middleware delivers normalized data that every connected system can consume
  • In a later ERP switch, only the Dynamics connector is replaced, not the entire architecture
Middleware hub · normalization & routing
Dynamics 365 · ERPOnline shopPIM / CRMDATEV · accountingLogistics · shippingMarketplaces
Adding a new system = one new connector, the shop code stays untouched
In a later ERP switch, only the Dynamics connector is replaced

Concrete benefits from practice

Companies that implement their Dynamics integration professionally report clear efficiency gains: manual data transfer is eliminated, prices and stock are always current in the shop, and orders flow without media breaks from the web shop into order processing (project experience).

What a Dynamics connection costs

An open-ended effort estimate rarely suffices for a controlling sign-off. That is why we state a clear fixed price for the Microsoft Dynamics 365 connection. The final price depends on the scope of the data flows and the complexity of your Business Central configuration and is set bindingly after a short system analysis — with no hidden items. Ongoing Microsoft and connector licenses are shown transparently and separately from the service fixed price.

Fixed Prices for Your Dynamics 365 Connection

All prices net plus VAT. Every connection starts with a system analysis; the fixed price is then binding. Ongoing Microsoft and connector licenses are shown separately.

Recommended

Standard connection

Business Central connected to your shop via Shopware or the standard connector.

from 6,900 € fixed price net
  • Products, stock, prices and orders bidirectional
  • Master data mapping and transformation rules
  • Queue with automatic retry
  • Azure AD authentication and audit log
  • Setup, testing and go-live support
Request analysis

Custom extension

AL custom APIs, special logic and complex pricing on a time basis.

990 € project day, net (package price)
  • AL-based custom APIs as Business Central extensions
  • Complex real-time pricing via the API
  • Multi-instance and multi-company scenarios
  • Hourly rate 119 € net for smaller adjustments
  • Transparent effort estimate before start
Estimate effort

Additional systems

Connect accounting and marketplaces to the same middleware.

from 1,490 € per system net
  • DATEV connection from 1,490 € net
  • Marketplace connection per channel from 2,480 € net
  • Payment connection from 1,490 € net
  • Existing Dynamics connection is reused
  • One monitoring for all data flows
Request analysis

The system analysis is credited toward the project on commissioning. For Shopware or custom connections with extensive special logic, we state the range openly after the analysis. You receive a binding offer after the free initial analysis. All prices net, plus VAT.

Performance, security and reliable operations

Performance within the rate limits

The cloud version permits a defined number of API calls per minute. Batch requests, delta synchronization (changes only) and caching layers keep the load within these limits, even during intensive synchronization.

Asynchronous for large volumes

The middleware collects changes over defined time windows and transfers them in optimized batches. Order confirmations and status changes are received via webhooks; throughput grows with the data volume.

Azure AD and least privilege

Dedicated app registrations with minimally required permissions, complete logging via the Azure audit log. For on-premises we add IP whitelisting, certificate-based authentication and transport via VPN or TLS.

Fault tolerance and data integrity

Automatic retry mechanisms with exponential backoffs, dead-letter queues for failed messages and compensation transactions for inconsistent states. Every data flow lands in the audit log.

Real-time monitoring

Dashboards show the status of all synchronization processes and alert on anomalies. This way problems are detected before they affect business operations.

GDPR and GoBD

Personal data remains in the integration layer only as long as necessary; logs are deleted after configurable retention periods. The procedural documentation transparently describes all data flows and deletion periods.

From analysis to ongoing evolution

  1. Requirements analysis

    In structured workshops, we work out together with your team and your Dynamics consultant which data flows, which business rules apply and which volumes are to be expected. The result is a binding integration specification with data flow diagrams and mapping matrices.

  2. API experience from the start

    We know the typical pitfalls of the Business Central API landscape: pagination with large datasets, optimistic concurrency via ETags, webhook limitations and the specifics of multi-currency transactions. Known issues are addressed architecturally rather than discovered during testing.

  3. Documentation and knowledge transfer

    Every project delivers API specifications, mapping matrices, architecture diagrams and operations handbooks. In onboarding sessions we explain architecture decisions and typical troubleshooting scenarios, so your team can work confidently with the integration.

  4. Long-term support

    Microsoft publishes semi-annual major updates, Shopware CE receives regular core updates. Our maintenance packages include monitoring, adaptation to API changes in both systems and quarterly reviews of data quality, performance and error rates.

The essentials of Dynamics connectivity

  • Items, prices, stock, orders and documents synchronize bidirectionally between Dynamics 365 and the shop
  • Standard connection from 6,900 € net as a fixed price, extensions on a time basis (project day 990 € net)
  • Cloud and on-premises are supported through the same abstracted shop adapter
  • A central middleware keeps the architecture interchangeable and extensible
  • GDPR- and GoBD-compliant data processing is standard, not an add-on service

Our office in Söhlde near Hildesheim enables personal consulting in the Hanover and Hildesheim area. For clients outside the region, we work fully remotely with the same high quality standards and transparent processes. Contact us for a free initial consultation on your Dynamics environment.

Frequently asked questions about Dynamics integration

In-depth articles are available on the blog: Connecting Dynamics 365 Business Central to a Shop describes how the synchronization is built, Dynamics 365 BC: API v2.0 explains the upcoming connector migration, and API Versioning shows how interfaces survive version changes.

By submitting you consent to the processing of your details to handle this request. Details in our privacy policy.