Reply To: Formula for lowering price every 7 days

#92228
Tom Anbinder
Moderator
Plugin Support

P.S. If you’d want to lower the price by $1 every seven days, then your formula would look like this:

[min value="59"][product_price]-[floor]([current_time]-[product_last_sale_time min_date="2022-10-04"])/(24*60*60*7)[/floor][/min]

i.e., we have 60*7 instead of 60/7.

One note, though – you have set min_date="2022-10-04", so today (i.e., 2022-10-05), the formula will not make any changes to product prices because it has to be at least one full week since the last sale. One exception – it will set the minimum price for all products to $59 (because we have [min value="59"]...[/min]), so if any of your products have an initial price lower than $59, it will be automatically increased to $59.