In general, it means someone (can be both male and female) who is neither rich nor with high social level, and usually ordinary-looking.
But sometimes, the use of this word is extended to indicate the low-end products. For example, a Coles homebrand smartbuy cake can be described as "屌丝蛋糕".....