This articles gives details to setup OpenERP-Magento Integration. The article used following versions of various software:
OpenERP – 6.1.1
Magento – 188.8.131.52
Ubuntu – 12.04
Step 1: Ubuntu Installation
The 1st step in the process is to install latest version of Ubuntu System. Latest Ubuntu setup can be obtained fromhttp://www.ubuntu.com/download/desktop. The instructions to install Ubuntu can be found at http://www.ubuntu.com/download/help/install-desktop-latest.
Alternatively, you can choose to install Magento on other platforms such as Windows, CentOS, etc. However, it is suggested to use Ubuntu for best results. In case OpenERP is also going to be installed in the same system, it is best to use Ubuntu.
Step 2: Magento Installation
In this step, we will install the latest version of Magento Community Edition (Currently 184.108.40.206). It can be downloaded fromhttp://www.magentocommerce.com/download. Please ensure that you download only the tarball version (tar.gz). The detailed instructional video to install Magento on Ubuntu can be found in the following video:http://www.youtube.com/watch?v=DQjRlkQQr38&feature=g-hist.
At the end of this step, you will have Magento installed on your system.
Step 3: OpenERP Installation
In this step, we will install latest version of OpenERP (Currently 6.1.1). It can be downloaded from http://nightly.openerp.com/6.1/releases/openerp-6.1-latest.tar.gz. The detailed instructions to install OpenERP can be found at
At the end of this step, you will have OpenERP installed on your system.
Step 4: Install Magento Side Modules
Integration between Magento and OpenERP is achieved by a bridge called magentoerpconnect. It involves installing modules in Magento as well as OpenERP side. In this step, we will install modules on the Magento Side. Download Magento_modules.rar fromhttps://docs.google.com/folder/d/0BzdmG8XLHvf7T25IRS12RVZSUnM/edit. Extract the contents of the file. After extraction, perform the following steps:
(a) Copy the file Openlabs_OpenERPConnector.xml found in the folder magento-module-oerp6.x-stable\Openlabs_OpenERPConnector-1.1.0\app\etc\modules into the folder /<yourstorefolder>/app/etc/modules/
(b) Copy the folder Openlabs found in the folder magento-module-oerp6.x-stable\Openlabs_OpenERPConnector-1.1.0\ into the folder /<yourstorefolder>/app/code/community/Openlabs
(c) Log into your admin account of your magento website and Clear Magento Cache at http://mymagentosite/index.php/admin > System > Cache Management. Flush Magento Cache and Cache Storage.
(d) Check if your module is installed correctly athttp://mymagentosite/index.php/admin > System > Configuration > Advanced. You should see enabled module.
At the end of this step, you will have Magento side modules copied in the system.
Step 5: Install OpenERP Side Modules
In this step, we will install modules on the OpenERP Side. Download OpenERP_modules.rar fromhttps://docs.google.com/folder/d/0BzdmG8XLHvf7T25IRS12RVZSUnM/edit. Extract the contents of the file. Extract the contents of the file. After extraction, perform the following steps:
(a) Move all modules in OpenERP addons directory.
(b) Activate all modules in OpenERP database at Settings > Modules > Update Modules List.
(c) Install all the newly copied modules at Settings > Modules > Modules > List view.
At the end of this step, you will have OpenERP modules installed in the system.
Step 6: Magento Side Configuration (Creating user in Magento for access from OpenERP)
In this step, we will create a user in Magento with required permissions seamless access from OpenERP. To achieve the following, perform the following steps:
(a) Go to MagentoAdmin > System > Web Services > Roles. Click “Add New Role” button. On the Role Info Tab fill Role Name = “openerp” and in Role resources Tab fill Resource Access = “All”. Save Role.
(b) Go to MagentoAdmin > System > Web Services > Users. Click “Add New User” button. On the User Info tab, fill the following:
a. User Name = “openerp”
b. First Name = “Any name you like”
c. Last Name = “Any family name you like”
d. Email = “email@example.com”
e. API Key = “input any key you like”
f. API Key Confirmation = “repeat key”
g. This account is = “Active”
On the User Role Tab, select “openerp”. Save User.
At the end of this step, you will have finished Magento Side Configuration.
Step 7: OpenERP Side Configuration (Setting up connection to import and export data with Magento)
In this step, we will set Magento instance for our Magento website and import information from the same. To achieve the following, perform the following steps:
(a) Go to Openerp Admin > Core Settings > Magento Instances. Click “Create” button. Fill all necessary fields as follows:
a. Name = “Any readable name”
b. Referential Version = “Magento Version 220.127.116.11+”
c. Location = “http://YourStoreBaseUrl”
(c) The bridge is now ready for operation. Click on buttons 1-8 sequentially to get OpenERP and Magento in sync.