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.
- 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
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.
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.
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
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
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 “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.
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 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”
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 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.
For any kind of technical assistance, just raise a ticket at : https://webkul.uvdesk.com/ and for any doubt contact us at firstname.lastname@example.org
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