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.
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: 1426 times|
|Last updated: 3/16/15, 8:10 AM|