There were three teams. The store architects, the space planners, and the people that actually stocked the shelves (the MET team). They all had data sources that were supposed to represent what the shelves in the store looked like, but rarely did the people designing shelves and stores have the right information. This problem lead to huge losses - the company had no idea where over $90 million worth of merchandise was.
My team was asked to help align the Space Experience databases with what was true of the in-store conditions. Here is how we did it.