Can also happen that the system is tracking correctly based on transactions, but when the picker gets there they find the item is damaged and therefore unsaleable, or wrong stock has been put in the location, or not there due to theft etc. very annoying though.

I work in retail and this stuff happens. No stock system if fool proof. It’s most likely because they were down to one left and someone else purchased it a fraction before you finalised your order.