Price calculation with formula

Question

Hi!
At one of our companies we sell electrical appliances so therefore also cables.
In Austria, we charge a base price for the cable that includes some of the copper or aluminium and other commodities and an extra charge for the commodities that targets the volatility of them.
Is there a way or a module that can calculate the prices like once a week or per day based on the amount of the commodity that is in the cable while we set the commodity price manually or dynamically?
The formula looks som

vishalratani · Accepted Answer

Create a scheduler that runs every week and updates the price of the product based on commodity price / any other parameter for volatility that you use.

Denis Baranov · Answer

Hi,
look at this module - https://apps.odoo.com/apps/modules/11.0/variants_bridge_pricing_numerical/
If amount of commodity is an attribute of the product, it might suit.

Stephan Mitterer · Answer

@IT Libertas: Thanks, I'm going to write the developer to see if that works!
In general it maybe should also be possible to hardcode a formula that takes the base price + the amount of the commodity (from an attribute) to multiply it with the commoditiy price - even though I don't know where I should store that price. (Maybe as another product? Like a copper product, an aluminium product and so on)

@vishalratani: Thanks, is it possible to run a recalculation when the price of the commodity chan

Related Posts	Replies	Zobrazenia
Licenses management on premise Solved pricing price odoo onpremise	1 feb 21	4010
Is there a difference between minimum quantity of 1 and a minimum quantity of 0? Solved pricing	2 júl 25	736
Problem with tax included price Solved price	1 jún 23	242
Pricing Variants product pricing price variant attributes	2 mar 23	2104
With odoo 16 what are the prices for iot box? price	1 dec 22	4017

This question has been flagged

Enjoying the discussion? Don't just read, join in!