This question has been flagged
2 Replies
4165 Views
databasedatabasebackupsampledataodoov11
Avatar
Suhaib Ahmed Khateeb

I have created a database for inventory, and while doing that I have made a lot of sample products and inovices and sales order and purchase order , now that i dont want all these data, i wanted to remove that and i know that these datas cannot be deleted once done

 I have taken the backup of the same and want to restore it without any sample datas.. 

Can anyone tell me how to restore the same database without any sample datas...

Avatar
Discard
Avatar
Niyas Raphy (Walnut IT)
Best Answer

Hi,

There are few modules available in the Odoo app store for cleaning the database(removing data), you can try those modules to remove the existing data in the database.

1. Database Cleanup: https://apps.odoo.com/apps/modules/12.0/database_cleanup/

2. Odoo Customize: https://apps.odoo.com/apps/modules/13.0/app_odoo_customize/

3. Data Clear: https://apps.odoo.com/apps/modules/12.0/clear_data/


All are free modules and different versions are available. Also, have a look at this video: How to Clean the Database in Odoo After testing without lose of configuration

Thanks

Avatar
Discard
Avatar
Muhammed Nishad
Best Answer

Hi Suhaib,

There is an oca module named clear data where you can select models and delete the entire data.

Otherwise you can connect to your database in pstgresql and use this sql query


TRUNCATE public.relation_name CASCADE;

Hope it helps
Avatar
Discard