I am using WooZone to import and sync Amazon products and I have a problem with the products on sale.
After each daily sync the products on sale are not updated when using the WC sales sortcode.
The problem is resolved only if I regenerate the lookup tables and clear transients.
So I want to automate the lookup tables regeneration and transients clear after every sync.