I have a situation where I need to update some values on the master product, based on some values of the Variants.
I have created a Scheduled task using the SQL add-in and I have added my SQL statement.
The Scheduled task runs correctly and the values in the database are updated.
However, even if the updated value is visible on the Product list in the back-end, if I open the product details page, the value is not updated in the interface.
And if I try to output the value in a template in front-end, I don't get the updated value.
Is this a known issue? Is there any solution for it?
I am running on DW 9.9.7.