I tend not to spend long in food shops with kids and tend to give then something to hold onto eg a squeeze yougurt or ginger bread man. Have never let them open until payed for.

I don't tend to have kids eat in shops as dont want them making a mess (actual butchers not in supermarket does give kids a mini frankfurt).