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	Răspunsuri	Vizualizări
Licenses management on premise Rezolvat pricing price odoo onpremise	1 feb. 21	4136
Is there a difference between minimum quantity of 1 and a minimum quantity of 0? Rezolvat pricing	2 iul. 25	870
Problem with tax included price Rezolvat price	1 iun. 23	242
Pricing Variants product pricing price variant attributes	2 mar. 23	2215
With odoo 16 what are the prices for iot box? price	1 dec. 22	4179

Această întrebare a fost marcată

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