Filter out the SKUs that aren't in the catalog when there is request to save the SKUs inventory. #MSI | Magento 2 / Adobe Commerce

msi-source-item-save-filter-existing-skus.patch

--- a/vendor/magento/module-inventory/Model/ResourceModel/SourceItem/SaveMultiple.php	2025-02-27 15:30:53
+++ b/vendor/magento/module-inventory/Model/ResourceModel/SourceItem/SaveMultiple.php	2025-05-07 13:19:48
@@ -135,6 +135,19 @@
             $stock[] = $sourceItem->getSourceCode();
         }

+        // check if skus are present in catalog_product_entity table
+        // and include into updates only those that are present
+        $existingSkusSelect = $connection->select();
+        $existingSkusSelect->from(
+            $this->resourceConnection->getTableName('catalog_product_entity'),
+            ['sku']
+        );
+        $existingSkusSelect->where(
+            'sku IN (?)', $skus
+        );
+        $skus = $connection->fetchCol($existingSkusSelect);
+        // end of check for existing skus
+
         $storedSourceItems = $connection->fetchAll(
             $connection->select()
                 ->from($tableName, ['source_item_id', 'source_code', 'sku'])