Tell us about yourself!
might be a bit late for an answer but canned polyurethane foam works nicely. just fill the whole left space in the ball and leave it outside for a day, the liquid foam will expand and solidfy both setting the sand in one part of the ball and sealing the funnel entrance. cut the excess oozed and solidified foam from the ball and use. :)