Odoo Help


Why can't import quantity on hand?

Cathy Ely
on 7/17/13, 7:59 AM 7,775 views

I am setting up a new database for an existing company and I want to import all the products and their quantity from a stock take that will be done. It seems that you can export the products and quantity on hand but cannot import the current stock quantity.

Can anyone tell me if there is a way to do it without it being a manual process as there are a lot of products to load up.

Did you ever resolve this? I was wondering the same thing.

Jim Biergans
on 8/4/13, 7:53 PM

I had this same exact problem so I figured a way to hack the quantities in. I am not sure if this will work for you, but here's the guide I wrote: https://docs.google.com/document/d/1ca9s836s5h1cnYttc2iCKkjjfFI4zjF93OPztAOzvU8/edit?usp=sharing

Prosound Communications Inc., Dylan Frankland
on 8/29/13, 8:25 PM
Chaaya Chares
On 10/25/13, 12:24 PM

Perhaps you found the answer for this, but this is in case someone else is looking:

The way I imported the Quantity on Hand is via the Physical Inventories under Warehousing. 1- I exported the products that I want to update in order to get the product external id and unit of measure. 2- Exported the physical inventories in order to get the format of the CSV file. 3- Copied the Product External ID and UOM External ID from the Products file and insert them in the CSV file to import 4- change the quantities (note that the quantity you set is added to the existing quantities, not replaced, i.e. stock move in) 5- Import the CSV file, Confirm, then Validate.

Good luck.

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 7/17/13, 7:59 AM
Seen: 7775 times
Last updated: 9/8/16, 1:09 AM