UPDATE [genelec_nop].[dbo].[Product] SET [price]=60 WHERE [sku]=41942
SELECT [Name],[Sku],[price] FROM [genelec_nop].[dbo].[Product] WHERE [sku]=41942
First of all lets define something
Old price = 50
New Price = 60
When i do SQL Query, in database i got new price(60), but when i refresh page of product, there is old price(50).
The old price will stay untill i clear whole cache via Admin panel.
Now i need to create a Scheduled Task to clear price cache of all products, so not whole cache, only price of prodcuts.
how can i do it ?