How to set quantity of all products to 0 quickly

Question

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

Borni DHIFI · Accepted Answer

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

Angela · Answer

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)

Damian Phang · Answer

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

Aiheeseen liittyviä artikkeleita	Vastaukset	Näkymät
"Update follow quantity" tracking? product update quantity	1 maalisk. 15	6525
update qty on hand product update quantity all	2 huhtik. 18	6038
How to update products master data in a custom app? product update	1 lokak. 23	2505
How to update product Quantity? Ratkaistu product quantity	1 maalisk. 16	6854
update the product onhand quantity product quantity	1 maalisk. 15	7621

Tämä kysymys on merkitty

Nautitko keskustelusta? Älä vain lue, vaan osallistu!