Technical6 min read

Connecting an e-commerce platform to D365 F&O: integration options

Connect an e-commerce site to D365 F&O: OData, custom services, batch data APIs, business events, partner connector or Dynamics 365 Commerce.

The short answer

To connect an e-commerce platform to Dynamics 365 Finance & Operations, you usually combine several integration patterns documented by Microsoft: OData on data entities for real-time single-record exchanges (create an order, read a status), asynchronous data APIs (DMF package, recurring integrations) for volumes (catalogue, prices, stock), custom services for logic that matches no entity (computed availability), and business events to push changes to the platform.

You can also rely on a partner connector or middleware or, depending on scope, on Dynamics 365 Commerce, Microsoft's commerce application.

Which pattern for which flow?

  • Web orders to F&O: OData (single synchronous create) or, at high volume, asynchronous batch import.
  • Catalogue and prices to the site: export through a data entity, usually scheduled (DMF package API or recurring integration).
  • Available stock: Microsoft cites real-time inventory lookup precisely as a custom service use case. See custom service vs OData action.
  • Order status, shipment, invoice: business events to Service Bus, Event Grid or Power Automate, or on-demand OData reads.
  • Customers: OData or batch import depending on volume.

Microsoft notes that volumes quoted in its scenarios are for choosing a pattern, not system limits.

Connector, middleware or development?

  • Partner connector: quick to set up for a widespread platform; check covered flows, error handling and ability to include your customisations.
  • Middleware (iPaaS, Azure Logic Apps…): decouples systems, centralises transformations and monitoring; requires operations.
  • Direct development: relevant for simple, stable flows; requires handling retries, idempotency and logging.

In every case, the quality of the data entities F&O exposes drives the quality of the integration.

Common mistakes

  • Making single OData calls to sync the whole catalogue: prefer asynchronous APIs.
  • Querying F&O on every page view for stock: expensive; plan a cache or a dedicated service.
  • Ignoring the API service protection limits (throttling) documented by Microsoft.
  • Not planning retries: a lost web order is a lost customer.
  • Letting each flow handle its own errors with no common monitoring.

And at Skalp AI?

Orders, stock, prices: each flow relies on data entities, services or business events on the F&O side. Skalp AI does not connect the platform: you plug in your interfaces; Skalp can generate the D365 F&O side (data entities, classes, parameters). See ERP e-commerce integration and D365 F&O API interfaces, the bigger picture in building X++ without a consultant in 2026, and the Basic, Pro and Max plans (1 credit, ≈ €400 on Basic, €200 on Pro, consumed only when the code is generated).

See also: EDI DESADV in D365 F&O and AI ticket creation in D365 F&O.

Sources

Frequently asked questions

Is OData enough to connect an e-commerce site?

For real-time single-record exchanges, yes. For volumes (catalogue, prices), Microsoft points to asynchronous batch APIs.

How do you push an order status to the site?

With a business event (to Service Bus, Event Grid or Power Automate), or with an on-demand OData read from the site.

Do you need Dynamics 365 Commerce to sell online?

No. It is one Microsoft option; you can also connect an existing platform through F&O integration patterns, a connector or middleware.

Ready to transform your D365?

Join the CIOs who develop their D365 tickets in 2–4 h for 1 credit (≈ €400 on Basic, €200 on Pro).