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 set quantity of all products to 0 quickly

By
OLIVIER INFORMATIQUE
on 2/1/14, 1:25 PM 3,733 views

Hi,

I would like to set the quantity of all my products to 0 quickly (20.000 products).

By the web interface or even with a SQL request.

Any idea ?

Thanks

2

Borni DHIFI

--Borni DHIFI--
5102
| 6 8 9
Tunis, Tunisia
--Borni DHIFI--

Techno Functional Consultant Odoo(OpenERP) 

http://www.linkedin.com/in/borni

Skype : dhifi.borni

Borni DHIFI
On 2/1/14, 2:06 PM

Hi,

Quantity On Hand is a function field. this is a calculated field so you can not change it.

in help :Quantity On Hand :Current quantity of products. In a context with a single Stock Location, this includes goods stored at this Location, or any of its children. In a context with a single Warehouse, this includes goods stored in the Stock Location of this Warehouse, or any of its children. In a context with a single Shop, this includes goods stored in the Stock Location of the Warehouse of this Shop, or any of its children. Otherwise, this includes goods stored in any Stock Location with 'internal' type.

to modifiy this quantity should be used import in Physical Inventory : Warehouse --> Inventory Control --> Physical Inventories .

doc openerp :https://doc.openerp.com/7.0/book/5/5_14_Stock/5_14_Stock_inv/#initial-inventory

0
Damian Phang
On 2/2/14, 7:13 AM

Go to Warehouse -> Products -> Click on 1 - 80 of ### -> Select Unlimited -> Use the checkbox on the left to select all -> Export -> Select Export All Data -> Add the field "Name" and "Quantity on Hand" -> Set to 0 -> Import back to OpenERP

0
Angela
On 2/1/14, 2:13 PM

Another solution is a small piece of python in your cutomisation module which loops on all products and sets quantities to zero (I'd say this is about 10 lines og python at most)

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

0 follower(s)

Stats

Asked: 2/1/14, 1:25 PM
Seen: 3733 times
Last updated: 3/16/15, 8:10 AM