Business Goals
Our client is a leading European healthcare company. They own and commercialise branded, original over-the-counter products and prescription medicines. Their products are available in more than 90 countries in Europe and the Nordic region.
Their sales channels include various online marketplaces, and Amazon is the primary marketplace. As a healthcare company, they had over 350 items/SKUs in their catalogue. They were selling these products in different geographical marketplaces like the US, the UK and the rest of Europe through Amazon marketplaces.
As part of their e-commerce transformations, they wanted to automate synchronising orders across all marketplaces with their ERP platform.
Technological Challenges
As a seller on Amazon, our client had their seller account set up in Amazon’s Seller Central. Amazon Seller Central is an online platform provided by Amazon for individuals and businesses to sell their products on the Amazon marketplace. It allows sellers to list their products, manage inventory, fulfil orders, and track sales performance. And Microsoft Dynamics was their ERP platform.
They sought a cost-effective, scalable integration solution to integrate Amazon marketplaces with the Microsoft DynamicsERP platform.
How NeosAlpha Helped
Our integration consultants, who had worked with various e-commerce integrations using technologies like Boomi, Azure Integration Services etc., analysed the current business requirements. After several detailed discovery sessions with the client, they selected Azure Integration Services as the most appropriate integration solution. The primary reasons for selecting Azure AIS were client had many other applications in their IT landscape, which was Microsoft based, and the ERP platform to which the integration is to be enabled was Microsoft Dynamics.
Based on the client’s priority, Orders were taken into the scope of integration. The objective was to move the orders from the Amazon marketplace to MS Dynamics using Azure’s Integration Services. The key technical steps to design and build the integration process are detailed below.
- Setting up an AWS Cloud account and creating required IAM roles and users
- Accessing Amazon Seller Central to understand the structure of various accounts and the marketplaces they were mapped to
- Developed client apps in Seller Central by providing required and appropriate security privileges using the AWS IAM user policies
- Azure Logic Apps was used to build the integration pipeline, which used HTTP Client connector to make calls to AWS SP API(s)
Amazon SP-API (Selling Partner API) is a set of APIs provided by Amazon for third-party sellers to integrate with Amazon’s selling platform. It enables sellers to programmatically access and manage their Amazon selling accounts, including listing and managing products, managing orders, and accessing business reports and analytics.
Results
- Successfully developed scheduled integrations that collected orders across multiple Amazon marketplaces and created sales orders in Dynamics.
- Business users could get accurate sales order metrics at an SKU level.
- The solution offered extensibility and scalability to build future integrations to process refunds/returns, analyse buyer data etc.
