Clearing product price cache

musoviich wrote:
After changing that setting you probably need to restart the site.

New York wrote:

Thanks for advice, i tried it and same thing, productbox(viewvox) price is changing but price on product page and cart are not changing, they still take price from cache.

Lets make an example
1. Disable cache price
2. Create a product with 50$ price
- on productbox and product page is price 50$
3. Change price with SQL Studio

UPDATE [genelec_nop].[dbo].[Product] SET [price]=60 WHERE [sku]=41942

4. Refresh page
- catalog price change from 50$ to 60$ bit on product page is still 50$
5. When i go to buy product from catalog or from product page, in cart is still 50$ price.

I found this routine ClearCache(Product entity)
in nopCommerce_4.30\Libraries\Nop.Services\Catalog\Caching\ProductCacheEventConsumer.cs
Maybe that will do it ?

Yidna wrote:

af1racing wrote:

af1racing gave me the same advice but same thing is happening again.

go to \Libraries\Nop.Services\Catalog\ProductService.cs
find GetProductById methods na dreplace with blow code:

  public virtual Product GetProductById(int productId)
        {
            if (productId == 0)
                return null;
            if (_catalogSettings.CacheProductPrices)
                return _productRepository.ToCachedGetById(productId);
            else
                return _productRepository.GetById(productId);
        }