Integration of Magento with third party CRM, POS and ERP solutions

SIA picture SIA · May 15, 2010 · Viewed 14.8k times · Source

I have some concerns about the Integration of Magento with other CRM,ERP systems.

  1. How is it possible to integrate Magento with any other Industry standard CRM and ERP system?

  2. How can i fetch the data from a ERP and update Magento database, like transactiona replication. Is this possible? And Whats the right way to do it?

  3. Also, How can i integrate Magento with POS? Is it possible to have bi-directional data update between Magento and Industry Standard POS?

I hope I have stated all my doubts and made it clear. I would be thankful if someone guides me to do the integration, the Right way.

Answer

Joseph Mastey picture Joseph Mastey · May 15, 2010

If you're using Magento Enterprise Edition, take a look at Bridge Connect, which is a service specifically built to integrate with common ERP packages. If you aren't using EE, or if you don't want to pay for Bridge Connect, your best bet is to use the webservices that Magento provides for this task.

The big advantage of using these is that they are relatively stable between upgrades, so you won't completely break your upgrade path. The downside is that they are slow. Silly slow. And they leak memory like a boat made of toilet paper. In my experience, though, this is nothing compared to the trouble of upgrading handwritten code when Magento decides to change the underlying database.

As for a POS, in simple cases the Magento admin sales interface may suffice. You can take CC payments, arrange shipments, etc, and your orders will be approximately the same as if they had been submitted from the web. If not, you're back to webservices if you want them in the Magento system.

If your ERP system is handling fulfillment, you may be able to skip the step of adding POS orders to Magento. Let the ERP system be the system of record for inventory, and just update Magento w/ the new accurate inventory quantities periodically.

Hope that helps.

Thanks, Joe


EDIT:

Magento has not stated any plans to change the database that I am aware of, but it has happened several times in the past without warning, and it would be risky to assume that nothing will change. Varien does not make any guarantees about the database format, or whether it will be changed significantly.

When such a change happens, the APIs and objects in the platform are adjusted accordingly, so keeping it above the database level will keep you insulated from those changes, and make the job of evaluating new releases for compatibility that much easier.