ERP Integration Guide: Integrating Your eCommerce Website & ERP Data

ERP ecommerce integration
Author Justin Smith
by Justin Smith, CEO - Jan. 24, 2019

So, you have an eCommerce website or a data driven website that needs to connect to your ERP. Where do you start? With so many different ERP systems and website platforms, its difficult to understand how your ERP will integrate and talk back-and-forth keeping data up-to-date on both sides. Learn more about what to think of as you head down this road.

A Successful Website ERP Integration Starts With Planning

Integrating your website and ERP can be a lot of work and often involves a lot of moving pieces, on the client side and the web development team. Like most complicated processes (such as building a home), the success of the project comes down to how well the project was planned at the very beginning. Did the developers ask the right questions upfront or are they now, halfway through the project, asking questions that are obvious to everyone that they should have asked before? Typically ERPs are integrated with eCommerce websites and it takes a lot of experience to pull off the integration successfully. No matter ERP software you're using, (SAP, NetSuite, Microsoft Dynamics, Sage, Oracle, etc.) the way you need to think about data moving in a two-way process is very similar.


The ERP Data: It's a Two-Way Street

When you have data in an ERP system, typically you'll be looking to push data from the ERP to your website and also send data back from your ERP to the website. Determining the exact data points you want to send in both directions at the beginning of the project will not only make the project run much smoother but will also allow you to receive an accurate price quote from your web development company. If an agency is guessing assumptions can pop up midway through the project and that's not fun for either party.

Examples of basic data fields that are transfered in a two-way ERP website integration:

Data Point ERP to Website Website to ERP
Product Data (descriptions, pricing)
Product Stock Levels
Order Details
Order Updates (status, shipping tracking)
Customer Information
Offline Invoice Information

The above is merely an example to get you thinking about your business data and processes. Apply these to your scenarios and develop a chart like the above for your agency or work with them to put it together based on their expertise.


ERP & Website Business Rules

Certain data points will require not only the transfer of data but logic and business rules behind how the data is processed. For example, what happens if someone places an order on your website and they already have an account in your ERP? Do you want the website to handle fixing this problem or does your ERP recognize the issue and solve it? Before you begin to throw data from once place to the next think through all of the potential problems and business rules that you may need to have in place. An agency experienced with these integrations will be able to point out the typical pitfalls.


Different Technologies to Connect The Website & ERP

Now that you know what data you'll be working with the next step is determining from a technology standpoint how the data will be transfered. ERPs can often send and accept data in multiple ways, whether that be an API, web service, XML file or flat file transfer. The best way to determine the technology to use is to get on a call between your website development agency and the ERP company. A lot can be determined with the right people on the phone asking the right questions!


ERP Data Transfer Speeds

If you're looking to send or display real-time data direct from your ERP on demand, consider your internal internet connection and if it will be able to handle the bandwidth. Most ERPs send data using a push / pull method, meaning only pushing or pulling data when new data is available, but in certain situations clients do want to provide data in real-time. If a lot of data is being requested you'll need to work with your internal IT department to be sure your ERP can keep up or work with your web development company on work around ideas.


ERP Website Integration Items to Consider:

  • What data needs to go from your ERP to your website?
  • What data needs to go from your website to your ERP?
  • How will you send data from one to the other?
  • What are your business rules?
  • Will the website or ERP handle the business rule logic?
  • Does the development company have ERP integration experience?
  • Is the integration set up for optimal website speed?
ERP Integration Points for your website

Need an ERP Integration Expert?

For more than 15 years we've been an award winning design, development and web marketing agency. Talk with us and see how we can help your business.

Interesting Reads

OuterBox is rated 4.7/5 based on 457 ratings & reviews on Google, TopSEO & FeaturedCustomers