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

What is the best way to manage larger volumes of data?

By
Michael Scorpio
on 10/21/15, 8:00 AM 276 views

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.

AD LIBITOM, michel Guénard
on 4/12/16, 5:22 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

2 follower(s)

Stats

Asked: 10/21/15, 8:00 AM
Seen: 276 times
Last updated: 4/12/16, 5:07 PM