How to filter woo product has price lower than lowest price in N days

  • Resolved migen22

    (@migen22)


    1 month, 1 week ago

    I find that Product Price History for WooCommerce is good plugin, however, as many affiliates and comparison sites, discount sites, I want to find real deals which has current price lower than the lowest price in N days (7 days, 30 days,…) to find the real bargain for website visitors.

    ————-

    For example – find Real Deal has price lower than the lowest in 3 days:

    norton antivirus has price $10, $11, $15 – the lowest in 3 days : $10

    today – current price: $9 (lower than the lowest – $10)

    When the product meets the requirements, it will save a notice in a custom field (used for filter and sorting using custom field value number, such as fill 7 in the custom field if product price is lower than the lowest in 7 days, 10 if it lower than lowest in 10 days,… in the custom field “best_deal_value”)

    ————-

    And I will filter& display these deals in a page using these custom field value numbers.

    Hope you can consider this feature.

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author Marin Matosevic

    (@marinmatosevic)

    Hi,

    Thank you for your suggestion!

    Unfortunately, this functionality isn’t available in our plugin at the moment. However, you could achieve this with some custom coding by retrieving the relevant data from the pph_price_history table.

    We’ll take this feature request into consideration for future updates.

    Best regards

    Thread Starter migen22

    (@migen22)

    Thanks for your response.

    I intend to find the product which has current price equal to the lowest price in 3 days. (current price = the lowest price in 3 days). then it will note in the custom field (for filtering later) if it meets requirements.

    I usually to use ChatGPT/ Copilot to write simple code/script.

    Can you give me some hints: such as how to retrieve the data of last days – day 1, day 2, day 3 … to compare with the current price (price of today) ?

Viewing 2 replies - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.