How can I change all product prices?

Question

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.

Ludo - 21South · Accepted Answer

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.

Aiheeseen liittyviä artikkeleita	Vastaukset	Näkymät
How to bulk import new prices into a price list using an Excel template import pricelist	1 elok. 25	890
How to import a new fixed-price price list from Excel? Ratkaistu import pricelist	3 lokak. 24	4283
Pro rata prices price pricelist	3 maalisk. 24	5461
How can i get the price history for an item for a customer price pricelist	2 maalisk. 24	3667
Update list_price from Price List price pricelist	0 syysk. 21	2975

Tämä kysymys on merkitty

Nautitko keskustelusta? Älä vain lue, vaan osallistu!