Odoo Help

1

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

By
Sohail
on 6/27/13, 7:34 AM 10,790 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.

1

Keyur

--Keyur--
1185
| 4 4 8
Ahmedabad, India
--Keyur--

Odoo Expert

Keyur
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.

Keyur
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.

Keyur
on 11/26/13, 9:21 AM
0
Avarcas.com
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 99.99.99.99


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; 

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.

Register

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)

Stats

Asked: 6/27/13, 7:34 AM
Seen: 10790 times
Last updated: 7/19/17, 8:07 AM