The summary gauge for how far your commerce platform’s inventory has drifted from D365, the system of record. Above 5% means a sync problem.
At a glance
The aggregate percentage of SKUs (or units) whose on-hand quantity differs between Dynamics 365 (the system of record) and the commerce platform’s inventory feed. It is a single health gauge: low is good (the two systems agree), high means the sync between F&O / BC and your storefront is drifting. The per-SKU detail behind this gauge lives on the SKUs with D365 vs Ecom Inventory Drift >5% card.
| What it counts | The share of compared SKUs (or units, depending on configuration) where D365 on-hand and commerce-platform available quantity disagree beyond the drift tolerance. Conceptually count(drifted SKUs) / count(compared SKUs), expressed as a percentage and rendered as a gauge. D365 on-hand comes from the inventory layer (AvailablePhysical in F&O, Item Availability in BC); the commerce side comes from each connected storefront’s inventory feed. |
| What “variance” means | A SKU is in variance when its D365 sellable on-hand and the commerce platform’s available-to-sell quantity differ by more than the configured tolerance. The gauge aggregates those flagged SKUs into one percentage. |
| Multi-platform | Where a merchant runs more than one storefront (e.g. Shopify Plus plus a B2B BigCommerce or Adobe Commerce instance), each mapped SKU is compared against the storefront it is published to. The gauge is the blended drift across all mapped channels. |
| Multi-Company / legal entity | Respects the selected legal-entity filter. SKUs are compared within their owning entity so a multi-entity tenant does not cross-count stock between companies. |
| Time window | RT/24H (real-time gauge, evaluated against a rolling 24-hour comparison) |
| Alert trigger | >5%. When aggregate variance exceeds 5%, the gauge enters the warning band and the Nerve Centre raises an alert. Sustained breach points at a sync failure rather than normal timing noise. |
| Roles | owner, finance, operations |
Calculation
Calculated automatically from your Microsoft Dynamics 365 data. See the At a glance summary above for what the metric tracks and the worked example below for a typical reading.Worked example
A mid-market apparel brand syncs Finance & Operations to a Shopify Plus storefront via a dual-write / Power Automate integration. The gauge is read 21 Mar 26. The catalogue has 4,200 mapped SKUs.| Measure | Value |
|---|---|
| Mapped SKUs compared | 4,200 |
| SKUs within tolerance | 3,906 |
| SKUs in variance (beyond tolerance) | 294 |
| ERP-vs-Ecom Inventory Variance % (this gauge) | 7.0% |
| Alert threshold | 5% |
- At 7.0% the gauge is in the warning band. It has crossed the 5% threshold, so the Nerve Centre has raised an alert. Below 5% this is usually just timing noise (a sale on the storefront not yet pushed to F&O, a receipt in F&O not yet published to the store). Above 5% it is structural and worth investigating today.
- The gauge does not tell you which SKUs. That is by design. This card is the summary health reading; the 294 individual drifted SKUs, with the D365 quantity, the commerce quantity, and the gap, are listed on SKUs with D365 vs Ecom Inventory Drift >5%. Start at the gauge, drill to the list.
- The likely root cause is the integration, not the data. A spike from a steady 1 to 2% baseline up to 7% usually means the sync stopped or slowed. Check Power Automate Flow Failures (ecom integration) first; a failed inventory-push flow is the most common reason the two systems diverge.
- High variance plus open demand is the dangerous combination. If drifted SKUs are also ones with open sales-order demand, you risk overselling on the storefront or starving real orders. Cross-reference OOS with Open Sales-Order Demand and Low Stock Alerts when the gauge is high.
Sibling cards merchants should reference together
This gauge is the summary. Pair it with these to find the cause and the consequence of the drift.| Card | Why pair it with ERP-vs-Ecom Inventory Variance % |
|---|---|
| SKUs with D365 vs Ecom Inventory Drift >5% | The per-SKU detail behind this gauge. The gauge says “how bad”; this card says “which items, by how much”. Always your first drill. |
| Inventory Sync Drift | The broader sync-health view of how the ERP and storefront inventory are tracking over time, beyond a single threshold gauge. |
| Power Automate Flow Failures (ecom integration) | The most common root cause. A failed inventory-push flow is usually why the gauge spikes. Check it first when variance jumps. |
| Low Stock Alerts | Drift on low-stock SKUs is the riskiest kind: it is exactly where overselling or stockout happens. |
| OOS with Open Sales-Order Demand | The consequence. When drifted SKUs also carry open demand, the storefront and the ERP disagree on whether you can fulfil. |
Reconciling against Microsoft Dynamics 365
Where to look in Business Central / Finance & Operations: The closest native equivalents in the Dynamics UI are:F&O > Inventory management > Inquiries and reports > On-hand inventory (the D365 side of the comparison, per item / warehouse) F&O > Data management > Data project execution history (whether the inventory export to the storefront ran) Business Central > Inventory > Item Availability by Location (the BC equivalent on-hand) Power Platform admin > Power Automate > flow run history (the actual push of D365 quantities to the storefront)To verify a single drifted SKU, open On-hand inventory for the item in F&O (or Item Availability in BC), note the sellable quantity, then open the same SKU in the storefront admin and compare the available-to-sell figure. The gap you see by hand should match the gap the per-SKU drift card reports. D365 is the reference: the storefront should be reconciled to it, not the other way round. Common mistakes when comparing the two systems by hand:
- Comparing physical to sellable. D365 on-hand can include reserved, blocked, or non-nettable quantity. The storefront usually publishes available-to-sell. Compare like for like (sellable to sellable) or the gap is an illusion.
- Wrong warehouse scope. If the storefront is fed from one warehouse but you check total on-hand across all warehouses in D365, the numbers will never tie.
- Timing. A sale that just happened on the storefront has not yet decremented F&O until the order syncs. A momentary gap is normal; a persistent one is drift.
| Reason | Direction | Why |
|---|---|---|
| Sellable vs physical definition | Either | The gauge compares sellable-to-sellable using the configured field map. A manual check that uses raw physical on-hand will show a different gap than the card. Confirm the field map matches your fulfilment logic. |
| Warehouse feed scope | Either | If only certain warehouses feed the storefront, the comparison is scoped to those. A whole-company on-hand check will not match. |
| Tolerance band | Card lower count | The gauge only counts SKUs beyond the configured tolerance. A by-hand check that flags any non-zero gap will count more SKUs than the gauge. |
| Sync timing window | Either | The gauge evaluates against a rolling 24-hour comparison. A spot manual check at a different instant catches different in-flight transactions. |
| Multi-platform blending | Either | The gauge blends drift across all mapped storefronts. Checking one storefront by hand will not reproduce the blended figure. |