Front End to Debug Stock Issues

[timpea]

Description (*)

Some kind of front end to the Inventory_reservation table, that shows issues. e.g. reservations where the sum of the qty is positive & reservations that don't have an order in the sales_order table.

Expected behavior (*)

Page in the Magento admin to show all the current rows in the inventory_reservation, the ability to click on each one to be taken to the related order.

The ability to remove incorrect rows from the inventory_reservation table.

Another part of the page to flag up issues, if things don't add up correctly.

Benefits

Easy way to fix Inventory_reservation problems without having to use SQL.

Additional information

We had some issues with the import from Magento 1 to Magento 2, orders that were created in Magento 1 then shipped in Magento 2, the inventory_reservation didn't work as expected. We had to delete the rows from inventory_reservation to sort.

We have also had a problem with a PayPal order, something went wrong, the payment failed but we ended up with records in the inventory_reservation table that didn't have a related order is sales_order table.

Please ignore the bad SQL, but this is what we have been using to find the issues in the table: Find reservations where reservations are positive: SELECT sku, sum(quantity) FROM inventory_reservation GROUP by sku having sum(quantity)>0

Find reservations where reservations don’t have a matching order:

SELECT res_orderid
FROM sales_order
RIGHT JOIN
(SELECT DISTINCT(SUBSTRING(metadata, POSITION("object_increment_id" IN metadata)+22, LENGTH(metadata)-POSITION("object_increment_id" IN metadata)-23)) AS res_orderid FROM inventory_reservation) b
ON b.res_orderid = sales_order.increment_id
WHERE sales_order.increment_id IS NULL

[m2-assistant[bot]]

Hi @timpea. Thank you for your report. To help us process this issue please make sure that you provided sufficient information.

Please, add a comment to assign the issue: @magento I am working on this

---

• Join Magento Community Engineering Slack and ask your questions in #github channel.

[maghamed]

@magento give me 2.4-develop instance

[magento-deployment-service[bot]]

Hi @maghamed. Thank you for your request. I'm working on Magento instance for you.

[magento-deployment-service[bot]]

Hi @maghamed, unfortunately there is no ability to deploy Magento instance at the moment. Please try again later.

[maghamed]

@magento give me 2.4-develop instance

[magento-deployment-service[bot]]

Hi @maghamed. Thank you for your request. I'm working on Magento instance for you.

[magento-deployment-service[bot]]

Hi @maghamed, unfortunately there is no ability to deploy Magento instance at the moment. Please try again later.

[timpea]

Another issue that needs a way to solve without directly fixing it in the DB.

Place a pending order for a product. (SKU: A) Open the product and change the sku (SKU change from A to B) Cancel the pending order (SKU: A) Re-create order with the new sku. (SKU: B)

In inventory_reservation: -1 for A (new order for A) +1 for B. (when cancelling pending order for A, it puts B back in stock) -1 for B (new order for B)