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:
- 客户关系管理
- e-Commerce
- 会计
- 库存
- PoS
- Project
- MRP
此问题已终结
1
回复
9124
查看
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.
| 相关帖文 | 回复 | 查看 | 活动 | |
|---|---|---|---|---|
|
4
3月 15
|
9874 | ||
|
2
3月 15
|
6013 | ||
|
1
11月 22
|
2299 | ||
|
0
6月 22
|
2475 | ||
|
2
3月 22
|
1121 |
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.