We’re looking for a report that will list our inventory item quantities. The number available for sale AND the number on hold for customers. The number shown in the Magento Admin only shows the number available which makes doing a physical inventory very difficult if we have pending orders (not yet paid or not yet shipped).
Product SKU Product Name Qty Available Qty on Hold Total on Shelf
Then we can run the report in real time to do physical inventory. Ideally we’d be able to run this in SKU order for a range of SKU’s
Anyone know of a report/add-on/module that does this?