Open ERP 6.1 & Magento 1.7 Integration System


This articles gives details to setup OpenERP-Magento Integration. The article used following versions of various software:

OpenERP – 6.1.1
Magento – 1.7.0.2
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 1.7.0.2). 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

http://apagen.wordpress.com/2012/03/13/openerp-installation-on-linux/.

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 = “mail@domain.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 1.5.0.0+”
c. Location = “http://YourStoreBaseUrl”

(b) On the “Authentication” tab add API user and key and save.

(c) The bridge is now ready for operation. Click on buttons 1-8 sequentially to get OpenERP and Magento in sync.

Source : http://apagen.wordpress.com/2012/10/31/openerp-magento-integration/

Advertisements

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s