We have a store running on Magento and recently we have moved the order processing module to Odoo(OpenERP),So that the picking and packing of order items will happen in Odoo.
Now i want to synchronise the Magento DB with Odoo so that at the end of day all data in Odoo will be synced with Magento.
I have tried to directly update the pick/pack details from Odoo stock_picking table to Magento sales_flat_order and it was a disaster and broke the entire system.
So can anyone please suggest on how to do this? Any better idea/suggestions will be of great help.
Note : Magento version 1.9(MySQL), Odoo(PostgreSQL) and w ehave a DWH running on Postgres where we store the Odoo and Magento data.
Maybe you could check for an option from the Marketplace? https://marketplace.magento.com/catalogsearch/result/?q=odoo&ext_platform=Magento%201