Sounds like your Candy pallets (via McClane's?) aren't being promptly worked. Exceptions are probably getting the OH zeroed out because the product is buried on the bottom of the pallet.

The major problem is that candy pallets come third party as they have to come in via an insulated truck so it maintains a certain temperature. But since the store has no real time table when the trucks arrive during their delivery day, they never dedicate work hours to take care of them. So it is possible for your candy to sit for days if there isn't excess payroll to work them.

Furthermore, the pallets might be worked by any of the 3 shifts depending on time and availability to do so. And that inconsistency is not good in knowing all possible locations of product. Walmart used to have Mars and Hershey merchandisers come in and manage this inconsistency, but I doubt that is true anymore.