Odoo Help


How to delete all test accounts / sales orders / journal entries at once without wiping the whole database

Victor Admin
on 4/17/15, 8:38 AM 1,672 views

I'm sure there has got to be a way to do this - In setting a new server (OpenERP 7), in the process of configuring everything just right and making sure it's right, I have created nearly 100 test accounts and countless transactions.

When everything is perfect and it's time to deploy, how do I wipe out all these accounts and journal entries and get a clean slate - without wiping the database and losing all of the customization I've done? I don't see any obvious way


Brett Lehrer

--Brett Lehrer--

| 5 5 8
Milwaukee, United States
--Brett Lehrer--
Director of IT and open source enthusiast.
Brett Lehrer
On 4/17/15, 8:45 AM

See this similar question: Erase or clear all accounting data from openerp.  In short, there's no silver bullet.  There's the dangerous route of manually truncating tables in postgresql, or the safer method of exporting your core data and re-importing to a clean database.

Any customizations should really be done in new modules, which can be installed on any database quickly and easily.  It also makes maintenance in production much simpler, and allows for easy setup of test environments (which you should have!).

About This Community

This platform 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.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

2 follower(s)


Asked: 4/17/15, 8:38 AM
Seen: 1672 times
Last updated: 1/10/18, 1:25 AM