Home Blog Dynamics 365 F&O Integration

Omni-Channel Mastery: BOPIS, Loyalty, and Promotions in Dynamics 365 F&O via Siya Connect

Connect your Adobe Commerce, Shopify, or BigCommerce storefront directly to the native retail engine of Microsoft Dynamics 365, and turn back-end complexity into a competitive retail advantage.

Architecture diagram showing Adobe Commerce, Shopify and BigCommerce storefronts integrating through Siya Connect with the Retail layer of Dynamics 365 F&O, including Retail Server/CSU, loyalty engine, pricing and promotions engine, and store POS.
How Siya Connect bridges your e-commerce storefront and the Retail layer of Dynamics 365 F&O, keeping inventory, loyalty, and pricing in one source of truth.

In enterprise retail, a beautiful e-commerce storefront is only as good as the infrastructure behind it. When high-volume digital touchpoints are not deeply integrated with your core ERP, the result is siloed loyalty data, broken promotional rules, and fragmented fulfillment experiences.

To unlock true omni-channel retail, you need more than standard point-to-point data synchronization. You need a high-performance retail engine that keeps your storefront and your ERP in lockstep. By integrating your digital storefront directly with the Retail capabilities of Microsoft Dynamics 365 Finance & Operations (D365 F&O), you turn back-end complexity into a competitive advantage.

What is Siya Connect? Siya Connect is the name for Siya Digital's custom integration between your e-commerce storefront, whether Adobe Commerce, Shopify, or BigCommerce, and the Retail layer of Dynamics 365 F&O. It is not an off-the-shelf product. It is an integration accelerator we design and build around your channels, catalog, and pricing rules, so D365 F&O keeps doing what it does best and the storefront surfaces it in real time.

Here is how Siya Connect orchestrates the three most critical, revenue-driving omni-channel features of modern retail, across whichever storefront you run.

Key takeaways

  • Siya Connect links Adobe Commerce, Shopify, or BigCommerce to the Retail layer of Dynamics 365 F&O as a custom integration, with no platform replacement.
  • BOPIS uses real-time Commerce Scale Unit queries for live per-store availability, not overnight batch files.
  • Loyalty points earned in any channel are available instantly in every channel, with safeguards against double-spend.
  • Dynamics 365 stays the single source of truth for pricing, so storefront prices always match the invoice.

1. Frictionless BOPIS (Buy Online, Pick Up In Store)

The customer expectation for Buy Online, Pick Up In Store is simple: clear availability online, a rapid confirmation email, and a ready-to-pick package waiting at the local store counter. Behind the scenes, this workflow requires real-time coordination across physical locations, global inventory books, and localized warehouse zones.

The Siya Connect blueprint

  • Real-time stock querying via the Retail Server. Siya Connect does not rely on flat batch file exports for store stock. It calls the Dynamics 365 F&O Retail Server (through its Commerce Scale Unit, or CSU) over high-speed OData APIs to pull live Available to Promise counts specific to each store's warehouse dimensions.
  • Automated order routing. The moment a pickup order is placed on the storefront, Siya Connect injects the payload into Dynamics 365 as a retail sales order flagged with the correct fulfillment channel type.
  • The operational result. Dynamics 365 immediately fires a localized picking directive to that store's POS terminal or mobile inventory app. Associates pick, pack, and stage the order within minutes of the digital purchase.

For retailers running high-volume pickup programs, this is the difference between an availability promise your stores can keep and one that generates cancellations and refunds.

2. Unified Omni-Channel Loyalty & Rewards

A disjointed loyalty program degrades the customer experience. If a customer earns 500 reward points shopping in-store over the weekend, those points must be instantly accessible when they log into their online account on Monday morning.

Dynamics 365 contains an enterprise-grade loyalty engine capable of handling multi-tier reward schemes, customized point-earning thresholds, and targeted redemption. Siya Connect makes this engine accessible to your storefront customer accounts.

Omni-channel loyalty mapping between storefront actions and Dynamics 365 retail events
Storefront customer actionDynamics 365 back-end retail event
Account creation or social loginGenerates a global loyalty card number and assigns it to the unique Party ID
Real-time cart checkoutQueries the CSU to validate the current point balance and maximum allowable point burn
Order invoice generatedPosts loyalty reward points to the ledger based on specific line-item thresholds

The Siya Connect blueprint

  • Bi-directional loyalty sync. Siya Connect acts as the secure, real-time communication pipeline. When a customer views their cart, the integration layer calls the Dynamics 365 Retail Server to dynamically retrieve their current point balance and evaluate their customer tier.
  • Point redemption safeguards. When points are redeemed at checkout, Siya Connect temporarily holds them within Dynamics 365, preventing the race condition where a customer might try to spend the same points online and at a physical register at once.

