Community mailing list archives


Re: database cleanup

Pedro M. Baeza
- 12/02/2015 10:17:28
There's a better strategy: make a backup or duplicate the BD before inserting any transactional data.


2015-12-02 16:12 GMT+01:00 Andreas Becker <>:
This is a very good question - Keeping your database clean should be easy as it would be good to do this every year at least.


With kind regards,
Mit freundlichen Grüßen,
Con un cordial saludo,
с сердечным приветом,


CEO/General Manager LisAndi Co., Ltd.


LisAndi Co. Ltd., Phuket, Thailand (
15/21 M.2 Viset Road, Rawai, Muang, Phuket, Thailand 83130

VoIP:   +49 (0)711 50 88788 50
Fax:     +49 (0)711 50 88788 50
Skype:          lisandi
Facebook:     andibecker
Google Talk/Facetime/eMail:


This email may contain confidential and/or privileged information. If you are not the intended recipient (or have received this email by mistake), please notify the sender immediately and destroy this email. Any unauthorized copying, disclosure or distribution of the material in this email is strictly prohibited. Email transmission security and error-free status cannot be guaranteed as information could be intercepted, corrupted, destroyed, delayed, incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message which may arise as a result of email transmission

On Wed, Dec 2, 2015 at 8:34 PM, Nhomar Hernández <> wrote:

There is not an easy way with one click but depending which transactions there is pretty easy to achieve a list of tables affected and clear them with an SQL.

At least the ones you mentioned:

Remember reset also the sequences.

But there is an opportunity there when we began with Odoo we look for such module but we never did it :-(

On Wednesday, 2 December 2015, Franco Ordoñez <> wrote:

Is there some way or some module to do a database movement transactions cleanup, I mean i have configured odoo in test environment , created customers, products, have done all configuration everything is tested and successfull. to rollout to production i would like to have some option to delete invoices, whs transactions, account transactions but not delete customers, products, configuration, etc.

Hola comunidad
Existe alguna manera o algun modulo el cual nos permita hacer un borrado de las transacciones de una base de datos, Ejemple he creado una base de datos de test y ahi creamos clientes, productos, configuramos y todo esta ok, ahora para pasar a produccion nos gustaria una opcion que elimine movimientos o transacciones como facturas, movimientos de bodega, contabilidad, etc. pero sin que borre los clientes, productos ni las configuraciones.

Muchas Gracias

- Franco Ordonez

Post to:

Saludos Cordiales

CEO at Vauxoo Odoo's Gold Partner.
Nhomar Hernandez

Post to:

Post to: