@pglock When you speak about integrating and ERP with an ECommerce there are several aspects involved:
1) the webservice or file API (XML/RPC on OpenERP) 2) the schema mapping (stupid work essentially but requires a lot of work) 3) maintaining a double referential (unless you can work only with absolute ID's which is often not the case). 4) UI interface I connected OpenERP with Magento and just recently to OSCommerce too, using competely different technologies. For Magento, the EAV database of Magento and it's poor random API let us no choice but develop a full blown connector. Luckily we took time to make 70% of our work generic and reusable for other connectors. So if you think about making it in an OpenERP module, than I totally advise you use the base_external_referentials and base_sale_multichannels modules from that 5.0 extra addons branch: https://code.launchpad.net/~openerp-commiter/openobject-addons/stable_5.0_extra-addons We made those modules after discussing between several partners with a great experience already in connecting OpenERP to ecommerces. In a world they provide you a nice framwork to handle the double referential issues (actually any OpenERP entities can then have ids in n referentials, handy if you should have several ZenCart instance or other ecommerces). base_sale_multichannels on his side gives you a consistent API + interface (per OpenERP sale shop) to syn an OpenERP sale shop to an ecommerce. As for OSCommerce, with no faith in the poor existing code, we started from scratch. As OSCommerce has a normalized (eg readable database), we wen with the Kettle ETL connector + our OOOR OpenERP plugin running under JRuby. This was a child play, in 3 days only we had many things synch'ed. We still use the base_external_referentials module in that case. Notice that for this customer, OSCommerce was and end of life site (they migrate to Magento) so we just need importing order/picking lists, which was much less work anyway. We will soon blog about that Kettle + OOOR plugin technology, for now, only serious hackers can make their way with the open source stuff we published along the way which are to be found here: http://www.akretion.com/en/blog/2010/01/18/introducing-ooor---openobject-on-rails-drivingrequesting-your-openerp-became-a-child-play/ http://github.com/rvalyi/terminatooor http://github.com/rvalyi/jripple http://forums.pentaho.org/showthread.php?t=74137 Hope this helps and hope you manage to reuse the generic infrastructure we built. If the OSCCommerce and other ecommerce connector are so brittle/broken now it's largely because their author did not make that abstraction effort. ------------------------ Raphaël Valyi CEO and OpenERP consultant at http://www.akretion.com -------------------- m2f -------------------- -- http://www.openobject.com/forum/viewtopic.php?p=50129#50129 -------------------- m2f --------------------
_______________________________________________ Tinyerp-users mailing list http://tiny.be/mailman2/listinfo/tinyerp-users