What this means for the business: a member's balance is the same number wherever they shop. That is the difference between a loyalty program customers trust and one they quietly stop using.

3. Dynamic Promotions & Advanced Pricing

Modern enterprise retailers rarely use flat pricing. They run mix-and-match discounts, threshold sales (spend $100, get 20% off), quantity breaks, and exclusive club-member markdowns. Trying to rebuild Dynamics 365's intricate retail pricing logic natively inside a storefront's code base is a recipe for prices that mismatch the invoice.

Instead of replicating complex rules across platforms, Siya Connect treats Dynamics 365 as the absolute pricing authority. It uses a hybrid calculation model to balance rapid load speeds with accurate invoicing.

The Siya Connect blueprint

  • Catalog caching. Siya Connect pushes baseline pricing and standard trade agreements to the storefront through optimized asynchronous batch jobs, so category and product pages load fast.
  • Real-time cart validation. The moment a customer reaches the cart or checkout, Siya Connect packages the items, quantities, customer attributes, and promo codes into a secure request and sends it to the Dynamics 365 pricing engine.
  • The operational result. Dynamics 365 runs the cart against its native promotional matrices and returns line-item discounts, bundle savings, and precise localized tax back to the storefront checkout, so the price the customer sees is the price they are invoiced.

What this means for the business: no more support tickets, manual credits, or chargebacks caused by a storefront price that did not match the final invoice, and no pricing rules to maintain twice.

The Strategic Payoff

By using Siya Connect to bridge your digital commerce storefront with the Retail capabilities of Dynamics 365 Finance & Operations, you remove the traditional barriers that divide physical and digital retail.

Your operations teams get a single source of truth for inventory. Your finance department benefits from clean, automated ledger reconciliation. And your customers get a modern, consistent experience whether they buy online, pick up at the store counter, or redeem loyalty points across your retail footprint, on Adobe Commerce, Shopify, or BigCommerce.

This is the same integration discipline behind our delivery record. We built a custom ERP that synced six online marketplaces in real time, and a PIM implementation that became one governed source of product truth feeding storefronts and marketplaces. The principle never changes: let each system own what it does best, connect them cleanly, and the customer never sees the seams. It is the same approach we bring to ERP and CRM integration and B2B commerce.

SIYA Digital
Written by the SIYA Digital team

SIYA Digital builds digital commerce and enterprise integrations, connecting Adobe Commerce, Shopify, Magento, and BigCommerce storefronts to ERP and CRM systems such as Microsoft Dynamics 365 F&O. Siya Connect is our custom integration accelerator for omni-channel retail. Talk to us about connecting your storefront to Dynamics 365 F&O.

FAQ

Common questions

Which e-commerce platforms does Siya Connect support?
Siya Connect connects Adobe Commerce, Shopify, and BigCommerce storefronts to the Retail layer of Microsoft Dynamics 365 Finance & Operations. The retail logic stays in D365 F&O; Siya Connect surfaces it to whichever storefront you run.
Which parts of Dynamics 365 F&O does Siya Connect use?
The Retail capabilities of the F&O platform: the Retail Server (Commerce Scale Unit, or CSU) for real-time inventory and pricing calls, the retail loyalty engine, the promotions and pricing engine, and retail sales orders. Your storefront reaches these through the Retail Server API, so you reuse the D365 retail engine instead of rebuilding it.
Do we need to replace our storefront or ERP to use Siya Connect?
No. Siya Connect is a custom integration that sits between your existing storefront and Dynamics 365 F&O. It connects to data that already exists in your systems through APIs, so there is no platform replacement.
How does Siya Connect keep promotional pricing accurate across channels?
Dynamics 365 F&O is treated as the single source of truth for pricing. At the cart and checkout, Siya Connect sends the basket to the D365 pricing engine and returns calculated discounts, bundle savings, and tax, so the price a customer sees on the storefront matches the invoice.
Is store inventory real-time for Buy Online, Pick Up In Store?
Yes. Instead of relying on batch file exports, Siya Connect queries the Dynamics 365 F&O Retail Server (its Commerce Scale Unit) through OData for live Available to Promise counts specific to each store's warehouse, so pickup availability reflects real stock.
Related

Explore further

Connect your storefront to Dynamics 365

Tell us which storefront you run and where the seams are today. We’ll come back with a Siya Connect integration plan, not a sales pitch.

Discuss Project