Closed
Description
I have some products(lets say 30 with different prices), which have tax of 20%. I configure to show the product price including tax. On search when I used to sort by "Price" the product is not sorted as the price.
Preconditions
- Magento 2.1.6
- MySQL 7.0.18
- Nginx
Steps to reproduce
- Import the 30 products with tax and name of the products have some similar words. I have 9000 products.
- Not configure the tax for the imported tax class for the products.
- Search for the products.
- Used to Sort the result by "Price". Sorting works fine.
- Go to the following path Store -> Configuration -> SALES -> Tax -> Price Display Settings -> Display Product Prices in Catalog and select the option Including Tax
- Flush the cache.
- Now repeat step number 3 and 4. Now the result is not sorted by Price.
Expected result
- Result must be in the sorted order by Price.
Actual result
- Results aren't showing in the sorted order by Price.