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.