Import Master Data Odoo 12

5 min readMar 26, 2021

In this another article of me and Odoo 12, we started based on a simple scenario: importing a CSV file as a database in Odoo12. Here I got the chance to use my faculty Odoo 12 environment to work with.

My tutorial on youtube

First of all, we need to set up di CSV to import. For this scenario, I got the CSV from Akhmad Daniel Github. We need to clone the GitHub, and it is all set.

Next, we log in to the Odoo 12 system and set up all the necessary modules. Also, we mainly work in developer mode, so don’t forget to activate the developer mode.

First of all before going further into importing each CSV file i already try the process on my local database, there are a couple of things that we need to set up.

Clear the chart of account for the first CSV file will create an error, that error will be solved by going into the company properties that located in the settings via developer mode access, here we search for a certain variable and delete the value.

After that, we go into the Accounting Module and go to the Taxes and Journal to delete field values of “Tax Account” and “Tax Account on Refunds” from Taxes and “Default Debit Account” and “Default Credit Account” from Journal.

Tax Account and Tax Account on Refunds cleared

Default Debit Account and Default Credit Account cleared

Luckily there is a StackOverflow thread for this that you can read here.

After that, for the 7th and 8th import, we need to add new authorization to our user. In this case, my user clicked the “Manage Multiple Stock Locations” and “Manage Multiple Warehouses.”

After that, we go to the Inventory Module and go to the configurations tab and click on settings there. We need to click the “Storage Locations” and “Multi Warehouse” for the 7th file and “Units of Measure” for the 8th file.

After all, this everything should be set up nicely, and we can start importing the file.

File 1 : account.account

First, we need to go to the Accounting Module -> Configurations -> Chart of Account (CoA) and then delete the existing data and import and don’t forget to test the import see the data inside the CSV file.