I have a client who has set the inventory of all products in 9999 pieces. Now he wants to use the warehouse management.
It should all products are reset to 1. Is it possible to automatically make?

Maybe with a SQL-Query?
Or an extension?
We use Magento 1.9.0.1

Thank you ever