Odoo Help

Take the tour

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

4/17/15, 8:38 AM 2,954 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

Reply Comment Share

1 Answer

--Brett Lehrer--

Director of IT and open source enthusiast.

Brett Lehrer

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!).

Comment Share

Ask a Question

Writer

Victor Admin

Keep Informed

2 follower(s)

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