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 .

Contact Us

    Our Clients Reviews

    “What stood out about Bista was definitely the responsiveness from the point that we made the
    first contact, they were very quick to respond to my query…and then we scheduled. Because I was
    on a very tight deadline. I wanted it up and running within a month…. They were responsive, they had a team dedicated [to take care of what was happening] …people working around the clock.”

    SuperAsia Foods
    Aqib Majid

    “I think Bista’s been a great partner. It’s one of the reasons we’ve been working with them for multiple years
    now, even after the initial project finished. I think they have a great talent pool to work with and they’ve been
    very accommodating – so wherever we needed to change things or get additional resources or find additional
    expertise they’ve always been on point to help with that.” 

    Pinnacle Promotions
    Sean Phuphanich

    “[Bista’s] understanding of core business processes and needs is unmatched and unparalleled in their industry. Through working with Bista, we’ve got quantifiable results and qualitative results. We’ve been able to increase our sales double while lowering our back-order fulfillment rate. Previously we were fulfilling with the rate of 85% and since using Bista we’ve increased that to 97%.”

    Maqabim Distributors
    Michael Sturury