Odoo is the world's easiest all-in-one management software. It includes hundreds of business apps:
CRM | e-Commerce | Accounting | Inventory | PoS | Project management | MRP | etc.
We are trying to import our products into the database but we are getting the error:
null value in column "min_qty" violates not-null constraint
We tried making a new column named min_qty, which was not detected. I tried selecting the product_min_qty field from the list, but that doesn't work either. There is no min_qty column to be selected. Is this a problem with the import verification, or is there a setting somewhere that we are missing?
Before we can fix the issue, can you tell us how you tried to add a new column? Given your text, I think you used openERP to create a new column 'min_qty' on the table 'product'. If so, the name of the column should be 'x_min_qty', which is forced by openERP when adding it.
Is it possible for you to see which fields are defined within postgreSQL on the table product_product and product_template? For example within webmin (on Linux), or pgadmin (linux and windows).
A better way of adding new fields to a table/model is to use custom modules, and define the fields in the python code.
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.Register
Odoo Training Center
Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.Test it now
|Asked: 5/30/13, 6:37 PM|
|Seen: 1923 times|
|Last updated: 3/16/15, 8:10 AM|