I am not able to import file for quantity on hands for products created

Question

Hello Team,
I have created few products using the import option as follows *: Inventory > Master Data > Products > Import file*
Now I wish to update the "quantity on hand" for these products and I am trying to do it using the import option as follows: *Inventory> Inventory Adjustment> Import*
I have already created my CSV file but when i am doing the import i am getting the following error message:
* "null value in column
"location_id" violates not-null constraint
DETAIL: Failing row contains (2

ayman mohammed adam · Accepted Answer

dear Klix,
Try Excel like this:

*name*   *line_ids/location_id/id*   *line_ids/product_qty*   *line_ids/product_uom_id/id*   *line_ids/product_id*
stock.stock_location_stock  4  product.product_uom_dozen  product name 1
stock.stock_location_stock  2  product.product_uom_dozen  product name 2

Oli · Answer

Hi,

as this is inventory valuation where you have imported the stock you have to validate it after importing. This is the best way to do it.
Best regards

Klix · Answer

Hello Ayman,
I have tried your excel format and it works! I have been struggling with this since yesterday and I really appreciate your helps.
One last thing i would like to know if you can help me on this, After importing products and their quantity using your excel format, i can see that the status of the inventory is set *Draft *after successful import.
I would like to know if it possible to set inventory *Status=Validated *in the excel itself when importing?
Thanking you in advance.
Klix

関連投稿	返信	ビュー
Negative quantities on hand inventory quantity Quantity on Hand	2 10月 24	2306
Inventory adjustment error 解決済 inventory quantity Quantity on Hand	3 7月 22	6465
odoo 12 - import inventories by csv file and location Id import inventory csv	1 4月 21	1923
Set initial stock - importing quantity import inventory quantity	2 1月 21	5013
Odoo 10.0: Import Stock Operations from CSV file import inventory csv	1 8月 18	5042

この質問にフラグが付けられました

name

line_ids/location_id/id

line_ids/product_qty

line_ids/product_uom_id/id

line_ids/product_id

stock.stock_location_stock

4

product.product_uom_dozen

product name 1

stock.stock_location_stock

2

product.product_uom_dozen

product name 2

ディスカッションを楽しんでいますか？読むだけでなく、参加しましょう！

name	line_ids/location_id/id	line_ids/product_qty	line_ids/product_uom_id/id	line_ids/product_id
	stock.stock_location_stock	4	product.product_uom_dozen	product name 1
	stock.stock_location_stock	2	product.product_uom_dozen	product name 2