Integrate Dynamics 365 Business Central (BC) with Magento 2 using a combination of bulk and scheduled processes to keep your BC and Magento data in sync. These templates are a two-way integration solution, allowing data to flow in both directions between the two systems. You are not required to use all the templates provided but can decide which components meet your needs and adapt them to your specific scenario. The integration includes the following record types:
- BC Items and Magento 2 Products
- BC Customers and Magento 2 Customers
- BC Sales Invoices and Magento 2 Orders
- BC Sales Invoices and Magento 2 Orders
- BC Sales Credit Memos and Magento 2 Refunds
What is included
The following integration processes are available in these templates and can be used as downloaded or as a starting point to customize further:
- Magento Customers to BC
- Magento Attribute Sets to BC Item Category
- Magento Products to BC
- Magento Orders to BC
- Magento Credit Memos to BC
- BC Item Categories to Magento Attribute Sets
- BC Items to Magento
- BC Item Inventory to Magento
- BC Credit Memos to Magento
Multiple Stores
These templates are configured for one Magento 2 Store and can be modified to integrate with multiple Magento 2 Stores. Each Magento 2 Store will require a separate Connection and a copy of each integration used.
These templates do require that the latest version of the Magento 2 Connection is installed and setup within SmartConnect.com. The Magento 2 Connection is included in the download file with these templates.
For every integration, a bulk version and on-going/change option is available. The set of bulk maps are intended for an initial synchronization of the data between the two systems. After the initial bulk maps are run, the on-going/change maps are designed to be scheduled as an ongoing process to keep the two systems in
sync.
All the mappings can be modified and configured to meet your specific needs after they are imported
to SmartConnect. Feel free to add additional fields or logic required.
Prerequisites:
Files Included:
- Magento 2 REST Definition
- A unique integration file for each integration process (14 total)
The process for integrating Magento 2 and Microsoft Dynamics 365 Business Central:
- Install the eOne Solutions SmartConnect eCommerce Extension
- Import and customize the Connection methods. The Magento 2 API will have fields related to authorization and access that are specific to your system.
- Configure the Business Central Odata Connection
- Import and Configure the Magento 2 – Microsoft Dynamics 365 Business Central Maps.
- Run bulk maps to synchronize historical data and set up on going maps to keep the systems in sync.
This integration will work with Online, On-premise, and hosted Business Central deployments.
Some of the integrations will require customizations to Business Central to hold unique identifiers from Magento 2. Documentation of the extension components can be found here.
The .app file included in the downloaded zip folder will make the changes required. You can choose to either install the extension directly into your system, or you can use the code located here to create your own extension with the needed
components.
The extension will automatically publish the below web services for use by the integrations:
| Object Type | Object Id | Service Name | Custom |
| Page | 30 | ItemCard | False |
| Page | 21 | CustomerCard | False |
| Page | 43 | SalesInvoice | False |
| Page | 44 | SalesCreditMemo | False |
| Page | 132 | PostedSalesInvoice | False |
| Page | 5733 | ItemCategoryCard | False |
| Page | 63000 | SCShippingAddress | True |
| Query | 63000 | SCreditMemosQuery | True |
Install the SmartConnect eCommerce Extension
The first step is to install the “eOne Solutions_SmartConnect eCommerce Extension_1.0.0.1.app” as an extension in
Business Central using the steps outlined here.
Importing Magento 2 REST methods
The REST settings define how SmartConnect.com makes calls to the Magento 2 API. After the methods are imported, the Connection needs to be added.
Steps to Import
- Click on the “Maintenance” tab within SmartConnect.com
- Click the “REST Services” button within the REST Connection section
- Click the “Import REST Service” button at the top-right section
- Browse to and select the “Magento_1.0.0.0.json” file for the import
- Click the “Process Import” button to bring in the definition
Configuring the Magento 2 Connection
- Click on the “Connections” tab within SmartConnect.com
- Click on the “Create Connection” button
- Select the Magento 2 option from the list
- Follow the steps outlined in the Instructions section of the connection
- Click Save to complete the connection
Configuring the Microsoft Dynamics 365 Business Central Odata Connection
- Click on the “Connections” tab within SmartConnect.com
- Click on the “Create Connection” button
- Select the “Dynamics 365 Business Central Odata” option from the list
- Configure the connection
- Click Save to complete the connection
Importing the SmartConnect Maps
- Click on the “System” tab within SmartConnect
- Click the “Import” button within the SmartConnect Maintenance section
- Select each integration file and import its contents
It is likely all the integrations included are not required for your scenario. Below are two possible deployment
options.
Existing Magento 2 to new BC deployment
If the BC deployment is new and you just need to import starting Items,
Customers, and orders then the processes can be run in this order:
- BULK MAGENTO CUSTOMERS TO BC
- BULK MAGENTO ATTRIBUTE SETS TO BC
- BULK MAGENTO PRODUCTS TO BC
- BULK MAGENTO ORDERS TO BC
- ONGOING MAGENTO CUSTOMERS TO BC
- ONGOING MAGENTO PRODUCTS TO BC
- ONGOING COMPLETED MAGENTO ORDERS TO BC
- ONGOING MAGENTO CREDIT MEMOS TO BC
Existing BC to new Magento 2 deployment
If setting up a new Magento 2 store with items from BC you can run the
processes in this order:
- BULK BC ITEMS CATEGORIES TO MAGENTO
- BULK BC ITEMS TO MAGENTO
- ONGOING MAGENTO CUSTOMERS TO BC
- ONGOING COMPLETED MAGENTO ORDERS TO BC
- ONGOING MAGENTO CREDIT MEMOS TO BC
