Recently I upgrated magento to 2.4.2 and now I’m facing a problem with the Price Range filter by Mageplaza Layered Navigation.
I have managed to solve a previous problem of the price slider not appearing at all, but now there is another problem related to the product prices.
The filter displays only 0,00 – 0,00 as price range and when I use the slider to select a price range, the filtering ajax runs but it returns no results.
All the products are configurable with prices set to their configurations (which are simple products).
Searching for the cause of the error, I noticed that, in the rows about the configurable products, the columns price, min_price, max_price and price_tier of the catalog_product_index_price table are set to 0.0000. All the other sipmle products have correct values. I tried changing manually the values of a configurable product and althought the price range displayed a max price (the one I set in tye configurable product), the filtering did not return any products.
So far I have tried
- Reindexing and clearing the cache
- Adding a product from the begining
- Checking the tables related to store configuration
- Increasing the innodb_buffer_pool_size and decreasing the batch size
- Changed the settings for the Layered Nag=vigatiuon Filter in Stores -> Configuration
So far nothing has worked.
Any ideas what could cause this problem or how it could be fixed?
Thank you in advance.