Checked the possible causes discussed with Nate, as per checking, all the store from blue yonder is not stored in MySQL, this will be discussed with sir Frits if the store will be added to MySQL or extract the inventory count of the store stored in MySQL only.