WeDid: Magento, Microsoft Dynamics GP and SmartTurn
May 29, 2014 /
Posted in We Did
Challenges
Customer has a requirement to integrate eCommerce orders from Magento into their Microsoft Dynamics GP accounting system and SmartTurn their warehouse management system. This will eliminate manual keying of data between the systems and provide not only an automated process flow but free up a considerable amount of time for staff currently involved in these activities.
Solution:
| Purpose | Automate sales order creation from Magento to Microsoft Dynamics GP and Smart Turn. Automate Product information synchronisation between Microsoft Dynamics GP and SmartTurn. Microsoft Dynamics GP is updated once shipping is confirmed in SmartTurn. Any inventory adjustments are synchronised from SmartTurn to Microsoft Dynamics GP |
| Applications | SmartTurn WMS – hosted Microsoft Dynamics GP Magento |
| Versions | Boomi Atmosphere SmartTurn Connector Database Connector |
| Tool | Dell Boomi Atmosphere |
| Information | Magento Sales Order > Microsoft Dynamics GP Sales Order > SmartTurn Sales Order Microsoft Dynamics GP Products > SmartTurn Products SmartTurn Inventory adjustment > Microsoft Dynamics GP Inventory adjustment |
| Data Formats | Web Services, Database and Microsoft Dynamics GP API calls through eConnect |
| Volumes | ~ 100/Day |
| Process | When a Sales Order to generated in Magento it is replicated to Microsoft Dynamics GP and SmartTurn. Products in Microsoft Dynamics GP are created and updated as Products in SmartTurn. Inventory adjustments in SmartTurn are updated to Microsoft Dynamics GP |
| Schedule | 14 days |
| Complexity | Complex |