I'm looking to manage several hundred products in Odoo 8, with a handful of warehouses, and with reorder rules for each product and warehouse. I've already learned the hard way how not having one small thing quite right can leave you scratching your head trying to figure out what is wrong. To aid the process I've developed a number of queries that will ultimately form the data source for exception reports. These queries can show me at a glance where one saleable product might be missing reorder rules for a warehouse, or where a purchaseable product is missing a supplier or price on the suppliers pricelist. This has been most helpful in ensuring that I haven't missed anything.
I'm now looking for ways to generate data; the aim being that if I add 20 products and have 5 warehouses, I can avoid the time consuming and errorprone process of keying reorder rules for each product/warehouse combination (in this example 100 entries). Whilst writing SQL against the database is fine for exception reporting, writing insert statements potentially creates problems. A module that can perform tasks like generating default routings and reorder rules would seem to ease the pain of managing volumes of data. Has anyone had experience of this kind of thing?
Your issue is of essence for large volumes; be it to audit the database or to populate it. In my opinion this needs that the developpers address the topic and propose methods and tools for the management of databases. Execptions reports are a necessity which is not covered by the ERP.