Hi,
We're currently using a scheduled SQL task to remove campaigns from products once they're over, and it's working well.
The issue we're facing is with caching: the products keep showing the campaign info until we manually clear the cache.
Is there a way to automate both the campaign removal and cache clearing at the same time?
Any advice or solutions would be greatly appreciated.
Thanks!