I'm an Odoo noob and I just imported some products from Drupal Commerce into Odoo. Drupal Commerce likes working with cents instead of euros. So I want to programmatically drop 2 zeros from all prices. How can I do that? Ideally some python code from the interface itself or some other form of scripting which is not directly working on SQL.
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- सीआरएम
- e-Commerce
- लेखांकन
- इन्वेंटरी
- PoS
- प्रोजेक्ट
- MRP
This question has been flagged
1
Reply
8694
Views
Is fixing the file and importing again an option for you? If not:
- Either export the products from the database (using the "help with import" option), change the file and re-import that file.
or
- Find the product_product table in postgres and write some script to alter the prices.
In order to prevent your database from clogging or becoming messy, I would opt for the re-importing of the products.
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 | |
|---|---|---|---|---|
|
1
अग॰ 25
|
1690 | ||
|
3
अक्तू॰ 24
|
5093 | ||
|
3
मार्च 24
|
5971 | ||
|
2
मार्च 24
|
4375 | ||
|
0
सित॰ 21
|
3377 |
