The end of manual processes
Our integration product is the nemesis of menial tasks. By automating your central data flows, our solution frees up ressources in your business to pursue growth activities
Leveraging your back office
The employees in back office typically have a detailed understanding of the ins and outs of the business. When they are freed from mundane data transfering tasks, they have better time to actively support the business. Integrating the ERP and eCommerce systems reduces costly human errors, frees up your back office and allows your business to focus on business.
All your data in one place
Dynamics Nav or Dynamics 365 Business Central will be the single source of truth when it comes to your data. This is where data is created and from where it is send off to other systems.
Always compatible
Your integration solution will follow your Dynamics Nav and Magento implementations. The technology is based on standard principles and will be compatible with future versions.
"Our integration product
creates value for all types of companies"
Advantages of a Dynamics Nav / 365 Business Central integration
Integrating your Magento shop with Dynamics Nav / 365 Business Centrol is a best practice that all companies should implement. It greatly simplifies your business process while enhancing your capabilities to deliver value to the customers.
Automation
Automation of trivial processes that do not create value should be a key objective for business owners.
Business logic
Because we reuse the existing business logic from your Dynamics 365 solution, we will not have to modify any of your raw data.
Fewer human mistakes
Human mistakes – and mistakes in general – are reduced by allowing the integration solution to handle the dataflow between Dynamics Nav / 365 and your Magento webshop.
Trust your data
Continuously updated stock and other DATA means that your organization can count on the integrity of your data across systems.
Optimization of processes
A swift order and billing process allows your business to operate on maximum capacity without relying on human typing.
Functionality
The integration product will ensure scheduled copying of data from Dynamics 365 Business Central to Magento. The integration will allow the Magento 2 webshop to communicate with Dynamics 365 Business Central through Web Services.
This ensures that the two systems are fully synchronized without being dependent on each other. If one system goes offline, the other system will continue operating seamlessly and a full synchronization will be conducted once both systems are up and running.
Detailed specifications
for the integration
Products
Nye varer oprettes, fjernede varer slettes og ændrede varer opdateres. Integrationen benytter NAV som ejer af alt varedata og synkroniseringen er derfor altid fra NAV til Magento.
- Item name
- Item number
- Description
- Unit price
- Status
- VAT group
- Wheight
Contacts
All contacts with email will be synchronized. The email is unique and is used as username. The address of the contact is used as default delivery address. The billing address is retrieved from the billing address of the debitor.
- Contact name
- Standard delivery adresse 1 + 2
- Standard Post number
- City
- Country
- Customer number
Price logic
It’s important to include the following fields:
1. Item sales price
2. Item sales discount
3. Customer price group
4. Customer discount group
These four fields will likely cover everything that’s needed for your price logic. The logic will be synchronized to the Magento 2 webshop such that the user receives the desired discounts and pricegroup dessignation.
Salesprices
- Sales type
- Sales code
- Item number
- Unit price
- Allow line discount percentage
- Minimum quantity
- Start- and end date
Sales line Discount - Sales type
- Sales code
- Code
- Minimum quantity
- Line discount percentage
- Start- and end date
Costumer discount group - Code
- Description
Costumer price group - Code
- Description
Orders
All relevant order data is automatically synchronized from your Magento 2 store to your Dynamics 365 BC. Included in the data are the Magento order number, order currency, the customer’s shipping information and all items that are present on the order. Order item info includes SKU, quantity, and price.
Orders with a certain order status are automatically synchronized. When the order is successfully transferred to your Dynamics NAV or Dynamics 365 Business Central the order will be assigned a predefined status. It is easy to configure both of these statuses. In case the customer placing an order has made previous purchases in your shop, the order will be synchronized to the existing customer in Dynamics NAV or Dynamics 365 Business Central. If the customer is not present in your ERP system, they will be created before the order is synchronized.
Order number from Magento
- Costumer name
- Contact number
- Costumer number
- Delivery addresse 1 + 2
- Delivery post number
- City delivered to
- Country delivered to
Order lines
- Item number
- Quantity
Sync intervals
Data will be synchronized once every day. Magento will send the query to NAV and update relevant information on the webshop.
RabbitMQ
To handle the significant amount of data flow, we will use RabbitMQ to create a queue system that will prevent the server from being overloaded.
Implementation time
From the times all relevant data is provided by the NAV supplier, it will take 14 days for the implementation. Before commencing the implementation we will give a written confirmation that data is complete and relevant permissions have been granted.
Prerequisites
- A basic integration is completed before creating customized solutions.
- All necessary data needs to be in place before our work can start
- Access to test server for the magento site has been granted
- Access to test financials for NAV is delivered
- Additional deliveries are created when basic integration has been approved.
Authentication
We will use NTLM or username/password. If the NAV system is protected by a firewall, we will need access. Connection with SSL is supported. We will provide additional assistence if there are further questions to the connection methodology.
Permissions in Dynamics Nav / 365 BC
We will need the following permission to set up the integration – see table below. We will also need delete rights to be able to remove test orders during the development phase. This can be removed after launch. Notice that the WebService names are our suggestions and not a requirement.
Name | Permissions | |||||
Nav/365 BC | Webservice | Read | ReadMultiple | Create | Modify | Delete |
Products | Items | X | X | |||
Customers | Customers | X | X | |||
Contacts | Contacts | X | X | |||
Sales order | SalesOrder | X | X | X | X* | |
Invoice | PostedSalesInvoices | X | X | |||
Creditnote | PostedSalesCreditMemos | X | X | |||
Item sales price | ItemSalesPrice | X | X | |||
Sales line discount | ItemSalesDiscount | X | X | |||
Customer price group | CustomerPriceGroup | X | X | |||
Customer discount group | CustomerDiscGroup | X | X | |||
Need our help?
For question or if you need help with a qoute – contact our customer service.
Call us +45 28 91 27 23 or send us an email support@droppinstudio.dk
Østergade 31, 1. sal
8000 Aarhus C
Tlf: +45 28 91 27 23
E-mail: info@droppinstudio.dk