Excel File Upload to update Product Inventory

Question

We have successfully created products from the file upload.
Now we want to be able to update inventory, but are struggling with mapping the field in our import to the Quantity.
Can anyone help with what the correct column name should be - or the field to map to?
We have only one warehouse if that factors in.
Please Help.
Thanks!

Bertus Kruger · Accepted Answer

Depends on your version of Odoo.
Inventory App -> Operations -> Inventory Adjustment is usually the place to do the adjustments.
With an inventory adjustments you should be able to export the records you are planning to change and then import the spreadsheet back into Odoo.
link to the Odoo documentation on the Inventory Adjustment process...  Link [1]

[1] /documentation/16.0/applications/inventory_and_mrp/inventory/management/inventory_adjustments/count_products.html

Roberto Ponceleon · Answer

I am new to Odoo and woudl like to update my products. What do you recommend me? Thanks

Cybrosys Techno Solutions Pvt.Ltd · Answer

Hi,
Please refer to this blog. It shows setting up inventory for a new company and importing the existing records using xlsx file.

https://www.cybrosys.com/blog/how-to-set-up-inventory-for-a-new-company-in-odoo-16 [1]

Hope it helps

[1] https://www.cybrosys.com/blog/how-to-set-up-inventory-for-a-new-company-in-odoo-16

Alex Reiss · Answer

I have succeeded in making an inventory adjustment, but what I want is a field where I can SET inventory to an absolute number. Does this exist?

คำถามนี้ถูกตั้งค่าสถานะ

สนุกกับการพูดคุยนี้ใช่ไหม? เข้าร่วมเลย!