What is Dopey shit?

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!

Dopey shit - video