Inventory Products - Import Error - Missing required value for the field 'location_id'

Question

I'm trying to update the quantity of my products by importing an
xlsx file, however I receive the error message "Missing required value for
the field 'location_id'".

I export the products, making sure I check  " I want
to update data (import-compatible export)", as well as including
Location/External ID. From there I include the location as
"stock.stock_location_stock" in the location id column.

I just want to update the products
in SOH, so I've used the location ID as "stock.stock_location_s

Miguel Cruz · Answer

You need to add a column "Location/ID" to your xls file Set the appropriate value in each cell what are the valid values?  In Settings, Activate the developer Mode In Settings, Menu Technical > section Sequences & Identifiers > "External Identifiers" Search for Model Name for: stock.location use one the values in column "Complete ID" (e.g. stock.stock_location_stock)
I hope this helps.
If you found this answer helpful, please consider upvoting so others can find this solution too. Thank you. 🙏

Thuy Ngoc · Answer

Hi Luke,
I think this video can help you:
https://www.youtube.com/watch?v=UOBxxnYDIsM&list=PLSKcWRTtEl5qzvRaI-VTGavfReiHS_EEb&index=1

Cybrosys Techno Solutions Pvt.Ltd · Answer

Hi,
For solving this first you need to export Location/ID from the stock.quant , and then importing you can add the location id here.

Regards

Largotek S.R.L. · Answer

Fix it, you just need to fill the field operations / dest_location_id or operations / location_id in your case.
never teh less you can buy this module  https://www.odoo.com/es_ES/shop/ip-import-picking-import-shipment-delivery-internal-transfer-by-ipredict-it-solutions-pvt-ltd-for-version-15-0-47575#attr= [1]

[1] https://www%5C.odoo%5C.com/es_ES/shop/ip%5C-import%5C-picking%5C-import%5C-shipment%5C-delivery%5C-internal%5C-transfer%5C-by%5C-ipredict%5C-it%5C-solutions%5C-pvt%5C-ltd%5C-for%5C-v

Alexander Vranken · Answer

We have the same issue, anyone found a solution?

相關帖文	回覆	瀏覽次數
Import user group fails with No matching records found for name importing importerror	0 6月 24	2257
Inventory assistance to capture data spefic to each item in storeroom products Inventory	0 3月 24	1659
Cannot remove test item from products or invnetory products Inventory	1 11月 22	2236
Is there a list of all sales/products/ import fields? importing products	2 9月 22	4198
Inventory Managment 已解決 products Inventory	1 7月 21	2458

此問題已被標幟

喜歡這則討論？不要只閱讀，加入發表意見吧！