Odoo Help


Open ERP 7.0 : Order of Importing and mandatory fields

Sudheendra Walvekar
on 3/3/13, 9:21 AM 1,618 views

Dear all,

I have setup openERP 7.0 and have created the company. Now, I would like to import fresh data into the openERP system. It would be of great help if any one can inform, in what order I should import the data into openERP. I need to import following data into the system. 1. Customers,2. Leads, products and product category 3. Taxes,4.Suppliers.

Also, please inform the mandatory fields that should be not be null for each of the imports.



Fabrice Henrion (fhe)

--Fabrice Henrion (fhe)--
| 7 7 9
San Francisco, United States
--Fabrice Henrion (fhe)--

Director Odoo Americas

Fabrice Henrion (fhe)
On 3/3/13, 3:08 PM

This is a question that can become very complicated as the number of objects you want to import increases. The order of import has to do with the objects associations: the most independent an object is, the earlier it will be imported. Essentially, you can only become good at importing csv data (or even through scripts) by knowing the tables structure (PgAdmin will help you visualize this).

In your example, my suggestion will be to import in the following order:

  1. Taxes
  2. Customers and Suppliers (Partners)
  3. Product categories
  4. Products
  5. Leads

As you are migrating from another system, I guess you also need to import your chart of accounts, so you will need to import it first...

Mario Arias Badila
on 3/5/13, 2:35 AM

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

0 follower(s)


Asked: 3/3/13, 9:21 AM
Seen: 1618 times
Last updated: 3/16/15, 8:10 AM