The thing with the water is that, in my experience, it gets asked for in a pull nearly every hour anyway, especially if it's on ad. The system would ask for anywhere from 3 to 10 waters on any given hour; this is annoying and unproductive seeing as we have 24 feet of it out there. A couple missing here and there aren't going to bother anyone. Instead, we key the amount that the system asks for every hour but don't actually send any out. The entire pallet gets sent out to the floor once before open, and once around 5 o'clock to keep the floor full without having to constantly put water on with the rest of the grocery pulls. If it's on a pretty big sale or on a bulk endcap in grocery, the pallet will go out more often. Then it can also be rolled up to the cartwell if there's a loc for it there.
Once we either have no pallets of water in the backroom or it goes off of promotional pricing, we can do a quick SUBT-9999 to fix any jacked up accumulator values (after the floor has been filled to capacity, of course). And truthfully, this isn't even necessary since we send the pallet out in the morning, and it pulls a large number in the autofills too. We can just key the number (40, for example) and send the pallet out to completely stock the floor. That way the accumulator is evened out and the floor is filled - the endgame every time.
Rinse and repeat the next time it goes on ad.