Home Forums WoodMart support forum Issue with Product Filter Showing Past Sale Items

Issue with Product Filter Showing Past Sale Items

Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • #718751

    Web Revolution
    Participant

    Hi Woodmart Support Team,

    I hope you’re doing well.

    We are currently encountering a minor issue with the product filter/widget functionality. The filter is still displaying some products as “on sale” even though they are no longer on sale. It seems this is happening because those products previously had a sale price set and scheduled, and the filter is still picking them up.

    We’ve checked the relevant settings, but couldn’t find any option that would allow us to adjust or correct this behaviour.

    At this stage, we have manually fixed them by clearing the Expired transients in WordPress

    Could you please advise on the best way to resolve this issue properly? Any guidance or recommended settings would be greatly appreciated.

    Thanks again for your support and help — we really appreciate it.

    Kind regards,
    Web Revolution

    Attachments:
    You must be logged in to view attached files.
    #718803

    Aizaz Imtiaz Awan
    Keymaster
    Xtemos team

    Hello,

    There is no separate Woodmart setting causing this — it is cached filter data + outdated sale meta after expiry.

    To ensure it doesn’t happen again:
    – Make sure all expired sale dates are properly cleared
    – Clear WooCommerce product lookup tables
    – Clear any caching layer (plugin/server/CDN)
    – Rebuild WooCommerce product transients if needed

    Best Regards

    #719200

    Web Revolution
    Participant

    Hi Aizaz,

    Thanks for your reply and clarification.

    We can certainly handle this manually and even run the WooCommerce cron jobs ourselves when needed. However, since the theme provides a built-in “On Sale” filter functionality, we would expect it to work reliably and automatically 100% of the time without requiring manual intervention after sale prices expire.

    Is there any alternative solution, recommended configuration, or known fix that would ensure the Woodmart “On Sale” filter always reflects the correct sale status and automatically removes products once their sale period has ended?

    We would appreciate any guidance on how this can be achieved so the filter functions as intended out of the box.

    Thank you.

    #719213

    Aizaz Imtiaz Awan
    Keymaster
    Xtemos team

    Hello,

    The WoodMart “On Sale” filter itself does not store separate sale data — it relies on WooCommerce product lookup tables, transients, and scheduled sale cron jobs.

    Navigate to WooCommerce > Status > Tools and run:

    – Regenerate product lookup tables
    – Clear transients
    – Regenerate product attributes lookup table

    Unfortunately, there is no separate theme-side setting that controls this behavior because the sale status is generated dynamically by WooCommerce itself.

    Best Regards

Viewing 4 posts - 1 through 4 (of 4 total)