A loser who does something so stupid, that they are referred to as "dopey" and the "shit" is just added to imply the obvious.
I saw some lad trip over his own feet at the community match yesterday... it was Alan, the dopey shit!