“As for Shapiro; my understanding is that it comes from Speyer; one of the original 3 cities along the Rhineland in Germany during the time of Rash”i and Tosafot. That might explain why there are Shapiros who are Cohanim and Yisroelim. (I haven’t met Leviim with that last name).”
I know a prominent Shapiro family and they say that the name does not come from Speyer but from the Aramaic Shufrayah (meaning beautiful). There are also Sephardic Shapiros so I would have to concur that it can’t be from Germany.