I want to update all company pricelists from one to another in a batch, but I don't see anywhere in the database that stores the pricelist id for the company.
Where is this information stored?
http://goo.gl/jn0O7K
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Contabilitate
- Inventar
- PoS
- Project
- MRP
Această întrebare a fost marcată
3
Răspunsuri
4944
Vizualizări
The Sales Pricelist's field name is actually property_product_pricelist, which indicates it is a field of type property (deprecated in v8).
Basically, the values for this field are not stored in the res_partner table as I expected.
Each record is stored in the ir.property table, as you can see if you view the database with the following query:
SELECT * FROM ir_property WHERE name = 'property_product_pricelist';
You can theoretically update the values by SQL commands, but I would recommend against it (maybe someone else has a good way of doing that safely?).
For some better understanding of property fields, check the following links:
V6 Documentation: https://doc.odoo.com/6.0/developer/2_5_Objects_Fields_Methods/field_type/
Beginner question about functional fields and property fields?: https://www.odoo.com/fr_FR/forum/aide-1/question/beginner-question-about-functional-fields-and-property-fields-77398#answer_77401
Can anyone clearly explain property fields?: https://www.odoo.com/fr_FR/forum/aide-1/question/can-anyone-clearly-explain-property-fields-42887
Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
Înscrie-te| Related Posts | Răspunsuri | Vizualizări | Activitate | |
|---|---|---|---|---|
|
1
iun. 25
|
692 | ||
|
2
apr. 25
|
1109 | ||
|
0
iul. 25
|
1504 | ||
|
0
ian. 25
|
1079 | ||
|
2
nov. 24
|
6488 |
Hi Travis, by Database what do you mean?
Hello, by database, I mean the PostgreSQL database itself. My idea is to update them all with an update query from psql.