Odoo is the world's easiest all-in-one management software. It includes hundreds of business apps:
CRM | e-Commerce | Accounting | Inventory | PoS | Project management | MRP | etc.
I need to make my first product inventory in Odoo v7.
Is there any way I can load all products in the system so I can manually count them and enter the right quantities on each product?
When I use the "Fill Inventory" button, I can only see the products that have positive or negative quantities. I cannot find a way to load the products "with zero quantity". I have lots of products with zero quantitie and load them one by one is very time consuming.
Thank you very much
You can load new products (with 0 quantity) by the import mechanism.
Open the Product menu (left pane), then click on import.
The data (names of products) to import need to be in a text file (extension csv) preparedby a spreadsheet app (excel or libreoffice); the only field needed is the "Name" (one column).
The parameters of the csv file are UTF-8, and a ", " as separator. Make sure the names of the products do not include a ","
I recommend you to make a test with a csv file containing one or two products to import; if it works correctly them import all your other new products.
- in addition to the above
see also https://www.odoo.com/forum/help-1/question/how-to-import-quantity-on-hand-59983
You need to first create an inventory item; then export it to a csv file.
Second: export the list of products with zero qty.
Add to this product.product file the columns of the inventory file (the first one created); This should form a final file where you will change the quantities per products. Save it and import on the product screen.
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
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.Register
Odoo Training Center
Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.Test it now
|Asked: 9/20/14, 4:18 PM|
|Seen: 1377 times|
|Last updated: 3/16/15, 8:10 AM|