I'm lucky to have a walk-in closet in my sewing room and DH added shelves to the back wall. For fabric pieces more than a yard or two, I fold them on a 5x24 ruler then fold in half and store together on a shelf. Pieces smaller than that but bigger than a FQ I wrap around those cardboard comic book board things and stand them like little bolts on the shelf. Just these two things have been very helpful in seeing what I have and a general idea of how much there is. Generally arranged by theme and/or color.
FQ's are still stored in plastic shoe boxes, but I'm looking for a better way to stack them on a shelf so I can see them.
Anita