DocumentationCommerceCommerce KB

MDVA-11189: cataloginventory_stock rows deleted post CSV import

Last update: Mon Aug 21 2023 00:00:00 GMT+0000 (Coordinated Universal Time)

CREATED FOR:

  • Admin

The MDVA-11189 Adobe Commerce patch fixes the issue when after importing a .csv file to update product stock, rows from the cataloginventory_stock table are deleted. This patch is available when the Quality Patches Tool (QPT) 1.0.20 is installed. The patch ID is MDVA-1189. Please note that the issue was fixed in Adobe Commerce 2.3.5.

Affected products and versions

The patch is created for Adobe Commerce version: Adobe Commerce on cloud infrastructure 2.2.3

Compatible with Adobe Commerce versions: Adobe Commerce (all deployment methods) 2.3.0-2.3.4-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

Fixes the issue when after importing a .csv to update product stock, rows from the cataloginventory_stock table are deleted.

Steps to reproduce:

  1. In the database run the following MySQL command: select count(*) from cataloginventory_stock_status;

  2. Note the number of rows.

  3. Set the crontab as follows: * * * * * /usr/bin/php <path to installation>/bin/magento cron:run | grep -v "Ran jobs by schedule" >> <path to installation>/var/log/cron.log 2>&1

  4. Go to the Admin panel in System > Tools > Index Management.

  5. Set indexers to Update By Schedule.

  6. Go to System > Data Transfer > Export.

  7. Set Entity Type equal to Products > Continue.

  8. Open the saved .csv file > Remove all columns except for SKU and QTY.

  9. Update the quantity for all products to 150.

  10. Save the .csv file.

  11. Go to System > Data Transfer > Import .

  12. Set the following values:

    1. Entity Type: Products
    2. Import Behavior: Add/Update
    3. Leave all other values at default.
    4. Choose File to select the catalog product spreadsheet.

  13. Click Check Data > Import. Allow 5-10 minutes to pass.

  14. In the database run the following MySQL command:
    select count(*) from cataloginventory_stock_status;

Actual result:

The number of rows in cataloginventory_stock is decreased after the CSV import to update the stock.

Expected result:

The number of rows in cataloginventory_stock should remain the same after the CSV import to update the stock.

Apply the patch

To apply individual patches, use the following links depending on your deployment method:

To learn more about Quality Patches Tool, refer to:

For info about other patches available in QPT, refer to Patches available in QPT in our developer documentation.

recommendation-more-help
8bd06ef0-b3d5-4137-b74e-d7b00485808a