DEV Community

Magevanta
Magevanta

Posted on • Originally published at magevanta.com

Magento 2 MSI Performance Optimization: Taming Multi-Source Inventory

#magento #php #performance #ecommerce

Multi-Source Inventory (MSI) arrived in Magento 2.3 as a major architectural overhaul of stock management. For merchants running multiple warehouses, it's genuinely powerful. For the other 80% — single-warehouse stores that just want fast page loads and quick checkout — it's often an unexpected performance drag that's hard to diagnose and even harder to fix.

This guide walks through exactly what MSI does under the hood, where the bottlenecks hide, and what you can do about them today.

What MSI Actually Does (and Why It's Slow)

Before MSI, Magento's inventory system was a flat, denormalized structure. Stock was stored in cataloginventory_stock_item, and a simple JOIN during product listing was all that was needed to determine salability.

MSI replaced this with a normalized, extensible model:

  • inventory_source — physical locations
  • inventory_source_item — stock per SKU per source
  • inventory_stock — named stock pools
  • inventory_stock_sales_channel — maps stocks to websites/stores
  • inventory_reservation — deferred (eventual consistency) deductions during checkout

The genius of this design is its flexibility. The performance cost is that every salability check now requires resolving a chain of tables — source → stock → reservation — often via PHP-layer aggregation, not a single SQL query.

The IsSalableConditionInterface plugin chain and the GetProductSalableQty service are called on virtually every product load in catalog listing, cart, checkout, and order placement. In a store with thousands of SKUs and a busy queue, this adds up fast.

Diagnosing MSI Overhead

Before optimizing blindly, measure. These are the usual suspects:

1. Slow Category Pages

Enable the Magento profiler (MAGE_PROFILER=html php bin/magento ...) or use New Relic / Blackfire and look for repeated calls to:

Magento\InventorySalesAdminUi\Model\...
Magento\InventoryCatalog\Plugin\...
Magento\InventoryIndexer\...
Enter fullscreen mode Exit fullscreen mode

If you see these appearing hundreds of times per page request, MSI is your bottleneck.

2. Slow Checkout / Add-to-Cart

The reservation mechanism writes to inventory_reservation on every cart add and order placement. On high-traffic stores, this table grows rapidly and the compensating cron (inventory_cleanup_reservations) may lag behind.

Check table size:

SELECT COUNT(*) FROM inventory_reservation;
SELECT COUNT(*) FROM inventory_stock_1; -- adjust stock ID
Enter fullscreen mode Exit fullscreen mode

Tables with millions of rows indicate the cleanup cron is not keeping up.

3. Reindex Times

MSI adds several new indexers:

bin/magento indexer:status | grep inventory
Enter fullscreen mode Exit fullscreen mode

inventory_stock reindex can be very slow on large catalogs — especially if it runs in "Update on Save" mode during peak hours.

Optimization Strategy 1: Switch to Single-Source Mode Correctly

If you're a single-warehouse merchant, MSI is solving problems you don't have. However, you cannot simply disable the MSI modules — they are deeply integrated into Magento's sales flow since 2.3.

What you can do is configure MSI to behave like the old single-stock system:

  1. Use the Default Source and Default Stock only. Never create additional sources or stocks.
  2. Set all products to the Default Source. If you imported products incorrectly, run: 
bin/magento inventory:source-items:export-stock-to-default-source
Enter fullscreen mode Exit fullscreen mode

  1. Unassign unused sources. In Admin → Stores → Sources, disable all non-default sources so Magento skips multi-source resolution logic.

  2. Ensure inventory_stock_sales_channel maps only the Default Stock to your website. Mismatches here cause fallback resolution paths that are significantly slower.

With a clean single-source setup, MSI's internal resolvers hit fast code paths that are barely slower than the old system.

Optimization Strategy 2: Indexer Tuning

Switch to "Update by Schedule"

Real-time (Update on Save) inventory reindex is a common culprit for frontend slowdowns during product edits or imports.

bin/magento indexer:set-mode schedule inventory_stock
Enter fullscreen mode Exit fullscreen mode

This moves reindexing to cron, keeping the frontend responsive.

Run Inventory Indexers on Cron Properly

Magento's default cron group for MSI indexers is index. Verify it's running:

bin/magento cron:status
Enter fullscreen mode Exit fullscreen mode

For high-volume stores, consider running the inventory indexers on a dedicated cron group with a tighter schedule during off-peak hours.

Partial Reindex After Imports

When you import products in bulk, avoid a full inventory_stock reindex if possible. Use Magento's partial reindex:

bin/magento indexer:reindex inventory_stock
Enter fullscreen mode Exit fullscreen mode

For very large catalogs, use --no-interaction with a time limit and offset if you've implemented chunked reindex via a custom CLI command.

Optimization Strategy 3: Reservation Table Maintenance

The inventory_reservation table uses an append-only model. Magento only cleans it via compensating cron jobs (inventory.reservations.cleanup and inventory.reservations.updateSalabilityStatus).

If these lag, the table balloons and reservation resolution becomes slow.

Check and Force Cleanup 

bin/magento inventory:reservations:cleanup
Enter fullscreen mode Exit fullscreen mode

For stores processing thousands of orders per day, schedule this to run every 15 minutes instead of the default hourly.

In crontab.xml of a custom module:

<job name="inventory_cleanup_reservations_frequent" instance="Magento\InventoryIndexer\Cron\ReindexAfterReservationsPlaced" method="execute">
    <schedule>*/15 * * * *</schedule>
</job>
Enter fullscreen mode Exit fullscreen mode

Also run the compensating reservation update more frequently if you see salability showing stale (e.g., item still shows in stock 10 minutes after the last unit sold):

bin/magento inventory:salability:reindex
Enter fullscreen mode Exit fullscreen mode

Archive Old Reservations

For stores that have been running MSI for years without cleanup, a one-time purge of fully compensated reservations is safe:

-- Safe: removes reservations where the net quantity per SKU/stock is zero
-- Run this only after verifying with a SELECT first
DELETE r1 FROM inventory_reservation r1
INNER JOIN (
    SELECT sku, stock_id
    FROM inventory_reservation
    GROUP BY sku, stock_id
    HAVING SUM(quantity) = 0
) r2 ON r1.sku = r2.sku AND r1.stock_id = r2.stock_id;
Enter fullscreen mode Exit fullscreen mode

⚠️ Always run on a staging environment first and take a backup. This is a data mutation.

Optimization Strategy 4: Salability Check Caching

MSI's GetProductSalableQty and IsSalable services are called per-product. On a category page with 48 products, that's 48 individual salability resolutions — each potentially involving multiple DB queries.

Magento 2.4.4+ introduced a built-in result cache for salability checks. Ensure it's enabled by checking your DI configuration:

grep -r "IsSalableConditionInterface" vendor/magento/module-inventory-sales/etc/
Enter fullscreen mode Exit fullscreen mode

If you're on an older version, you can implement a simple proxy cache using Magento's cache framework:

// In a plugin for GetProductSalableQtyInterface
public function aroundExecute(
    GetProductSalableQtyInterface $subject,
    callable $proceed,
    string $sku,
    int $stockId
): float {
    $cacheKey = 'msi_salable_qty_' . $sku . '_' . $stockId;
    if ($cached = $this->cache->load($cacheKey)) {
        return (float) $cached;
    }
    $result = $proceed($sku, $stockId);
    $this->cache->save((string) $result, $cacheKey, [], 30); // 30s TTL
    return $result;
}
Enter fullscreen mode Exit fullscreen mode

Use with care on high-velocity SKUs — a 30-second stale quantity is usually acceptable for catalog display but not for final checkout reservation.

Optimization Strategy 5: Disable MSI for Non-Salable Product Types

Configurable products trigger MSI salability checks for every child product to determine if the parent is in stock. For configurables with dozens of variants, this cascades badly.

Magento provides the InventoryConfigurableProduct module specifically to aggregate child stock for configurable parents. Ensure this module is enabled:

bin/magento module:status Magento_InventoryConfigurableProduct
Enter fullscreen mode Exit fullscreen mode

If it's disabled (sometimes happens after partial module disablement attempts), re-enable it:

bin/magento module:enable Magento_InventoryConfigurableProduct
bin/magento setup:upgrade
Enter fullscreen mode Exit fullscreen mode

Monitoring MSI in Production

Set up these dashboards to catch MSI degradation before users notice:

New Relic / Datadog custom metrics:

  • inventory_reservation row count (alert > 500k)
  • Time spent in Magento\InventorySales\Model\IsProductSalableForRequestedQtyCondition
  • Cron job duration for inventory_cleanup_reservations

MySQL slow query log: Filter for queries against inventory_reservation, inventory_source_item, and inventory_stock_* that exceed 100ms.

Magento logs: Watch var/log/system.log for Could not resolve salability or reservation consistency warnings.

When Nothing Else Works: Third-Party MSI Alternatives

For stores with extreme inventory complexity (tens of thousands of SKUs, multiple warehouses, real-time 3PL sync), native MSI may genuinely not scale to your needs. Some merchants have had success with:

  • Linnworks or SkuVault with a Magento connector that bypasses MSI entirely and writes directly to the legacy cataloginventory_stock_item table
  • Custom Magento_InventoryCatalog preference that replaces the salability check with a direct single-table lookup for single-source setups

The latter approach (essentially shunting around MSI's resolution chain while keeping the module structure intact for compatibility) is the most maintainable path if you need single-source speed with MSI's API compatibility.

Summary

MSI is not inherently slow — it's complex, and complexity has a cost. The optimization playbook:

Problem Fix
Slow category pages Single-source cleanup + salability caching
Slow checkout / cart Reservation table maintenance + frequent cleanup cron
Slow reindex Switch to schedule mode + partial reindex on imports
Stale stock display Run inventory:salability:reindex more frequently
General MSI overhead Ensure InventoryConfigurableProduct is enabled

Start with the reservation table — it's the most common and most impactful quick win. Then profile to find your specific bottleneck before diving into deeper changes.

Got a specific MSI issue that isn't covered here? Drop a comment or reach out — real-world MSI war stories are always educational.

Top comments (0)