Ask for a feature

Odoo Connector For Magento

 

If you are a Managing you website on Magento which is one of the most used and powerful E-Commerce platforms then you must be familiar with its versatility and flexibility. However, since it is exclusively built for E-Commerce it lags behind when it comes to efficient inventory, accounting, and reports management.

Odoo being one of the most flexible, scalable and comprehensive ERP solutions has a strong grasp of inventory, accounting, CRM and reports management. Our module  “Odoo Connector For Magento” allows the user to combine and harness the potential of both Magento and Odoo and therefore to efficiently and effectively manage the Sales at Magento end and inventory, customers, accounting, reporting and much more at Odoo end.

 

Features

  • Real-time sync of Sale orders from Magento to Odoo end.
  • Bi-directional sync of products, their attributes between Odoo and Magento.
  • Real-time inventory sync from Odoo to Magento and with every sales order from Magento to Odoo.
  • Synchronization of Customers from Magento to Odoo.
  • Bi-directional Real time update of order’s statuses like invoiced /paid/shipped etc.
  • Synchronize product categories bidirectionally.
  • Payment method and delivery method synchronization from Magento to Odoo.
  • Shipping carrier mapping.
  • Compatible with Odoo POS , inventory will automatically sync at both ends, Magento and Odoo while order/delivery at Magento or POS

Installation

This module is package of two modules, one for Magento ends and other for Openerp ends

You need to install one on Magento and other on Openerp.

extract the file you received

you will get two folder (one for  magento and other for openerp)

Inside magento folder there is base module

base module : this is main module , generally this module will contain two folder app and lib , simple copy all folder/file of this folder into main magento directory

After coping all files:

>> go to your magento admin panel and do Cache and index Management.

>> Simply re login your magento admin panel.

Bingo no need to do anything else your module is installed and ready to use.

ConfigurationMagento 2015-04-13 15-52-00

Configuration at magento end:

Before starting sync procedure, you need to configure the module for configuration

Step one:  login to your magento backend. Go to menu setting->configuration

Fill up your openerp host URL /port/database/username /password into that and then click on save config button.

ConfigurationSystemMagentoAdmin 2015-04-13 15-50-32

Click on `Test Odoo Connection` button if it’s successful then it’s fine otherwise recheck your credentials.

Now you completely ready to try the sync

So let start with Product synchronization

Product synchronization:

Simply go to magento admin backend. Catalog->manage product

You will see screen similar to this , click on top right button “Product synchronization ” and bingo go to the openerp you will see similar products on openerp

Screenshot

Same with Category synchronization & customer synchronization

Customer synchronization:

Go to Customers-> Manage customers:

Screenshot8

Note: Whenever customer will be edited and saved then in customer mapping need sync will be updated with “yes” value. After that you can update using “update customer on openerp” button which is under Odoo Mapping/customer menu. Same procedure is applied for product, category and tax.

Now sync of real time sales order:

This module provide real time sync of magento order from magento front-end , Any order raised  by customer form front-end will be synced to openerp in real time , No need to do any manual operation.

Flow is like this:

Magento front end offer -> openerp sales order (with all the information, customer name . billing address , shipping address , item details , taxes , discount , shipping method , payment method etc)

Then any update on status (like shipping, invoicing , payment done) of order at openerp end will be updated back to corresponding magento side and similar any changes on state of order at magento end will also be transferred to openerp end.

For synchronization of old sales order

Simply go to “sales->order “grid, select the order you want to sync and select action “Synchronise to Odoo” then click on Submit.

Orders Sales Magento Admin

How to create Magento soap user

Go to Magento admin, “System->Web service->Soap xmlrpc user”

Users Web Services System Magento Admin

Similarly create role for that user with all privileged

Now you are ready to configure magento Api details at openerp.

Installation /Configuration at Openerp end

Once the module is installed, you need to configure the module. Please refer the screenshots:

Inside openerp folder you will get all openerp modules
simply copy the module on addons path and then update the module list by “setting->update module list”
then go to “setting->Installed Modules”

Search for keyword ‘magento’ (please don’t forget to remove “installed” filter on search field   ), you will see the modules on openerp with “install” button, Click on that and install it

Now you can see a new menu with name “Magento Odoo Bridge”

Screenshot2

Next step is to configure magento connection: go to “Magento Odoo Bridge->Configuration->magento connection”. Or just click on “Configure your Magento” link.

Magento Connection Odoo

Base URL: Magento URL

API Username: Magento soap API username

API password: password of that user

Active: enable/disable

After filling all details just test the connection by clicking on “Test Connection” button.

If it is successfully connected to magento Api then you can proceed with data synchronization.

Now You are ready to synchronize data from openerp to magento.

There are two types of Button under Synchronization menu

1. Export :- using this button you can perform sync all data of related model. it will also sync new records of corresponding models. this button’s won’t be used for data update.

2. Update :- using this button you can perform data update operation for corresponding models.

You can also export mass records like-

In same way you can export category from openerp to magento.

Products Odoo

 

Support

For any kind of technical assistance, just raise a ticket at : https://webkul.uvdesk.com/ and for any doubt contact us at support@webkul.com

In next tutorial we will handle advance topic like payment method mapping /tax mapping /currency mapping

Where to buy

you can buy from here  : http://store.webkul.com/Magento-Extensions/Magento-OpenERP-Bridge.html

Current Product Version - 2.4.0

. . .

Ask a Feature

Index