MDVA-37592: Sorting by price does not work correctly for products with price zero assigned…
Sorting by price does not work correctly for products with price zero assigned to a shared catalog. Quality patch MDVA-37592 for magento/module-catalog applies to Magento Open Source and Adobe Commerce 2.3.6 to 2.4.3-p3.
- Categories
- Catalog/Product
- Components
- magento/module-catalog, magento/module-elasticsearch
- Origin
- adobe-commerce-support
- Since QPT
- 1.1.0
Issue
Sorting by price does not work correctly for products with price zero assigned to a shared catalog.
Steps to reproduce
1. Enable shared catalog. 1. Create four products with the following prices and assign them to a category - $50, $60, $70, and $80. 1. Create a shared catalog with the above products. 1. Set the custom price to zero for the product with a price of $70. 1. Now create a company user and assign it to the shared catalog just created. 1. Log in using the company account and browse to the category where the products are assigned to. 1. Try to sort by price.
Adobe's page lists 2.3.6-2.4.2-p1 as compatible; the versions below are resolved from the current QPT constraints and are the ones the tool will offer.
Adobe scheduled the permanent fix for 2.4.4.
Install
Install the Quality Patches Tool with composer require magento/quality-patches, apply the prerequisites listed for all files applicable to your distribution and version first, then run vendor/bin/magento-patches apply MDVA-37592. On Cloud, add MDVA-37592 under stage.build.QUALITY_PATCHES in .magento.env.yaml.
For cweagans/composer-patches, choose a compatible version below and download the bundle. Copy its MDVA-37592/ folder into patches/composer/, merge composer.patches.json into composer.json, then run composer install. Bundle prerequisites the same way and list them first. Paths are relative to each package root, using the default -p1 level. Prefer local files when configuring composer-patches; a remote URL can change.
Patch files and compatible versions
magento/magento2-base >=2.3.6 <2.4.4
- Magento Open Source
- 2.4.3-p3, 2.4.3-p2, 2.4.3-p1, 2.4.3, 2.4.2-p2, 2.4.2-p1, 2.4.2, 2.4.1-p1, 2.4.1, 2.4.0-p1, 2.4.0, 2.3.7-p4, 2.3.7-p3, 2.3.7-p2, 2.3.7-p1, 2.3.7, 2.3.6-p1, 2.3.6
- Adobe Commerce
- 2.4.3-p3, 2.4.3-p2, 2.4.3-p1, 2.4.3, 2.4.2-p2, 2.4.2-p1, 2.4.2, 2.4.1-p1, 2.4.1, 2.4.0-p1, 2.4.0, 2.3.7-p4, 2.3.7-p3, 2.3.7-p2, 2.3.7-p1, 2.3.7, 2.3.6-p1, 2.3.6
- Patch file
- patches/os/MDVA-37592_2.4.0-p1.patch
- vendor/magento/module-catalog/Model/ResourceModel/Product/Collection.php
- vendor/magento/module-catalog/Model/ResourceModel/Product/Indexer/Price/Query/BaseFinalPrice.php
- vendor/magento/module-elasticsearch/Model/ResourceModel/Fulltext/Collection/SearchResultApplier.php
