Connect Microsoft Dynamics 365 Business Central

01Before you start

You need someone who can register applications in your organisation's Microsoft Entra ID (formerly Azure Active Directory) and grant admin consent, a Business Central user with the rights to manage Microsoft Entra applications, and the owner or admin role in your Pricebeeper account.

Business Central items have no web page addresses, so this connection updates products already in your Pricebeeper catalog and doesn't add new ones. Bring your products in first, from your shop's product feed or a store import, with the same item numbers or GTINs.

02Step 1: Register an application in Microsoft Entra ID

1. 1

   Create the registration

   In the Microsoft Entra admin center, open App registrations and choose New registration. Name it Pricebeeper, keep it to accounts in your organisation only, and register it.

2. 2

   Copy the IDs

   On the application's overview, copy the Application (client) ID and the Directory (tenant) ID.

3. 3

   Add the Business Central permission

   Under API permissions, add a permission for Dynamics 365 Business Central, choose Application permissions, select API.ReadWrite.All, and grant admin consent for your organisation.

4. 4

   Create a client secret

   Under Certificates & secrets, create a new client secret and copy its value straight away; Entra shows it only once. Note when it expires, and renew it before then.

The application permission lets the app call Business Central's API, but what it may actually see is decided in Business Central itself, in the next step. That is where you keep it read only.

03Step 2: Allow the application in Business Central

1. 1

   Open Microsoft Entra Applications

   In Business Central, search for Microsoft Entra Applications and open the page.

2. 2

   Add the application

   Choose New, paste the Application (client) ID into Client ID, describe it as Pricebeeper, and set State to Enabled.

3. 3

   Give it read permissions

   Assign permission sets that let it read items in the company, such as D365 READ, and nothing that writes. Applications can't receive SUPER.

04Step 3: Connect it in Pricebeeper

1. 1

   Open Connections

   In Pricebeeper, go to Settings, Connections, choose Add connection and pick Microsoft Dynamics 365 Business Central.

2. 2

   Fill in the access details

   Fill in the Tenant ID, the Environment (usually Production), the Company name as Business Central shows it, the Application (client) ID and the Client secret.

3. 3

   Choose what each sync does

   Update unit costs uses the item's unit cost; Use its prices as your own prices uses its unit price, in the company's local currency.

4. 4

   Connect and test

   Choose Connect and test. Pricebeeper signs in, reads the first products and shows them with their codes, barcodes, costs and prices, so you can check them before the full sync runs in the background.

05What a sync changes

Each sync reads every product Business Central lists and finds the matching product in your catalog: first by product code (SKU), then by barcode (EAN or GTIN). A code or barcode that several of your products share matches none of them, so a duplicate never gets the wrong cost.

• Unit cost replaces the cost Pricebeeper had, when Update unit costs is on. Repricing keeps every suggestion above the margin floor it sets.
• Your own price becomes the price competitors are compared with, when Use its prices as your own prices is on.
• Codes and barcodes fill in where a product had none, which helps Pricebeeper find the exact product at other sellers.
• Products that match nothing are counted and listed on the connection, so you can see what is missing from your catalog.

Pricebeeper reads items a thousand at a time, following Business Central's own paging. Items without a number are skipped. Prices are read in the company's local currency.

A sync never deletes, renames or moves anything, and it reads only: Pricebeeper writes nothing back to your system. Approved prices reach your store only through a store you connect for repricing.

06Step 4: Check the results

The connection shows when it last synced, how many items it read and updated, and how many matched nothing in your catalog. Repricing then works from each product's unit cost and your own price; the getting started guide covers monitoring and alerts.

With costs and prices current, repricing keeps every suggestion above your margin floor.

07When a sync fails

After ten failed scheduled syncs in a row a connection pauses itself, so it stops trying with details that no longer work. Fix the setting with Edit, then switch it back on.

Questions people ask