In the process of trying to find her and perhaps spending the night at other women's places he has tried out various shampoos found in their showers - thus the "in search of the perfect shampoo." The perfect shampoo he alludes to finally finding I believe is his current wife Claudia.
This song is a clever metaphor regarding looking for the right (perfect?) woman.