Odoo Help

Welcome!

This community 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.

0

How to load products with zero quantity in inventory?

By
Paulo Matos‏
on 9/20/14, 4:18 PM 1,265 views

Hi all,

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

Regards

Paulo

0

michel Guénard

--michel Guénard--
1033
| 5 5 8
VIROFLAY, France
--michel Guénard--

VP operations & finance Social entrepreneur Certified Public Accountant Past Chief internal auditor

michel Guénard
On 9/21/14, 3:50 PM

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.

 

Dear Ab, the products are already in the system. The problen is that those products have 0 quantity and I am unable to "load" them into the physicall inventory. I need a way to load all products with 0 quantity onto the inventory system. The "fill inventory" option only works with products with quantity higher or lower than 0 on a particullar location.

ThinkOpen Solutions (Angola), Paulo Matos‏
on 9/21/14, 6:25 PM

Your Answer

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 community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)

Stats

Asked: 9/20/14, 4:18 PM
Seen: 1265 times
Last updated: 3/16/15, 8:10 AM