Magento ERP Integrations

Due to Magento’s open source, ERP systems can be integrated using powerful Webservices. We have implemented many Magento ERP integrations, i.e. Microsoft Dynamics (Nav), Macola, Netsuite, Sage, Oracle or SAP

How to integrate Magento with an ERP

We offer the following features:

Let's take a look at some pricing examples based on a store online revenue:

• Two-way integration of Customers, Orders, and Items
• Integrating multiple web sites/web stores with ERP systems to process and fulfill orders
• Proper mapping of Magento and Tax/Shipping charges for accurate Order total
• Real time inventory updates
• Support Simple as well as complex Product types
• Uploading Shipment Tracking Information

There are a few choices Magento customers have in order to integrate into 3rd party systems, i.e. ERP systems. Either use a Magento extension or chose custom development. In either case, you need experienced back-end developers. While extensions get you up to speed faster, custom development will give you the benefit of addressing your specific requirements right away without buying another license. At MW2, we are leaders in integrating third party solutions into Magento. Most ecommerce sites minimally rely on ERP (Enterprise Resource Planning) or Accounting systems to keep track of orders, inventory, finances and sales data. Third Party System Integrations can be difficult to integrate into any platform. For many years now MW2 has been very successful integrating Magento with many of the top back-end or 3rd party systems. Depending on the requirements/needs and budget we use a variety of methods from API to flat files and everything in between.

MW2 will help craft a custom integration solution taking your unique needs into consideration. Using our Fast2Commerce methodology, we can quickly scope your needs by asking some simple questions such as:

• Bi-directional or one-way syncing of data between your ERP and Magento
• Real-time, near real-time or schedule intervals
• Types of data needed

Some of the common data points you will want to decide on passing between your ERP and Magento are:

• Orders
• Customer Groups
• Invoices
• Credit Memos
• Shipments
• Return Authorizations
• Customers
• Transactions
• Inventory
• Tax Rules
• Product Data
• Credit Limits/Approvals

TOP Magento ERP Integrations

Sage 300 (formerly ACCPAC)

Sage 300 offers a strong set of modules for distribution, inventory and general accounting. The current versions use a variety of databases with Microsoft SQL Server being the top implemented version.

Integration to Magento typically is based on Web Services and SData which are supported by both applications. It allows for a bi-directional flow of data with some of the key features being:

• Customer, Product, Pricing and Discounts, Orders, Invoices and Shipments

Microsoft Dynamics NAV (formerly Navision)

Microsoft Dynamics NAV provides many mid-market businesses with inventory, order entry and basic accounting as well as the ability to easily customize the solution to your unique business needs.

Through API integrations with Magento and NAV, we are able to seamlessly integrate the two platforms using two-way synchronization and failover. Many times we are able to implement a customized real-time solution to keep both systems in sync. Many integrations we have done take advantage of keeping customers, products, inventory, orders, tiered pricing and credit limits in sync for an optimal omnichannel experience.

SAP Business One

SAP Business One offers a complete solution that supports most small and midsize businesses with financials, sales, service, purchasing, and inventory modules. Business One offers a single server architecture which allows for single server API Layers.

Using XML via the SOAP API, we are able to integrate into Magento a bi-directional sync of orders, customers, products, and pricing. We use the API calls to trigger workflows in Business One to streamline your webstore operations.

Epicor 9 (formerly Vantage)

Epicor 9 has core strengths in Manufacturing and general ERP. It was made with made-to-order business models. It is built on a service-oriented architecture (SOA) using Microsoft.NET and web services.

A typical integration to Magento is done via web services allowing near real-time connectivity for supply chain and the webstore. The Magento/Epicor 9 integration keeps orders, pre-orders, inventory, pricing and customer data in sync in near real-time. This allows us to push orders in real-time for same-day fulfillment.

Microsoft Dynamics GP

Microsoft Dynamics GP is an excellent mid-market ERP platform. Since being acquired by Microsoft the platform has become popular for industrial distributors, wholesalers, service company, and manufacturers. Dynamics GP offers a nice selection of different packages to choose from to suite your business needs.

Using the Dynamics GP API’s in conjunction with the Magento web services API’s, MW2 has been able to extend the ability to import/export products, orders, and customers.

Macola ES (Exact Software)

Macola ES offers core ERP features for manufacturing, project management, distribution, accounting, and CRM. They also have a number of add-ons to extend the functionality of the platform like Activity and Process Management, Personalized Workspaces and Quality Management to name a few.

The Macola ES integration to Magento supports inbound orders and outbound shipment updates, inventory and product. MW2 has built custom API calls and CSV file FTP jobs to support this integration.

Sage 100 (formerly MAS 90 & MAS 200)

Sage 100 fits most small and midsize businesses with financial management, inventory, distribution, sales and order management as core functionality. Sage 100 has added additional features if the Human capital management, business insight, and performance. Sage 100 has multiple deployment options and add-on solutions to meet all business types.

Sage 100 integration with Magento syncs bi-directional data using API and Flat File transfers for customers, orders, payments, products, and inventory. MW2 has built near real-time and periodic data syncing between the two systems.

Netsuite

Netsuite is a cloud-based ERP system offering a modular design, allowing business to extend their functionality. Netsuite offers billing solutions, inventory, supply chain and warehouse management solutions.

The Netsuite integration to Magento used web service API’s from Netsuite and Magento to automatically push orders to Netsuite, sync inventory in intervals and nightly updates of customer data.

SYSPRO ERP

SYSPRO ERP offers on-premise or in the cloud platform options. Since it’s sold in modules, you are able to select only the modules needed for finance, manufacturing, distribution, order management, supply chain and inventory management.

By using the SYSPRO Integration Framework and Magento Webservices API, MW2 is able to use XML and API calls through Magento ERP integrations to tightly integrate orders, invoices, shipments, inventory, pricing, and customers.

Sage ERP X3

Sage ERP X3 combines all the advantages of ERP performance into a solution for medium and large sized companies. Sage X3 offers the platform with a Web native or SOA architecture. It can be hosted on Windows, Unix or Linux operating systems which allows for more integration points with Magento.

Using the Xtend E-Commerce toolset, MW2 can connect your Sage X3 system to your Magento storefronts to automatically process orders, shipments, inventory commitments, pricing and credit approvals.

Accounting & Reporting Implications

Ensuring that all your Magento order data is being synced correctly in and out of your ERP is our top priority. We make sure nothing falls by the wayside in order to ensure your reporting and reconciliation are close to 100%. MW2 has thought through for Magento ERP integrations with items like catalog pricing rules and shopping cart pricing rules being synced into the correct part of your ERP. This can change between business and between different sites for each business line.

What’s Next?

Fully integrating with Magento from your ERP can be tricky to navigate. Fear not though, MW2 has you covered for all types of Magento ERP integrations. If you want to learn more, contact us today.