Changing product price according to period

[yberges]

Hello is possible to change price of product according to date ?
ex
a product 15€
between 12 august 12 septmbre 10€
between 13 septmbre 15 october 20€
regards

[Vadym]

Hi yberges,

Such logic can be easily implemented by Formula:

$a = '2022-08-12';
$b = '2022-09-12';
ifThen(datetime\today() >= $a && datetime\today() <= $b, costPrice = 10);

$c = '2022-09-13';
$d = '2022-10-15';
ifThen(datetime\today() >= $c && datetime\today() <= $d, costPrice = 20);

Create a Workflow for Product entity with `After record saved (created or updated)` Trigger Type, add `Execute Formula Script` action and paste the formula inside.
Also, if you don't have an Advanced Pack, you can insert the formula into Administration -> Entity Manager -> Product -> Formula.

Documentation:

https://docs.espocrm.com/administration/workflows

https://docs.espocrm.com/administration/formula/

[yberges]

oki cool i will try !!!
the first goal is
before 1er sept : 200€
to 2 au 29 sept : 220€
after 29 sept : 260€

[lazovic]

Please, in lines 9, 10 and 11, replace the letters “c” and “d” with “e” and “f”, for example.
Otherwise, the whole third part of the formula will not work correctly.

[Vadym]

Hi yberges,

As noted by the lazovic above, you need to change the c, d variables in the third part of the code to unique ones.
Also, please note that Formula is required to put in Actions -> Execute Formula Script scope, instead Conditions scope.

[yberges]

hello cool i will test it thanks

[yberges]

juste a question how i can assign this formula to one product ?

[lazovic]

Since you specified a Condition with a specific name, the formula will only work for that product anyway.

[rabii]

use the code in formula of the Product Entity

[yberges]

thanks !