Hello there,
I did many importation tests in the last week.
Now, I want to reset ID auto-increment.
Is it possible to reset those ID number in the Odoo web client?
Or the only way to modify it is PGadmin ou psql?
Thanks
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Accounting
- Inventory
- PoS
- Project
- MRP
This question has been flagged
1
Reply
8772
Views
I have installed pgadmin.
I have changed the «actual value » properties to 1 in these two sequences :
product_template_id_seq
product_product_id_seq
Now, I can create new product without problem. The id column beginning to 2.
Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign up| Related Posts | Replies | Views | Activity | |
|---|---|---|---|---|
|
4
Mar 15
|
9304 | ||
|
2
Mar 15
|
5550 | ||
|
1
Nov 22
|
1699 | ||
|
0
Jun 22
|
1988 | ||
|
2
Mar 22
|
866 |
You customized tree view to see the product id ? I don't know the answer to that question. I think we need to test in a test database and make backups as you advance in the project management with odoo. But on reflection, I think that to fill id already allocated must first remove ... can you remove all items created?
Of course that I customized this view. I want to well understand how odoo works before to import all my products.
I can easily delete all the products that I want. But ID always increase.
From what I have seen, the system increments the id to each creation. If you create an article without finishing the procedure (ie without saving), an id will still be used for anything. But after all it does not matter as the system manages the internal id, just let him do good, right?
I know, I know... you are right. thanks.