New answers tagged

0 votes

Magento 2 - How to find all products with Salable qty as 0 via SQL query?

Updated Query: SELECT t1.sku, SUM(t1.quantity) Qty, COALESCE(SUM(t2.quantity), 0) Reserved, (SUM(t1.quantity) + COALESCE(SUM(t2.quantity), 0)) AS Salable FROM ...
Fabio B.'s user avatar
0 votes

When creating an order via api, the salable quantity does not decrease

After creating an order, a reservation of this product is made. This is MSI functionality. Read more at Only when the order is (paid and) ...
JKıngma's user avatar

Top 50 recent answers are included