Magento 与第三方 CRM、POS 和 ERP 解决方案集成
我对 Magento 与其他 CRM、ERP 系统的集成有一些担忧。
如何将 Magento 与任何其他行业标准 CRM 和 ERP 系统集成？
我如何从 ERP 获取数据并更新 Magento 数据库，例如事务复制。这可能吗？正确的方法是什么？
另外，我如何将 Magento 与 POS 集成？ Magento 和行业标准 POS 之间是否可以进行双向数据更新？
我希望我已经说出了我所有的疑问并澄清了。如果有人指导我以正确的方式进行集成，我将不胜感激。
I have some concerns about the Integration of Magento with other CRM,ERP systems.
How is it possible to integrate Magento with any other Industry standard CRM and ERP system?
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?
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.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（6）
如果您使用的是 Magento Enterprise Edition，请查看 Bridge Connect，这是一项服务专为与常见 ERP 软件包集成而构建。如果您不使用 EE，或者不想为 Bridge Connect 付费，那么最好的选择是使用 Magento 为此任务提供的 Web 服务。
使用它们的一大优点是它们在升级之间相对稳定，因此您不会完全破坏升级路径。缺点是它们很慢。又傻又慢。它们会像卫生纸做的船一样泄漏内存。不过，根据我的经验，与 Magento 决定更改底层数据库时升级手写代码的麻烦相比，这根本不算什么。
对于 POS，在简单的情况下，Magento 管理销售界面可能就足够了。您可以接受 CC 付款、安排发货等，您的订单将与从网络提交的订单大致相同。如果没有，如果您希望 Magento 系统中使用 Web 服务，那么您将返回到 Web 服务。
如果您的 ERP 系统正在处理履行，您可以跳过将 POS 订单添加到 Magento 的步骤。让 ERP 系统成为库存记录系统，只需定期更新 Magento 新的准确库存数量即可。
希望有帮助。
谢谢，
Joe
编辑：
据我所知，Magento 尚未声明任何更改数据库的计划，但过去已经在没有警告的情况下发生过几次，并且假设什么都不会改变是有风险的。 Varien 不对数据库格式或是否会发生重大更改做出任何保证。
当发生此类更改时，平台中的 API 和对象会相应调整，因此将其保持在数据库级别之上将使您免受这些更改的影响，并使评估新版本兼容性的工作变得更加容易。
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.
Magento 订单/销售数据库结构在最新版本中从 EAV 更改为扁平结构（巨大的性能提升），我预计在不久的将来不会有太大变化，但是非常不鼓励在最低级别使用 DB - 尝试在模型级别进行集成。
至于 ERP 集成 - 有几个选项 - BridgeConnect 也提供部分功能和 Web 服务（但例如，Magento 中没有通过 Web 服务创建订单），您将需要中间件或从第 3 方系统调用 API。如果您需要速度，最好的选择是编写自定义集成块作为 Magento 扩展。如果您需要灵活性和快速解决方案 - 使用 Web 服务（您也可以通过扩展来扩展它们）。
The Magento orders/sales database structure was changed in latest release from EAV to flat structure (huge performance boost) and I don't foresee much changes in the near future, however it is highly discouraged to play with DB at the lowest level - try to integrate on Models level.
As for ERP integrations - there are couple options - BridgeConnect offers part of the functionality, webservices too (but there is no order creation in Magento via webservice for example) and you will need middleware or call API from 3rd party system. If you need speed, your best bet is to write a custom integration piece as a Magento extension. If you need flexibility and quick solution - use Webservice (you can extend them too with extensions).
正如您接受的答案中所述，您最好的选择是使用 API（Web 服务或 XMLRPC）。我使用 API 构建进出 ERP 系统的接口，并使用 Mule ESB 作为事件/传输层。
如果您找不到所需的 API 方法和/或这些方法不适合您，您可以非常轻松地扩展 API。
As stated in your accepted answer your best bet is to use the API (either web service or XMLRPC). I used the API to build interfaces into and out of our ERP system using Mule ESB as the event/transfer layer.
If you can't find an API method you need and/or the methods don't work out for you, you can extend the API very easily.
不幸的是，2010 年 8 月 Magento 不再支持 BridgeConnect。还有一些第三种第三方供应商似乎填补了至少几个 ERM 解决方案的空白。
不幸的是，经过多次搜索，我仍然没有找到NetSuite的集成解决方案。
Unfortunately, it looks like as August 2010 Magento does not support BridgeConnect any longer. There are some third party vendors who seem to filling the void for at least a couple ERM solutions.
Unfortunately, after much searching, I still haven't been able to find an integration solution for NetSuite.
是的，API 和 XMLRPC/Web 服务是正确的选择。另一种选择是寻找已经存在的 Magento 扩展，它们已经可以满足您的需求。 Bridge Connet 当然是一个选择，我们为客户考虑过它，但我们最终为 RunIt POS 开发了自己的 Magento POS 扩展。
Magento 扩展现已在我们的网站上出售：https:// www.activo.com/runway-magento-integration-with-runit-pos/ 如果您需要更多信息，请查看此链接，我们还提供了一个概述视频，并且我们还设置了一个演示供您在需要时尝试。
这绝对是一个不断增长的需求，因为我看到由于在线商务需求的不断增长，越来越多的网络商店需要与后端服务集成。我们将推出新功能和其他扩展，使在线商家能够利用现有的 Magento 商店做更多事情。
Yes, API and XMLRPC/Web Services is the way to go. Another option is to look for pre-existing Magento Extensions that already do what you are looking for. The Bridge Connet is certainly an option and we considered it for our customers, however we ended up developing our own Magento POS Extension for RunIt POS.
The Magento Extension is now for sale on our website at https://www.activo.com/runway-magento-integration-with-runit-pos/ Check this link if you need more info, we also included an overview video and we have setup a demo for you to try if needed.
This is definitely a growing need as I see more and more web stores need to integrate with back end services due to the growing demand of online commerce. We will be rolling out new features and other extensions that enable online merchants do more with their existing Magento stores.
我认为您应该看看 Quick Books POS 与 Magento 的集成，还可以看到两个系统之间同步服务的 ecc 扩展。
I think you should take a look on Quick Books POS integration with Magento also see ecc extension for sync srevice btw both systems.