I think it's probably not a deterrent to some crimes, but a deterrent to others. Probably there are lots of people who don't shoplift, e.g., out of fear of the consequences of getting caught. (Obviously there are plenty who would not steal regardless; and plenty who steal anyway). Most studies I've seen on deterrence focus on the most serious crimes like murder and rape.