Home › Forums › Price Robot for WooCommerce › Formula for lowering price every 7 days › Reply To: Formula for lowering price every 7 days
October 4, 2022 at 9:47 pm #92228
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.