Skip to main content
E-commerce interface with Microsoft Dynamics

E-commerce interface with Microsoft Dynamics

Korcomptenz - Microsoft Dynamics AX - E-commerce interface with Dynamics AX 2009

About BionX International

BionX is on a mission to revolutionize the way people move. BionX's award-winning electric drive systems are answering a growing worldwide demand for alternative transportation solutions that enable environmental sustainability and a higher quality of life.

Although BionX e-bike systems were first introduced to the market over 10 years ago as purely a retrofit product on any bicycle, the systems eventually evolved and became available as standard equipment on complete electric bicycles in 2008. Today, many leading bicycle manufacturers in Europe and North America, including Trek and Wheeler to name a few, offer complete products powered by BionX. Headquartered in Aurora, Ontario, Canada, BionX International has various locations and sales partners in over 15 countries.

Overview

BionX International has customers and sales partners over 15 different countries. The customers can place orders on the client website directly like any other E-commerce website. BionX team then extracts customer and order information in an excel file and create it manually in AX. Every new customer and order was being created in AX manually by the customer service team. BionX wanted to automate this process by developing interface program and approached the Korcomptenz Dynamics team.

Challenges

Business Challenge

The manual process was time-consuming and customer service team would spend a full day to create and complete three customer orders in Dynamics AX.

Business Challenge

File format conversion, E-commerce files will be extracted in .CSV format which will be by converted into excel by customer service.

Business Challenge

Data filtering, E-commerce extract contains all field information from the website. Customer service needs to validate and enter required information.

 
Business Challenge

Manual entry of customer data, led to data discrepancy between two systems. Duplicate customers were created as there is no unique customer ID followed in the current system.

Business Challenge

BionX wanted to implement approval workflow process for every new customer creation release done by the customer service division.

 
Solution

Developed new interface program to automate customer master creation in Dynamics AX system based on the data from E-commerce site. Source data will be extracted from E-commerce site on regular interval, periodic batch program in Dynamics AX will pick up the file and create new customers. Master templates are created in Dynamics AX to default the standard values based on customer country.

Logic written in Dynamics AX to read the file, validate the data and copy customer templates and create new customer. Number sequencing implemented to sequence the customer number based on customer country. Workflow approval was implemented to create new customers and release to the divisions. New customers will be approved before it is released to the division which will ship the product to the customer. A customer can be released to multiple divisions within BionX.

Business Challenge

Results

Business Challenge

Interface was seamless between systems and new customer were created without any delay.

Business Challenge

Reduced manual work. Customer creation, approval and move to division was completely automated.

Business Challenge

Duplicate customer records / orders reduced considerably.