If you are a Managing your 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.
- 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
- Tracking number synchronization from Odoo to Magento
- Check Missing order history. If any order fails to sync in Odoo due to any issue
like server issue then the user can check all failed order history in Missing order menu.
This module is a package of two modules, one for Magento end and another for Openerp ends.
You need to install one on Magento and other on OpenERP.
extract the file you received. You will get two folders (one for Magento and other for OpenERP)
Inside the Magento folder, there is a base module.
Base module: This is the main module , generally this module will contain two folder app and lib , simple copy all folder/file of this folder into the main Magento directory.
After coping all files:
>> go to your Magento admin panel and do Cache and index Management.
>> Simply re login to Magento admin panel.
Bingo no need to do anything. Your module is installed and ready to use.
Configuration at magento end:
Before starting the sync procedure, you need to configure the module for. Follow these simple steps.
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.
Click on `Test Odoo Connection` button if it’s successful then it’s fine otherwise recheck your credentials.
Now you are completely ready to try the sync. So let’s start with Product synchronization
Simply go to magento admin backend. Catalog->manage product
You will see a screen similar to this , click on the top right button “Product synchronization ” and bingo go to the openerp you will see similar products on openerp
Same with Category synchronization & customer synchronization
Go to Customers-> Manage customers:
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 the “update customer on openerp” button which is under the Odoo Mapping/customer menu. Same procedure is applied for products, category and tax.
Now sync of real time sales order:
This module provides real time sync of Magento order from Magento front-end. Any order placed 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.
How to create Magento soap user
Installation /Configuration at Openerp end
Once the module is installed, you need to configure the module. Please refer the screenshots:
Inside the OpenERP folder, you will get all openerp modules.
Simply copy the module on Odoo 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 the name “Magento Odoo Bridge”
Next step is to configure Magento connection: go to “Magento Odoo Bridge->Configuration->magento connection”. Or just click on “Configure your Magento” link.
Base URL: Magento URL
API Username: Magento soap API username
API password: password of that user
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 Odoo to Magento.
There are two types of Button under Synchronization menu
1. Export :- using this button you can perform sync all data of the 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 the same way, you can export categories from Odoo to Magento.
For any kind of technical assistance, just raise a ticket at : https://webkul.uvdesk.com/ and for any doubt contact us at email@example.com
In the next tutorial, we will handle an advanced 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