Back to resources

Dynamics GP eCommerce Integration

Integrating Dynamics GP with eCommerce

Techniques to help you integrate ecommerce with Dynamics GP


A Dynamics GP and eCommerce integration helps improve workflow efficiency, monitor inventory and sales, and get the most out of your ERP software.


With e-commerce, we can get everything delivered at our doorstep right from food staples to furniture. The more advanced features there are, the more is the work behind the business architecture, solution, and services. From a business standpoint, one significant aspect is synchronizing the inventory and the e-commerce platform's frontend. With a lot of competition from the e-commerce biggies, here's a formidable solution for growing and upcoming e-commerce businesses too.

Microsoft’s Dynamics GP (Great Plains) is a business management solution for small to midsize businesses that need ERP (Enterprise Resource Planning) software that is easy to use and implement. It is the second most used enterprise resource planning (ERP) solution (they offer four unique ERP solutions) from Microsoft.


Why Choose Dynamics GP e-Commerce platform?

Here are a few reasons you’d want to integrate your e-commerce platform along with Microsoft’s Dynamics GP:

  • Dynamics GP can help you keep track of your business intelligence data, manage your accounting, and monitor inventory.
  • Integrating your Dynamics GP software with your e-commerce platform enables the systems to share information, providing you with the most up to date and accurate data relating to your business.
  • Dynamics GP helps you manage finances, business assets and accounting.
  • Dynamics GP integration can keep track of your e-commerce team's HR activities that deal with hiring, employee profiles, evaluation, and payroll.
  • It is easy to manage contacts, sales, and service contracts with the Dynamics GP platform.

To get the most out of your Dynamics GP e-commerce integration, follow the best practices for integration listed below.



Use eConnect

eConnect is a set of tools made to help integrate Dynamics GP with other systems and software. It provides a robust set of endpoints exposed via an API, making it easier for developers to communicate with data inside the Dynamics GP environment. And in case you don't find an endpoint, you can create a custom one within the eConnect .NET API. The business logic utilized in eConnect consists of a series of SQL stored procedures.

Microsoft recommends that you use eConnect for all the integrations that it can help. eConnect helps developers by providing them with many integration points that make it quicker and easier for them to complete the integration. However, it does suffer from a significant drawback that eConnect has no way to detect if the system has 3rd party add-ins installed, which might require you to add some stored procedures manually for it to work.


Use a Mapping Matrix

A mapping matrix is a great tool to use to help plan out your Dynamics GP integration and explore every possible integration point. Creating a mapping matrix gives your team a chance to validate all the connections that they are working to create as well as consider other potential connections that could be beneficial to your business in the future. If possible, it is best to create all your integration connects while your systems are being operated on rather than having to rework and add to your integration numerous times. Check also to see if you have custom entities that eConnect may not have access to up front. Those typically require using web services to integrate with.


Document Custom Classes and Fields

Before starting to develop your integration between your Dynamics GP software and your ecommerce platform, you need to make sure that all the custom classes, fields, and entries created in your Dynamics GP are well documented. While Dynamics GP makes it easy to create custom fields, it can be difficult or time consuming to access those customizations through the eConnect tools, depending on a few different factors. If you are connecting any of these custom fields to your ecommerce platform, you should have a thorough review for every one of the fields so that the team members that work with them will have a better understanding of the detailed requirements.


Create a “Cloned” Environment

Cloning your production environment in order to create an environment, often called a "sandbox," to develop and test the integration in enables your developers to work on the integration without disturbing business processes. When creating the cloned environment, you need ensure that the development environment matches your production environment. To help you do this, it is ideal to create a list of features and functions that are present in the production environment. You can then work on the integration in the cloned environment, making sure that the connections are being made and eConnect is working like you thought it would, without affecting your business or messing up your data.


Follow Best Practices to Integrate Microsoft ERPs

  • Redundancy, performance and security are the basis for strong integrations. Using a message queue and programming data to be sent by one system until it is received by the other is the way to achieve redundancy.
  • For your integration to perform well, using caching and make sure that data is sent in small sizes.
  • To have a secure integration, use multiple levels of security, transmit data over SSL, scope data, and require authentication.
  • Dynamics GP has multiple levels of security to ensure access is only granted based on defined roles. It's highly recommended to integrate with Azure Active Directory to allow for single sign-on.
  • Lack of worker adoption might be the reason for your integration failure. Hence, ensure a persona-centric approach with your workers and stakeholders for better business results from an ethical point of view.

By following these tips, you will have a well-built basis for your Microsoft Dynamics GP and ecommerce integration.


Clarity Can Help

At Clarity, we are committed to creating strong, secure, and useful integrations for our clients. Our Microsoft Dynamics Certified team of experts is highly experienced at developing integrations, especially when integrating Microsoft software. We have also created our own integration platform, Clarity Connect, to help build seamless integrations. To find out more about how Clarity can help your business integrate its Microsoft Dynamics GP software with your ecommerce platform, visit the Dynamics GP ecommerce integration Centre.

Find out more

Click here to review options to gather more info.
From resource guides to complimentary expert review... we're here to help!