Odoo Help


How to remove demo data from an already live and running application?

on 6/27/13, 7:34 AM 14,099 views

I need to remove Your company and other demo data from an existing application without affecting the useful records. The other company data should remain intact only demo data should be removed.

On 7/19/17, 8:07 AM

You can use the following:

Enter your VPS (if remote) or open terminal if in local:

ssh -l root

Use the postgres user:

➜  ~ su postgres

Select database

➜ ~ psql abc_db_name


And fire this operations in terminal:

delete from stock_pack_operation;
delete from stock_picking;
delete from stock_move;
delete from account_invoice;
delete from account_partial_reconcile;
delete from account_move;
delete from sale_order;

delete from account_payment; 


| 4 4 8
Ahmedabad, India

Odoo Expert

On 6/27/13, 7:44 AM

Hi Sohail,

You should create new database without demo data instead removing demo data from existing database.

I just suggested you an option. There is not any module available to remove demo data. You need to delete it manually. It may happen that in some cases you can't delete demo data record because it is depend on some other record which is necessary.

on 6/27/13, 7:51 AM

@keyur I am having the same problem I want to remove demo data but in my database I have created some new fileds and done some customization everything will be lost Is there any other option for me ??

umer farooq
on 11/22/13, 9:14 AM

@umer the only way I can see, is you can export data from your existing database and import them in new database which has no demo data installed.

on 11/26/13, 9:21 AM

I agree with Keyur.

You never use demo database for business !!!

Deleting demo data through postgres is Not a proper way.

Demo data will be restored if you install/upgrade a module.

Find the installed apps in existing database, create new one and install those. 

Export all data in CSV/Xls and restore in new database. 

Andreas Fuchs
On 10/7/17, 3:55 AM

@avarcas.com Thanks for your answer helped me allot

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

1 follower(s)


Asked: 6/27/13, 7:34 AM
Seen: 14099 times
Last updated: 10/8/17, 1:28 AM