Get a Sneak-Peak on How to Import Excel File with Python Script in Odoo


In the past two years, Odoo has turned out to be a blessing for different industry verticals. This innovative software suite is used widely to develop everything from an online pharmacy solution to a distinguished banking app.

Odoo is an ideal solution for start-ups, enterprises, and large organizations. It can transform complex business structures into a simple and organized structure.

You can use an integrated system to share data across departments with a few clicks seamlessly. Odoo ERP has become the reliable pillar of several businesses. It has reformed processes for:

  • Inventory management
  • Production
  • Order management
  • Supply chain management, and many more.

Today, talented Odoo ERP development services can offer you customized solutions suitable for your entity.
[Also read: Warehouse Picking made Faster with Odoo Mobile Inventory Application]

In this article, we have discussed the following:

  • Understanding Odoo
  • Steps to Import Excel File with Python Script in Odoo
  • Prominent Odoo Benefits to Shape Future of Your Business

Understanding Odoo

Founded in 2005, Odoo is an open-source software suite for business modules and applications. It was also known as OpenERP and is suitable for several processes such as accounting, CRM, manufacturing, sales, and many more.

Odoo has gained popularity in a short span due to its open-source capabilities across varied industry verticals. Besides, it is also affordable for businesses of all nature.

Odoo functions on modules that are easy-to-install. These modules are designed such that they can communicate and share data across departments and systems. Open-source Odoo ERP systems offer over 30 main modules and 16,000 third-party apps and plugins in the app store.

With a wide array of plugins, it is convenient for businesses to choose the right module for their company.

A few striking features of Odoo ERP:

  • Advanced and real-time updates
  • User-friendly
  • Global support
  • Smooth third-party integrations
  • Reduced implementation costs
  • Flexibility
  • Readymade apps
  • Advanced modular designs

Have a Project Idea?

Want to convert your idea into a successful app or website? Schedule your free call with our expert now.

Steps to Import Excel File with Python Script in Odoo

Step:1 Select the excel file that you want to import. We have shared here an example in the following image.

[Also read: 8 Reasons Why Odoo Is the Most Secure Platform According to OWASP]

The excel sheet comprises the following columns:

  • Column 1: Name of either the company or customer
  • Column 2: Boolean field column
  • Column 3: Street name
  • Column 4: ZIP code
  • Column 5: City name
  • Column 6: Name of the state
  • Column 7: Name of the Country
Fig 2

Step: 2 Create a wizard to import the file in the Odoo. The file name notifies the path and location of the excel file. Check fig. 2 for a better understanding of the file name.

Step: 3 Click on the Import customer button to execute the python script. Fig. 3 gives you a clear vision of how your python script looks like.

Fig 3

In this example, we have used the xlrd library to read the data from the excel file. We have also used try to test errors in a specific block of code and except to manage those errors.

In case you have entered the wrong file name or the file name is not found in the directory it will notify you with a user error- No such file or directory found.

Xlrd.open_workbook- This will open a spreadsheet file for data extraction.

Wb.sheet_by_index(0)- This will help you to open sheets with the help index values. For instance, (0) first sheet from the file, (1) indicates the second sheet from the file, and further so on.

The loop function is used to iterate all the rows. For example, if row>=1, then it is referred to as an if statement. The row index is in range(thesheet.nrows).

We have used vals as a dictionary which also comprises a key and value pair. A section on the left side highlights keys field name. Once this is done, create is called which is an ORM method and then you have to pass it through the vals dictionary.

This is the easiest method to import excel files in Odoo using python script.

Prominent Odoo Benefits to Shape Future of Your Business

Open Source

Modern Odoo-ERP software offers cutting-edge businesses with automated and streamlined processes. This software can convert day-to-day hassles into a synchronized process.

Odoo empowers companies to lead the market with the right use of the latest technology and adopt industry changes.

The open-source capability ensures that the source code is accessible to everyone. The source code acts as a platform with constant modifications and evaluation.

Thousands of developers work round the clock on Odoo ERP to discard bugs. They customize and introduce new features in the most natural form as per business requirements.

Quick and Futuristic Decision-Making Capabilities

Odoo offers real-time data to businesses that can be considered to make quick and lucrative business decisions. Companies can make faster decisions with marketing, inventory, accounting, and other business areas and save resources and time.

Timely decisions can save your business from unwanted losses and skipping deadlines. A responsive vision offers better business potentiality.

Companies with such capabilities can detect flaws in advance and rectify them before they turn into an issue. The integrated detailed reports make it convenient for managers to make robust and quick business decisions.

Easy integration

Odoo is not only customizable but also API-friendly and easy to integrate with. It is easy to implement Odoo ERP and integrate it with your existing systems. This way, your team doesn’t have to experience major behavioral changes.

Instead, they experience better connectivity across systems and departments.

Reduced Implementation Costs

Odoo has a comparatively low cost of implementation and maintenance. Additionally, Odoo has no licensing fees which save you a heavy cost of investment.

Odoo’s Enterprise version has a significant number of features and is inclusive of licensing fees. However, the cost is still lesser than other expensive business solutions.
If you are looking for the right Odoo Partner to take your business to the next-level, contact Brainvire today.

Improved Data Transparency and Productivity

When you integrate Odoo ERP with your small enterprise system, you eliminate the probability of errors and enter the same data into the system. The integrated system ensures that each department has proper access to data related to their department.

This eliminates the scope of data duplicity in the business.

Alongside, departments don’t have to go through a lengthy process to obtain a piece of particular information. They can acquire the required information within a few clicks.

This assures that there is data transparency in the company. The firm doesn’t have to make additional investments for data security and maintenance.

Your company can use the additional time and resources to improve productivity. Different departments can coordinate among themselves through this integration, plan activities, and complete tasks within the set deadline.

A single system can overlook all business operations and improve net business productivity.

Highly Customized and Secured

The Odoo-ERP solution is highly-flexible, reliable, and suitable for all companies. Organizations have the liberty to combine functionalities and features suitable for their firm. Developers can assist you to make the right choice in this process.

The open-source nature of this software elevates the security capabilities. Experts can easily find flaws and craft a robust solution that is suitable for your business purpose.

This user-friendly solution can expand your future potential.

Learn more about the Odoo software suite and its impact on your business from experts. Call us now!

How useful was this post?

Click on a star to rate it!

Average rating 1 / 5. Vote count: 44518

No votes so far! Be the first to rate this post.