QUALITY PATCH

ACSD-69325: When the SKU is modified to include lowercase letters, the product incorrectly appears…

When the SKU is modified to include lowercase letters, the product incorrectly appears as out of stock on the storefront. Quality patch ACSD-69325 for magento/module-inventory-indexer applies to Magento Open Source and Adobe Commerce 2.4.7 to 2.4.8-p5.

Categories: Catalog/Product, Inventory
Components: magento/module-inventory-indexer
Origin: adobe-commerce-support
Since QPT: 1.1.76

Issue

When the SKU is modified to include lowercase letters, the product incorrectly appears as out of stock on the storefront.

Steps to reproduce

1. Log in to the Admin panel. 1. Create an additional website, store, and store view by navigating to Stores > All Stores. 1. Create a sales channel for the new website by navigating to Channels > Sales Channels. 1. Create a product assigned to the new website with SKU = RF-42R-80X100-CL, and assign it to the sales channel. 1. Run the indexers by executing php bin/magento indexer:reindex and ensure scheduled tasks (cron) are running. 1. Open the product page on the storefront. 1. Verify that product is In Stock. 1. Update the SKU to RF-42R-80x100-CL (using a lowercase x). 1. Run the indexers by executing php bin/magento indexer:reindex and ensure scheduled tasks (cron) are running. 1. Open the product page on the storefront. 1. Verify the product stock status.

Adobe's page lists 2.4.7 - 2.4.8-p3 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.9.

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-69325. On Cloud, add ACSD-69325 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-69325/ 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/inventory-metapackage >=1.2.7 <1.2.9

Magento Open Source: 2.4.8-p5, 2.4.8-p4, 2.4.8-p3, 2.4.8-p2, 2.4.8-p1, 2.4.8, 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.8-p5, 2.4.8-p4, 2.4.8-p3, 2.4.8-p2, 2.4.8-p1, 2.4.8, 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-69325_1.2.8-p3.patch

vendor/magento/module-inventory-indexer/Model/ResourceModel/GetStockItemsData.php