skip to content
thumbnail-inner-image

Post by :

Published

Categories

,

Read time

10 min read

Wholesale distributors running several branded Shopify Plus storefronts off one D365 F&O instance face a sync problem most integration guides don't cover. Here's what a custom build and generic iPaaS get wrong, and what a purpose-built connector needs to handle instead.

Social Share :

Digital wholesale portals with accurate, real-time inventory hit 96 to 99% order accuracy. Portals still running on phone and rep orders land at 85 to 92% (Shero). That gap sounds academic until a distributor is selling the same warehouse pool through more than one storefront at once. 

We keep seeing the same pattern from wholesale distributors moving off a custom-built site onto modern commerce platforms like Shopify Plus or Adobe Commerce. It’s rarely one storefront. Usually there’s a flagship site plus a handful of brand-specific ones, all pulling data from a single Dynamics 365 Finance and Operations instance. 

Inventory has to hold steady everywhere at once. Product data needs to live in one place but only show up where it belongs. Orders have to land back in the ERP the moment they’re placed. And dealer pricing already sitting in F&O needs to just work at checkout. 

That’s a different integration problem than the one-storefront, one-ERP setup most guides assume. Here’s where the common approaches break, and what a connector actually needs to handle for the pattern to hold. 

Quick answer 

The first question most teams ask: does F&O have a native connector the way Business Central does? It doesn’t. F&O ships with no built-in Shopify connector, so most F&O merchants choose between a custom build on Microsoft’s Dual-write, a generic iPaaS platform, or a purpose-built integration. 

For a single storefront with straightforward sync needs, any of the three can work. Once multiple branded storefronts are drawing from one F&O instance with B2B dealer pricing on top, the custom-build and generic-iPaaS paths both leave the multi-storefront logic for you to design and maintain. A purpose-built connector treats that as a supported pattern instead of a custom project. 

The real decision: custom build, generic iPaaS, or a purpose-built connector 

A custom build on Microsoft’s Dual-write or Commerce connector keeps you inside the Microsoft ecosystem, but those tools were built for Microsoft’s own commerce stack, not Shopify or other commerce platforms. Connecting them to Shopify or Adobe Commerce means an SI or internal team builds the bridge from scratch, including anything related to multiple storefronts. 

A generic iPaaS platform gives you the plumbing to move data between systems. What it doesn’t give you is the logic. You still have to design: 

  • Which products go to which storefront 
  • How inventory allocation works across sites 
  • How dealer pricing tiers compute and sync 

None of that comes packaged. It becomes an internal engineering project with an ongoing maintenance line. 

A purpose-built connector, like i95Dev Connect for Shopify and D365 F&O, is built around this exact category of problem. It covers 150+ touchpoints between the two systems, syncs in real time in both directions, and works with both cloud and on-premises F&O deployments. Standard scope goes live in about a week. 

Custom build (Dual-write) Generic iPaaS Purpose-built connector 
Who builds the logic Your team or an SI, from scratch You, using the platform’s tools Already built, configured for your setup 
Multi-storefront, selective publishing Not native, has to be engineered Possible, but you design and maintain the rules Built-in pattern, not a custom project 
Real-time inventory across storefronts Depends entirely on the build Depends on how it’s configured Native, out of the box 
B2B dealer pricing sync Custom development required Custom development required Supported as standard configuration 
Ongoing maintenance owner You, indefinitely You, indefinitely The vendor 
Typical time to live Months, SI-dependent Weeks to months, scope-dependent Days to a few weeks 

The single-catalog, multi-storefront publishing problem 

Managing one product catalog in F&O while publishing selectively to several branded storefronts is the part most connectors weren’t built for. The default assumption in nearly every Shopify-ERP integration is one storefront per ERP instance. 

Force that assumption onto a multi-brand setup, and you end up with one of three workarounds: 

  • Duplicating catalog data per storefront 
  • Maintaining separate product feeds by hand 
  • Syncing the full catalog everywhere and hiding items with app-level tricks 

What actually works: product and inventory data stays centralized in F&O, and publishing rules (by brand, category, or a custom attribute) determine which storefront each item appears on. That’s a configuration decision a purpose-built connector should support natively, not something to be engineered per launch. 

Real-time inventory sync across storefronts 

A sync that runs on a batch schedule, even a fairly frequent one, creates a window where two storefronts can both show inventory that no longer exists. If one SKU sells through two different branded sites drawing from the same warehouse pool, both storefronts need to reflect the sale within seconds, not minutes. 

For a distributor selling to dealers who are themselves reselling to end customers, an oversold SKU doesn’t just mean a refund. It means a dealer relationship absorbing the fallout. 

D365 F&O as the system of record 

Keeping F&O as the system of record means three things have to hold, regardless of which storefront the order came from: 

  • Orders write back to F&O almost instantly 
  • Pricing and dealer-specific terms reflect at Shopify Plus checkout without a manual export step 
  • Fulfillment and shipping updates flow back to the storefront the order actually started on, not a generic queue 

Multi-storefront selling doesn’t remove any of this. It just means every storefront needs its own accurate view into one shared, centrally-managed record. 

