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	Відповіді	Переглядів
Licenses management on premise Вирішено pricing price odoo onpremise	1 лют. 21	4137
Is there a difference between minimum quantity of 1 and a minimum quantity of 0? Вирішено pricing	2 лип. 25	876
Problem with tax included price Вирішено price	1 черв. 23	242
Pricing Variants product pricing price variant attributes	2 бер. 23	2224
With odoo 16 what are the prices for iot box? price	1 груд. 22	4183

Це запитання позначене

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