ACSD-62971: Stock sources import with non-numeric quantity values results in the quantity being set to 0
The ACSD-62971 patch fixes the issue where importing stock sources with non-numeric values in the ‘quantity’ column results in the quantity being set to 0. This patch is available when the Quality Patches Tool (QPT) 1.1.56 is installed. The patch ID is ACSD-62971. Please note that the issue was 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.4 - 2.4.7-p3
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
Fixes the issue where importing stock sources with non-numeric values in the Quantity column results in the quantity being set to 0.
Steps to reproduce:
-
Create Simple Product with qty=100
-
Do a Stock Sources import using the file which has an incorrect quantity (“abc”)
code language-table source_code sku status quantity default simple 1 abc -
Check the quantity after the import.
Expected results:
The import data validation should fail.
Actual results:
The quantity of simple product has become 0, and the product is updated as Out of Stock.
Apply the patch
To apply individual patches, use the following links depending on your deployment method:
- Adobe Commerce or Magento Open Source on-premises: Quality Patches Tool > Usage in the Quality Patches Tool guide.
- Adobe Commerce on cloud infrastructure: Upgrades and Patches > Apply Patches in the Commerce on Cloud Infrastructure guide.
Related reading
To learn more about Quality Patches Tool, refer to:
- Quality Patches Tool: A self-service tool for quality patches in the Tools guide.