B2B dealer pricing and account management on Shopify Plus 

Shopify Plus supports company accounts, custom price lists, and negotiated payment terms natively. Merchants using these native B2B features see up to a 4.1x increase in reorder frequency compared to standard DTC orders. 

The platform side is solid. The gap is almost always on the sync side. Dealer tiers, credit terms, and account hierarchies, what many buyers just call customer-specific pricing, usually live in the ERP, not Shopify. A connector needs to translate F&O’s trade agreements and customer groups into Shopify Plus company accounts and price lists automatically, not through a spreadsheet export someone runs monthly. 

Where generic iPaaS breaks down at this scale 

iPaaS platforms are genuinely capable, and for a simple, well-defined sync between two systems they work fine. The problem shows up specifically at the pattern this guide is about: multi-storefront selective publishing, real-time cross-storefront inventory, and F&O-specific pricing structures aren’t pre-built connectors inside a generic iPaaS. Someone has to design that logic, test it, and own it when F&O or Shopify change something underneath it. The platform fee is rarely the real cost. The engineering time is. 

Where a custom Dual-write build breaks down 

Dual-write and the Commerce connector are strong tools for connecting F&O to other Microsoft products. Shopify isn’t one of them. Using Dual-write as the foundation for a Shopify integration means building a translation layer that Microsoft didn’t design for this pairing, on a timeline measured in months, usually through an SI. 

Multi-storefront publishing and dealer pricing sync would need to be built into that custom layer from scratch. Your team would own every future maintenance cycle. 

What a purpose-built F&O and Shopify integration should include 

  • Real-time, two-way sync across every connected storefront, not just one 
  • Selective publishing rules so one F&O catalog can serve multiple branded storefronts without duplication 
  • F&O as the system of record for orders, pricing, and fulfillment, reflected back to the originating storefront 
  • Automatic translation of F&O trade agreements and customer groups into Shopify Plus company accounts and price lists 
  • Support for both cloud and on-premises F&O deployments 
  • Ownership of maintenance through Microsoft’s and Shopify’s platform updates 
Running a setup like this, or planning to? 

and walk through your storefront structure directly. 

Questions to ask before picking a partner 

  • Have they built multi-storefront, single-ERP integrations before, or would this be a first? 
  • How do selective publishing rules get configured: as a supported feature, or as custom development? 
  • What’s the actual latency on inventory sync between storefronts, not just the sync frequency? 
  • How do F&O trade agreements and customer groups map to Shopify Plus company accounts? 
  • Who owns maintenance when F&O or Shopify ships a platform update? 

The cost of getting this wrong 

For a wholesale distributor, the risk isn’t abstract. Overselling a SKU across two storefronts damages a dealer relationship that took years to build. Duplicate catalog maintenance across multiple sites eats staff time every time a product line changes. And manually reconciling dealer pricing between the ERP and the storefront introduces exactly the kind of error a B2B buyer notices immediately, on an invoice. 

A simple way to size it: current reconciliation hours per week, multiplied by loaded hourly rate, plus the estimated cost of pricing or inventory errors per month. i95Dev’s integration ROI calculator runs this with real order volume if a precise number is useful for an internal business case. 

How long does it take to go live? 

Standard scope for our F&O connector goes live in about a week. 

Editorial note: that figure is for standard scope. A multi-storefront setup with custom selective-publishing rules and B2B dealer pricing sync should be scoped separately, since it’s a materially larger project than a single-storefront connection. Confirm a realistic range for this specific complexity with the delivery team before publishing a number. 

Proof: what this looks like in practice 

Editorial note: no confirmed i95Dev case study currently matches this exact pattern (multi-brand distributor, multiple Shopify storefronts, one F&O instance, B2B dealer pricing). Worth checking with the success team for a close match before publishing, or noting this as an emerging use case if nothing fits yet. Publishing without a real proof point here is the single biggest gap in this piece. 

Three steps if you’re evaluating this 

  • Map your storefronts, brands, and publishing rules against the checklist above before requesting a quote. 
  • Get a scoped assessment that accounts for multi-storefront and dealer-pricing complexity specifically, not a generic single-store estimate. 
  • Go live on a connector that treats multi-storefront sync as a supported pattern, with ownership of maintenance sitting with the vendor. 

Frequently Asked Questions

Wrap up

A single-storefront Shopify and F&O sync is a solved problem several ways. Multiple branded storefronts drawing from one ERP, with real-time inventory and dealer-specific pricing, is a narrower problem that most generic approaches weren’t built to solve out of the box.

Ready to scope this for your storefronts? 

Post by :

Published

Categories

,

Read time

10 min read

Wholesale distributors running several branded Shopify Plus storefronts off one D365 F&O instance face a sync problem most integration guides don't cover. Here's what a custom build and generic iPaaS get wrong, and what a purpose-built connector needs to handle instead.

Social Share :

Related Blogs

Subscribe To Our i95Dev

I95dev Subscribe Image

Join our community of finance, operations, and procurement experts and stay up to date on the latest purchasing & payments content.

Scroll to Top