What is the origin of the idiom "like a kid in a candy store" and when to use it?

The origin of the phrase "like a kid in a candy store" can be traced back to the early 20th century in the United States. It emerged from the observation of children's behavior when they enter a candy store, where they are often overwhelmed by the abundance of sweets and treats available. This idiom finds its place in conversations, written expressions, and storytelling when referring to scenarios such as shopping sprees with a vast selection of desirable items, career opportunities with numerous enticing prospects, or events with an abundance of enjoyable activities. It can also be used to describe a state of intense fascination and eagerness in any situation where someone is exposed to a plethora of appealing possibilities.