MDVA-11189: cataloginventory_stock rows deleted post CSV import

Last update: 2023-08-21
  • 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.

On this page