Magento2 MSI How can we set 1 source to ship from, but not to sale from?

Question

Magento2 MSI How can we set 1 source to ship from, but not to sale from?

We currently use backorders. Sales are made from stock sources and backorders (min_qty).

Suppose

• Local stock 2
• Incoming stock 0
• Backorder Min Qty -1
• Customer orders 3 utilizing stock and all backorders

This order cannot be shipped because it needs 3 but only has access to 2.

The backorder is then processed and backordered at the suppliers. Then stock is received and scanned and updates the INC Incoming source with +1. We then go to shipment

The only problem here is that when Incoming stock is scanned and updated to +1 that the salable qty is adjusted and that a customer can order this item in he frontend. So as a result : you would want to have a source that does not affect the salable qty, but is however available for shipping in the backend.

Question: how can we setup a source that can be used as a source for shipping but ont for sale?

Answer 1

As you may know, a stock salable quantity equals the sum of all stock source quantities minus reserved quantity and minus min quantity (Out-of-Stock Threshold). See

\Magento\InventorySales\Model\GetProductSalableQty::execute

The most logical way to solve the problem is to reserve all "Incoming stock" (INC source) items. Once INC source quantity is changed for some SKU, an appropriate reservation must be created/updated. See inventory_reservation table. Your reservation metadata can be {"event_type":"incoming_source_qty_updated","object_type":"product","object_id":"1"}

Reference \Magento\InventorySales\Model\PlaceReservationsForSalesEvent::execute as an example of how reservation can be created.

Answer 2

I am wondering whether you can't make the "stock status" for that product for that source to be "not in stock" temporarily - that should mean the stock is not available to sell, even though it exists.

As in - when a shipment has arrived and is put into your stock, put the stock status for the new arrived products in that stock source to 0.

Process the pending orders

When done, change the status for those products for that source to 1

Only then will they be available on the site.

This should buy you the breathing space you want.