Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

ลูกค้าสัมพันธ์
e-Commerce
ระบบบัญชี
สินค้าคงคลัง
PoS
โปรเจกต์
MRP

All apps

All Posts คน เหรียญรางวัล

แท็ก (View all)

odoo accounting v14 pos v15

เกี่ยวกับฟอรั่มนี้

ช่วยเหลือ

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

company remove demo_data

7 ตอบกลับ

51278 มุมมอง

Sohail

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.

Keyur

คำตอบที่ดีที่สุด

Hi Sohail,

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

Keyur

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.

umer farooq

@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 ??

Keyur

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

Andreas Fuchs

@avarcas.com Thanks for your answer helped me allot

Avarcas.com

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;

iWesabe Technologies

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.

สนุกกับการพูดคุยนี้ใช่ไหม? เข้าร่วมเลย!

สร้างบัญชีวันนี้เพื่อเพลิดเพลินไปกับฟีเจอร์พิเศษและมีส่วนร่วมกับคอมมูนิตี้ที่ยอดเยี่ยมของเรา!

ลงชื่อ

Related Posts	ตอบกลับ	มุมมอง
After Load Data Demo demo_data	1 มิ.ย. 25	1760
creation of company แก้ไขแล้ว company	1 ต.ค. 24	13200
Not able to create new company in live database in version 15 company	0 ต.ค. 22	2964
Is possible update value in exist demo data ? แก้ไขแล้ว demo_data	2 มี.ค. 22	13343
Function tag and getitem tag demo_data	2 ม.ค. 18	9297

คำถามนี้ถูกตั้งค่าสถานะ

You never use demo database for business !!!

สนุกกับการพูดคุยนี้ใช่ไหม? เข้าร่วมเลย!