Odoo – Magento Connector

Before we discuss about Odoo Magento Connector make sure you have Magento 2.0 and Odoo v9 installed. Following Odoo Magento Connector Extension needs to be added at Magento side. Odoo Magento Connector uses JSON RPC to interact with Odoo in the backend. There is no extra code, plugin needed at the Odoo once we have our ( Odoo Magento Connector ) connector in place. It is mandatory to provide URL, username-password and database name details from Odoo end to get the connector up and running. Whenever a transaction or change in record happens these new/ updated records will be pushed to Odoo and vice versa. Transactions such as categories, products, orders etc.

How to track the Magento records in Odoo?

Odoo holds lots of data, so how do we track which records of Odoo and which is of Magento?

Here is how we can do it. Every time a record is inserted in Odoo there is a Magento id field which is the reference to the record in Magento using which we can filter the data. It covers integration for following:

  • Category Integration

  • Products Integration

  • Product Inventory Integration

  • Product Attribute and its values Integration

  • Customer Integration

  • Sales orders Integration

  • Currency Integration

  • Taxes Integration

  • Payment Method Integration

  • Delivery Method Integration

  • Invoices Integration

  • Pickings i.e. Shipment Integration

  • Cancel Order

Firstly, we need to add configuration details in Magento and test connection with Odoo.

Login to your admin panel go to Stores > Configuration in your left nav.

1

Select OpenERP Configuration Tab under Bista Nav

Fill the required details to connect with Odoo

2

OpenERP Mapping menu in admin side will help you in synchronization of all the data with Odoo after enabling the module for the first time.

3

Following are the features on Odoo 9-Magento 2.0 Connector:

  • Category Menu

This menu shows you the Odoo and Magento category Id mapping and there is a Sync Categories button using which categories will be created/updated in Odoo.

4

Here on the categories can be synchronized as you operate on them when you save / delete category in Categories menu.

5

When saving (create/edit) category in Magento same will be created/updated in Odoo.

6 7

  • Products

T his shows list of product ids mapped with Odoo product ids.

Sync Products button throws all Product data from Magento to Odoo and Product will be created/updated in Odoo.

8 9 10

After Saving (create/edit) Product in magento it will be created/updated in Odoo.

11 12

  • Product Attributes

It will throw all Product Attribute data from Magento to Odoo and Product Attribute & its values will be created/updated in Odoo.

13

14

After Saving (create/edit) Product Attribute in Magento it will be created/updated in Odoo.

15

And attribute value is as below

16

  • Customer

It will throw all Customer data from Magento to Odoo and Customer will be created/updated in Odoo.

17 18

After Saving (create/edit) Customer in Magento it will be created/updated in Odoo.

19

  • Sales orders

20 21 22

It will throw all Sales Order data from Magento to Odoo and Sales Order will be created/updated in Odoo.

23 24

After Saving (create/edit) Sales Order in Magento it will be created/updated in Odoo.

  • Currency

It will throw all Sale Order/Currency data from Magento to Odoo and Currency will be created/updated in Odoo.

25

After Saving (create/edit) Sales Order/currency in magento it will be created/updated in Odoo.

26

  • Taxes

It will throw all sales Order/Tax data from Magento to Odoo and Tax will be created/updated in Odoo.

27

After Saving (create/edit) Sales Order/Tax in magento it will be created/updated in Odoo.

28

  • Payment Method

It will throw all Sales Order/Payment Method data from Magento to Odoo and Payment Method will be created/updated in Odoo.

29

After Saving (create/edit) Sales Order/Payment method in Magento it will be created/updated in Odoo.

30

  • Delivery Method

It will throw all Sales Order/Delivery Method data from Magento to Odoo and Delivery Method will be created in Odoo.

31

After Saving (create/edit) Sales Order/Delivery Method in Magento it will be created/updated in Odoo.

32

To know more about ODOO MAGENTO connectors you can view this video

We Hope this detailed walk through the Odoo-Magento Helps you drive your businesses. For more insights on the connector get in touch with us through sales@bistasolutions.com and tell us how do you like this feature in Odoo through feedback@bistasolutions.com .