I don't know why they translated it as "I want those sweeties!", though, bonbons is usually translated to candies. Or, better, "I want that candy!" Unless I'm reading the font wrong? Kids don't really say sweets, either. </picky>
I have carried one of my kids kicking and screaming out of the grocery store and other places before. Fortunately those phases never lasted long once they realized they were going to be sitting in a chair getting NOTHING for a while as a result.
I think that would be an example of when to abandon the cart, take the kid to the car and sit there until they are either quiet for x minutes or just go home. I remember one of the first shower gifts I ever gave someone was a set of earplugs and a bottle of aspirin. For exactly these moments.
That's a great ad, but I doubt it would go over well in the US. People would say it was, "Anti-child" and offensive.