My opinion on this (and the basis for my opinion are as follows:
Low Viscosity = 0 - 500 SSU (~100 cps)
Most Centrifugal pumps start to have serious degredation of Flow, Head, and efficiency over 500 SSU. The rule of thumb is over 500 SSU = don't use a centrifugal pump. Now before I get people started, I know that you can use a centrifugal pup at higher viscosities it is just not typically practical.
Medium Viscosity = 500 - 20000 SSU (~100 - 4300 cps)
This viscosity range is outside of typical centrifugal applications but can be moved by most all positive displacement pumps. ie. Gear, Piston, Diaphragm, Screw, etc.
High Viscosity = >20,000 SSU (>4300 cps)
At these thicknesses if you have a glass full of the liquid and you turn the glass sideways you have to wait for the liquid to start pouring out.

Here special consideration must be taken with the pump. Make sure the pump is large enough and running slow enough that it takes a bite of the fluid. For example, a gear pump may appear appropriate but when running the gear teeth just push the fluid back instead of taking a bite out of the liquid. Valves in piston & diaphragm pumps need additional time to seat before pump reverses it's stroke. Pumps will need to be oversized, slowed down and/or specialty pumps such as Progressing cavity or peristaltic pumps may be required.
2,000,000 cps is the highest pumpable viscosity that I have ever seen a pump rated for. That's about the viscosity of chunky peanut butter. Anything thicker than that.... get a shovel.
Hope this helps.
ThePumpGuru