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

Last update: November 7, 2024

CREATED FOR:

  • Experienced
  • Admin
  • Developer

The ACSD-59036 patch fixes the issue where an exception occurs when loading product prices with both lower and upper bounds set to $0. This patch is available when the Quality Patches Tool (QPT) 1.1.50 is installed. The patch ID is ACSD-59036. Please note that this issue is scheduled to be fixed in Adobe Commerce 2.4.8.

Affected products and versions

The patch is created for Adobe Commerce version:

Adobe Commerce (all deployment methods) 2.4.7

Compatible with Adobe Commerce versions:

Adobe Commerce (all deployment methods) 2.4.7 - 2.4.7-p2

NOTE
The patch might become applicable to other versions with new Quality Patches Tool releases. To check if the patch is compatible with your Adobe Commerce version, update the magento/quality-patches package to the latest version and check the compatibility on the Quality Patches Tool: Search for patches page. Use the patch ID as a search keyword to locate the patch.

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.
  2. Assign all 13 products to a category.
  3. Set the price of one product to $1322.94.
  4. Set the price of all other products to $0.
  5. Configure OpenSearch as a search engine.
  6. Go to Stores > Configuration > Catalog > Storefront and set the PLP count to 16.
  7. Set Price Navigation Step Calculation to Automatic (equalize product counts).
  8. Run full reindex.
  9. Open the Category page.

Expected results:

The Category page displays all the products.

Actual results:

An error occurs:

report.CRITICAL: OpenSearch\Common\Exceptions\BadRequest400Exception: {"error":{"root_cause":[{"type":"x_content_parse_exception","reason":"[1:193] [bool] failed to parse field [must]"}],"type":"x_content_parse_exception","reason":"[1:193] [bool] failed to parse field [filter]","caused_by":{"type":"x_content_parse_exception","reason":"[1:193] [bool] failed to parse field [must]","caused_by":{"type":"illegal_argument_exception","reason":"field name is null or empty"}}},"status":400} in /vendor/opensearch-project/opensearch-php/src/OpenSearch/Connections/Connection.php:664