Price is not changing after SQL UPDATE

1 month ago
I need to update prices of all products via SQL, i'm testing one product with command

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 ?
1 month ago
Please don't duplicate topics
1 month ago
New York wrote:
Please don't duplicate topics

Then answer me
1 month ago
Did you try Clear Cache in Admin after updating the price?
1 month ago
glhays wrote:
Did you try Clear Cache in Admin after updating the price?


Yes, I write it, but i need to clear only price cache, i dont want to clear whole cache every 20mins...