It happens ALL the time...for mainly PlayStation of all platforms. No one seems to care about the gap between shipped vs sold when it comes to Nintendo. Even with PS5 being sold out it can take several weeks for consoles to ship from the manufacture to retailers. So there is the gap.
I guess saying that is easier than just admit this is all speculation and no need to figure out when or where the errors occurred. Since theres almost no more reliable data anymore and your guesses where only based on how many Sony projected to sell.
It takes genuine talent to see greatness in yourself despite your absence of genuine talent.