Magento · Business Central

Business Central is where stock, orders and B2B prices live. Magento gets a stock feed with the changes every 15 minutes and a full snapshot every night, via Azure Blob Storage.

  • Delta feed every 15 minutes
  • Full snapshot every night
  • Orders in Business Central
  • B2B prices in one place
  • Delta every 15 min
  • Nightly snapshot
  • Azure Blob
  • Monitoring

Magento integration with Business Central

When Magento and Business Central need to fit together, we build the integration with Business Central as the place where data lives. Every 15 minutes Business Central builds a stock feed of the items that have changed and puts it in Azure Blob Storage. Every night a full snapshot of the whole range follows. A scheduled job in Magento picks up the files and updates the shop.

Orders are handled in Business Central, and B2B customers' prices are maintained in one place only. The shop shows what Business Central knows.

Pitfalls

What makes Magento integrations heavy

  1. Sending everything all the time

    A full pull of every item every 15 minutes loads both systems. A delta of only the changed items is small and quick, and the nightly snapshot keeps everything in step.

  2. The shop calling the ERP at peak times

    With the files in Azure Blob, Magento fetches data when its own job runs. Business Central isn't hit by traffic in the shop.

  3. B2B prices in two places

    If customer prices are maintained in both Magento and Business Central, sooner or later they drift apart. They need to live in one place.

  4. Orders handled twice

    The order lives in Business Central from when it arrives until it is invoiced. The shop is not where orders are corrected.

  5. Errors nobody sees

    A feed that stops is noticed when a customer buys an item that's out of stock. Monitor activity: no changes for a whole morning is an error too.

How we do it

How we build the feed

The feed is built in Business Central. We agree the format with whoever maintains your Magento.

  1. Mapping

    Items, locations, B2B prices, and what Magento needs to show.

  2. Feed in Business Central

    A delta every 15 minutes and a full snapshot at night, placed in Azure Blob Storage.

  3. Import in Magento

    The scheduled job in Magento picks up the files in the agreed format.

  4. Orders and prices

    Orders are handled in Business Central, B2B prices maintained there.

  5. Monitoring

    Telemetry and alerts on errors and on missing activity.

Good to know

  • We build the feed in Business Central and agree the format with whoever maintains your Magento. The import job in Magento sits on the Magento side.
  • The integration is priced after a meeting about your product range and your Magento setup.
FAQ

What people often ask us

Why files in Azure Blob rather than direct API calls?

Because the two systems then don't wait for each other. Business Central writes the feed when it is ready, and Magento fetches it when its job runs. Traffic in the shop doesn't hit Business Central.

How often is stock updated in the shop?

Changes are sent every 15 minutes, and every night a full snapshot of the whole range follows.

Where are B2B prices maintained?

In Business Central. Customer prices in one place means the shop and the invoice always show the same.

Where are orders handled?

In Business Central, from when they arrive until they are invoiced.

Who maintains the Magento side?

Whoever maintains your Magento today. We build the feed in Business Central and agree the format with them.

Let Business Central run the shop

Tell us about your range, locations and B2B prices. Then we sketch the feed together with you.

30 minutes on Teams with Sten or Lauge. You talk to the person who builds it.