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?

Gerelateerde posts	Antwoorden	Weergaven
Import user group fails with No matching records found for name importing importerror	0 jun. 24	2201
Inventory assistance to capture data spefic to each item in storeroom products Inventory	0 mrt. 24	1645
Cannot remove test item from products or invnetory products Inventory	1 nov. 22	2215
Is there a list of all sales/products/ import fields? importing products	2 sep. 22	4154
Inventory Managment Opgelost products Inventory	1 jul. 21	2445

Deze vraag is gerapporteerd

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!