it depends upon how it was used in a sentence, or how the speaker say it, and how you react on it. it is an expression (you little shit) and could mean a lot (negative or positive). In your case, it might mean "stupid" if the speaker sounded a little bit disappointed, or "great" if they sounded surprised.

it means where your a kid and people call you that when you made them really mad.