"min_qty" column error preventing importing products

Question

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?
Thanks

michel Guénard · Answer

The column name that I have added to my csv file when importing new products from a supplier catalogue is

*SUPPLIER / MINIMAL QUANTITY*

The minimal quantity was imported as desired

patrick · Answer

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 fi

관련 게시물	답글	화면
V17 .sh import excel file: time data '2025-01-31' does not match format '%m.%d.%Y' importing	3 7월 25	2220
Odoo journal entry modification after posting by import importing	1 4월 25	1666
Import mehrerer Artikel mit Varianten importing	0 10월 24	1332
Importing Excel/CSV using custom unique field instead of XML ID importing	2 5월 24	4202
Product export then import duplicates everything importing	0 4월 24	1449

신고된 질문입니다

토론이 재미있으신가요? 직접 참여해보세요!