Odoo Help
Odoo is the world's easiest all-in-one management software. It includes hundreds of business apps:
CRM
|
e-Commerce
|
Accounting
|
Inventory
|
PoS
|
Project management
|
MRP
|
etc.
How to delete all test accounts / sales orders / journal entries at once without wiping the whole database
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
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.
RegisterOdoo Training Center
Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.
Test it nowQuestion tools
Stats
| Asked: 4/17/15, 8:38 AM |
| Seen: 1672 times |
| Last updated: 1/10/18, 1:25 AM |
