Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

0

How can I change all product prices?

By
Kasper Souren
on 6/10/14, 9:10 AM 689 views

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.

0

Ludo - Neobis

--Ludo - Neobis--
2387
| 2 2 5
Hoogvliet, Netherlands
--Ludo - Neobis--

Developer

Ludo - Neobis
On 6/10/14, 11:21 AM

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.

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)

Stats

Asked: 6/10/14, 9:10 AM
Seen: 689 times
Last updated: 3/16/15, 8:10 AM