Has anyone else experienced issues with their inventory numbers being off using Magento?
I am on version 1.6.2, and lately we have noticed our inventory counts are off. I’ve been verifying by hand over the last couple of days, and our inventory in Magento is a few units above what we actually sold during that period.
For example over the last two days, Magento is reporting that we sold 462 units. I got this number by first running a Magento Products Ordered report. I then verified this by totaling every order for this product over the last 2 days by hand, and the numbers matched. We actually sold and shipped 462 items.
However, our inventory in Magento does not reflect this. I ran a database query on our current inventory, and compared it to a starting inventory number 2 days ago. The starting inventory came from a DB backup that ran at 1am, and there were no products ordered until the next morning.
When comparing our starting inventory, to the current inventory the difference was 461. That means there was one extra unit in our inventory that shouldn’t have been there since we actually sold 462. Keep in mind these are not real life inventory numbers I’m counting in our back room, these are conflicting numbers I’m getting through the system itself.
As I’ve continued to look at this, there are discrepancies across a number of products.These have been limited to a 1 or 2 unit difference, but over the course of only a few days. I have no idea how for long this has been going on.
Has anyone else seen anything like this in their own systems?