PrestaShop and Business Central integration: what syncs, Navision included

Yes, you can integrate PrestaShop with Business Central: items, prices and stock flow into the store on their own, and every order goes into Business Central as a sales order, without anyone keying it in. It works with Business Central online, Business Central on your own server and with an older Navision too. What changes from one to another is how it connects, not what travels.

If someone in the office spends Monday morning retyping the weekend’s orders, or the store still shows last month’s prices because the new ones went into the ERP on Friday and nobody passed them on, this is what stops.

What syncs between Business Central and PrestaShop?

From Business Central to the store goes what you already have set up, and it keeps itself up to date:

• Items, categories and variants. An item with sizes, colours or formats becomes a product with combinations in the store. Categories are grouped the way you sell, which is not always the way you buy.
• Prices and price lists. The unit price arrives as it is. Customer and customer group price lists, the ones you need when you sell to trade buyers, too: with a small addition to your Business Central that your partner or we can build. How to show the catalogue only to approved customers is explained in the trade-only PrestaShop store.
• Stock. The store sells against your inventory. If you have several locations, you decide which ones count.
• VAT. Each item and each customer with their VAT posting group, reverse charge for business customers included.
• Blocked items. What you block in Business Central stops being sold without anyone having to remember.

And the order comes back. When your customer pays, it goes into Business Central as a sales order, with the store’s order number so anyone can find it. The customer is found by their VAT number and, if they are new, they are created with their addresses. Shipping goes in as one more line, and the store’s payment method is mapped to yours.

Then the road continues: when you post the shipment, the store tells the customer; when you post the invoice, its PDF shows up in the customer’s account. On the order page of your store you can see whether it reached Business Central, when and with which number, and a button sends it again.

In Business Central, everyone keeps working as always. The store only shows what is already there, and shows it up to date.

Does it work with my version of Business Central or Navision?

Yes, with the ones in use today. It is the first thing we will ask, and you do not need to know it by heart: whoever maintains it for you does.

• Business Central online. The easiest: it connects directly, with no server in the office. Your administrator or your partner registers the store with permission only for what it needs, without lending anyone’s password or using up a user licence. And when a price changes, Business Central sends a notification and the store has it in less than a minute.
• Business Central on your own server. It is the same program, with the connection switched off out of the box: it is switched on on the server. And there is always the option of reading its data with a user who can only look.
• Navision (Dynamics NAV 2009 to 2018). It connects too, with what it has built in or by reading its database. Microsoft ends support for NAV 2018 in January 2028: if you are moving to Business Central, what travels to the store does not change, only the connection.
• Customised by your partner. If you have your own fields — a special price, a brand, a transit warehouse — they are published and the store picks them up just like the standard ones.

A ready-made connector or a custom integration?

Microsoft ships a store connector with Business Central, but it is for Shopify. For PrestaShop there are connectors from other vendors and custom integrations, and what separates them does not show on the day they are switched on, but six months later. Look at these four things:

1. Price and stock are changed in one place only: in Business Central. If they can also be changed by hand in the store, the two end up arguing, always on the busiest day.
2. What you improve in the store is never overwritten. A better name, a rewritten description or a new photo survive the next update.
3. It connects the way Microsoft supports. Microsoft is retiring the older ways of connecting, with dates already announced from 2027. A new integration uses the one it recommends, so it does not have to be rebuilt at the next upgrade.
4. If something fails, you find out. Every order is logged, a failure sends an alert and nothing is lost: when the connection is back, it carries on where it left off.

If your ERP is heavily customised or there is another system in between, it is built to measure. That is what we did to connect PrestaShop with GoManage and Aunabase, a real case with the same split: the ERP owns price and stock, the store owns the sale, and the order goes back on its own.

What will we ask you for to get started?

• Whether your Business Central is online or on a server, or which Navision you have, and who maintains it for you.
• What you want to travel and in which direction: catalogue, price lists, stock, orders, invoices.
• Whether you sell to trade customers with fixed prices, to the public, or both.

Your partner or your administrator only has to give the store access with just the permissions it needs. With that, we set up a first test run on a copy of your store, against a Business Central sandbox, and you see your real catalogue inside PrestaShop before deciding anything else.

Frequently asked questions

Are Navision and Business Central the same thing?

Business Central is today’s Navision. In 2018 Microsoft took it to the cloud with a new name and the same core, and the version for your own server took the same name. That is why both are still around today, and both can be connected.

Does the store need a user licence?

Online, no. The store signs in as an application, with its own permissions, without taking up anyone’s seat.

Are you a Microsoft partner?

No. A partner implements, customises and maintains the ERP; we build the store side. If you already have one, we work with them without stepping on each other’s toes.

For your technical team

Online, the standard Business Central REST API (v2.0), with the application registered in Microsoft Entra ID and webhook notifications; customer price lists, stock per location and custom fields through a custom API (AL extension). On-premises, the same API enabled, or SQL Server read-only. On Navision, SOAP web services from NAV 2009 and OData from NAV 2013. Microsoft is retiring SOAP and, from 2027, publishing standard pages through OData. Online limit: 6,000 requests every five minutes per user, so the store works in batches and waits for notifications.

Running Business Central or Navision alongside a PrestaShop store? Tell us which version you use and what you would like to travel, and we will tell you how it connects and in what order. The other systems are on the PrestaShop ERP integration page, and here is how PrestaShop connects with Sage and with Odoo.

Tell us which version you have

Microsoft, Dynamics 365, Business Central and Dynamics NAV are trademarks of Microsoft Corporation. We are not a Microsoft partner or reseller: we connect PrestaShop stores to its ERP.