I need to set the default procurement method for all products at once. Also new products added in the system will have same procurement method.
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Księgowość
- Zapasy
- PoS
- Project
- MRP
To pytanie dostało ostrzeżenie
2
Odpowiedzi
8009
Widoki
Go on pgadmin, select a database and execute this sql query:
UPDATE product_template
SET procure_method= 'make_to_stock'
Possible values for procurement method field are : make_to_stock or make_to_order
If you want to set default value for a field from the UI, take a look at this topic
I haven't played with the 7.0 database much S@@D, is it the same Schema for most part? Good to know if so.
Yes, it's the same for most part and specially for product models.
Your answer was correct SAAD but what when i deliver the system to the client and he adds a new product each day, he wants the default procurement method to be set?
I updated my answer !
You could export a CSV with ID's, then reimport it with that field changed. I think that would be the 'suggested method' Or alternatively, you could write a sql query against the database, that is probably the method I would choose. What version of OpenERP?
Podoba Ci się ta dyskusja? Dołącz do niej!
Stwórz konto dzisiaj, aby cieszyć się ekskluzywnymi funkcjami i wchodzić w interakcje z naszą wspaniałą społecznością!
Zarejestruj się| Powiązane posty | Odpowiedzi | Widoki | Czynność | |
|---|---|---|---|---|
|
1
kwi 23
|
1916 | ||
|
0
mar 15
|
3821 | ||
|
0
gru 24
|
908 | ||
|
product.template vs product.product
Rozwiązane
|
|
2
cze 23
|
48325 | |
|
3
sty 24
|
15887 |
