QUALITY PATCH

ACSD-59036: An exception occurs when loading product prices with both lower and upper bounds set to $0

An exception occurs when loading product prices with both lower and upper bounds set to $0. Quality patch ACSD-59036 for magento/module-elasticsearch applies to Magento Open Source and Adobe Commerce 2.4.7 to 2.4.7-p10.

Categories: Catalog Search
Components: magento/module-elasticsearch
Origin: adobe-commerce-support
Since QPT: 1.1.50

Issue

An exception occurs when loading product prices with both lower and upper bounds set to $0. The issue is occurring because the algorithm does not account for NULL values when loading the query with price ranges. To fix this, we can check if both the lower and upper ranges are NULL, and if they are, assign a value of 0 for both limits. This should prevent any errors from being thrown.

Steps to reproduce

1. Create 13 simple products. 1. Assign all 13 products to a category. 1. Set the price of one product to $1322.94. 1. Set the price of all other products to $0. 1. Configure OpenSearch as a search engine. 1. Go to Stores > Configuration > Catalog > Storefront and set the PLP count to 16. 1. Set Price Navigation Step Calculation to Automatic (equalize product counts). 1. Run full reindex. 1. Open the Category page.

Adobe's page lists 2.4.7 - 2.4.7-p2 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.8.

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 ACSD-59036. On Cloud, add ACSD-59036 under stage.build.QUALITY_PATCHES in .magento.env.yaml.

For cweagans/composer-patches, choose a compatible version below and download the bundle. Copy its ACSD-59036/ 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.4.7 <2.4.8

Magento Open Source: 2.4.7-p10, 2.4.7-p9, 2.4.7-p8, 2.4.7-p7, 2.4.7-p6, 2.4.7-p5, 2.4.7-p4, 2.4.7-p3, 2.4.7-p2, 2.4.7-p1, 2.4.7
Adobe Commerce: 2.4.7-p10, 2.4.7-p9, 2.4.7-p8, 2.4.7-p7, 2.4.7-p6, 2.4.7-p5, 2.4.7-p4, 2.4.7-p3, 2.4.7-p2, 2.4.7-p1, 2.4.7
Patch file: patches/os/ACSD-59036_2.4.7.patch

vendor/magento/module-elasticsearch/ElasticAdapter/SearchAdapter/Aggregation/Interval.php