OpenERP Magento Integration


Magento is a feature-rich eCommerce platform built on open-source technology that provides online merchants with unprecedented flexibility and control over the look, content and functionality of their eCommerce store. Magento’s intuitive administration interface features powerful marketing, search engine optimization and catalog-management tools to give merchants the power to create sites that are tailored to their unique business needs. Designed to be completely scalable and backed by Varien's support network, Magento offers companies the ultimate eCommerce solution.


A new bridge between OpenERP and Magento initiated by Openlabs team and under rapid improvement with the active support of community is now one of the most popular combinations for the 'best of breed' approach in ERP e-commerce deployment. This module allows synchronization of Magento with Open ERP. It supports Synchronization of Customer Groups, Product Categories, Product Attribute Sets, Attribute Groups, Product Attributes, Products, Order Statuses, Image Synchronization and many more

The bridge consists of two components: A Magento side extension and an Open ERP side module. The Magento extension is a PHP based web services improvement which is fully written and maintained by Openlabs. The Open ERP module has achieved further modularity and is today the preferred algorithm to quickly integrate Open ERP with other applications. Our latest in the list is a simple integration with Sales Force CRM.

Openlabs is actively involved in the Magento – Open ERP Projects and ever since the development of the new connector we have been helping customers across the globe to migrate and implement it.At Openlabs we are committed to provide an excellent user experience .The following detailed tutorial will guide you to the installation process of - :

  • Magento (full version)

  • Magento – Open ERP Connector module contributed by Openlabs

  • Magento Extension

Step 1: Required bits & pieces

a. Required Open ERP Addons (Available for download from this site)

b. Xampp 1.6.4

http://sourceforge.net/projects/xampp/files/XAMPP%20Linux/1.6.4/xampp-linux-1.6.4.tar.gz/download

After copying the addons to the Open ERP addons path,

  1. Go to a Linux shell and login as the system administrator root.

  2. For xampp-linux-1.6.4.tar.gz file, extract the downloaded archive file to /opt. using sudo tar xvfz xampp-linux-1.6.4.tar.gz -C /opt.

  3. Open the page http://localhost.It should show xampp on the page. You may get errors similar to the ones that are shown below:

Warning: file_get_contents(lang.tmp) [function.file-get-contents]: failed to open stream: Permission denied in /opt/lampp/htdocs/xampp/index.php on line 2.

Warning: Cannot modify header information - headers already sent by (output started at /opt/lampp/htdocs/xampp/index.php:2) in /opt/lampp/htdocs/xampp/index.php on line 4

Above Errors can be Removed by following step - :

Change the permissions by using chmod of the lampp folder in /opt to readable and writable. After this change the permissions of file config.inc.php in /opt/lampp/phpmyadmin to “read-only” and restart lampp.


Step 2: Installation of Magento full version

     1. Download magento-1.3.2.4.tar.gz and extract it to /opt/lampp/htdocs/sudo tar xvfz magento-1.3.2.4.tar.gz -C /opt/lampp/htdocs

     2.To check your Magento installation type http://<yourIPaddress>/magento in the browser.

It should display the “Setup for Magento”/”Magento Installation” for the first time and “Magento Demo Store” from the next time.

Note: Use your IP instead of localhost to avoid issues of magento kicking you from the admin login.

If you get an error: innodb engine Open file xamppmysqlbinmy.cnf (Using sudo gedit or sudo nano)

Find code:

  • # Comment the following if you are using InnoDB tables

  • Skip-innodb

  • #innodb_data_home_dir = "/xampplite/mysql/"

  • #innodb_data_file_path = ibdata1:10M: autoextend

  • #innodb_log_group_home_dir = "/xampplite/mysql/"

  • #innodb_log_arch_dir = "/xampplite/mysql/"

  • ## You can set._buffer_pool_size up to 50 - 80 %

  • ## Of RAM but beware of setting memory usage too high

  • #innodb_buffer_pool_size = 16M

  • #innodb_additional_mem_pool_size = 2M

  • ## Set._log_file_size to 25 % of buffer pool size

  • #innodb_log_file_size = 5M

  • #innodb_log_buffer_size = 8M

  • #innodb_flush_log_at_trx_commit = 1

  • #innodb_lock_wait_timeout = 50

 

Modify to:

  • #Comment the following if you are using InnoDB tables

  • #skip-innodb

  • innodb_data_home_dir = "/xampplite/mysql/"

  • innodb_data_file_path = ibdata1:10M: autoextend

  • innodb_log_group_home_dir = "/xampplite/mysql/"

  • innodb_log_arch_dir = "/xampplite/mysql/"

  • ## You can set._buffer_pool_size up to 50 - 80 %

  • ## Of RAM but beware of setting memory usage too high

  • innodb_buffer_pool_size = 16M

  • innodb_additional_mem_pool_size = 2M

  • ## Set..._log_file_size to 25 % of buffer pool size

  • innodb_log_file_size = 5M

  • innodb_log_buffer_size = 8M

  • innodb_flush_log_at_trx_commit = 1

  • innodb_lock_wait_timeout = 50

Reload the magento page, if some error of "mysql.sock not found" comes then change the rights of my.cnf file to read only, than reload the magento page and it should work now.


Step 3: Configuring the Bridge

The Magento-Open ERP bridge comprises of two parts:

  1. Open ERP Module.

  2. Magento ERP Extension.

 

Installation of Magento extension:

For this in magento admin panel go to:

System >> Magento Connect >> Magento Connect Manager

Key in your username and password again and click on the second tab for settings and change preferred state to 'Beta'. (As of this date the plug-in is beta).Save your settings and select page 1 (Extensions) and paste the following extension key in the box

"Magento-community/Openlabs_OpenERPConnector" without quotes

Now your installation of magento is almost ready to talk to Open ERP

To enable open ERP to access the resources in magento and synchronize, it is necessary to have a web services user. To create a web services user go to : System >> Web Service >>Roles

Create a new role e.g. 'admin'

Save the user and set resources access as: ALL

Save the role and now create a web services user at: System >> Web Services >> Users

Create a user, save the user and set the assigned role as the newly created role, in the above example 'admin'

The same settings have to be entered as credentials in the connector frontend in Open ERP at Magento >> Magento Web

The user id will be the newly created user name and password the newly created password of the web services user.


Step 4: Configuration of Magento – Open ERP Connector module

    1. Ensure that you have at least 1 Product category in your system or create one. (Required)

    2. Install the magentoerpconnect module (For how to install a module refer to doc.openerp.com) (Module available at bzr branch lp: magentoerpconnect and/or bzr branch http://bazaar.launchpad.net/~openlabs-akretion-consortium/magentoerpconnect/magentoerpconnect_generic)

   3. Go to Magento Connection > Core Settings > Magento Instances

   4. Create a new instance by clicking new

   5. Give the connection a name (e.g. My local magento)

   6. Referential Type (Only 1.3.2.4 is available now)

   7. Location: Your magento URL e.g. (http ://< yourIPaddress>/magento) & Default Product category (Magento allows products without category and those will be classified here)

   8. Click on Reload Referential Mapping Templates

   9. Enter API Username and password defined in step 4 of magento configuration

   10. Click on Synchronize Referential Settings


Openlabs provides standard packages for implementation of Magento OpenERP connector with following services, provided by our expert technical team:

    1. Installation of Open ERP on production server.

    2. Implementation of Magento Open ERP Connector.

    3. Configuration & testing of the complete system as per the standard functionality.

    4. Detailed user guides & user trainings for using the system.

 

For more details about our commercial support, packages & free demos please contact our pre-sales team