Odoo Help


Is there a way to clear a database of all posted transactions, stock movement and activity without changing configurations and settings in the modules? (Odoo V8)

on 10/9/14, 12:56 PM 1,455 views

Here is what i want to do

- I have created a database and i want to use it for testing so to this effect, many transactions and product movement will occur within the database. However, I wish to use this same database as a production(live database).

- I want to know if it is possible to clear all transactions and activities within the database without having to uninstall and re-install the modules in which they occur because the modules have custom fields and menus that took alot of time to build and develop

I wish this to be done without having to duplicate the database as this is not currently possible.

Please is this possible and how do I go about it?

hhhhmmmm i usually access the database through pgadmin or psql and delete the related transaction manually using query but you need to take a note you should do it carefully and you need to understand the flow this method is not recommended

Hengky Zhang
on 10/10/14, 1:12 PM
On 7/14/15, 2:30 AM

Go to Settings -> Technical -> sequences and Identifier -> Sequences. Find the required objects and Sequence code and reset the required one. Eg : purchase Order. Type PO in search filter and open the record and change the next number to 1. You can reset any sequence code

On 7/13/15, 11:36 PM

have tried this but the problem is the sequence or the id of the transactions, i have a problem locating where i can reset the sequence for these transactions, hope you can also help me .. errors occur when creating new entries for that cleared database.

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

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

2 follower(s)


Asked: 10/9/14, 12:56 PM
Seen: 1455 times
Last updated: 7/14/15, 2:30 AM