Will this work with Sherwin-Williams Woodscape Solid Stain?

The Opti-Stain Plus sprays transparent, semi-transparent and some solid stains. We can't speak to this specific stain, but in general, if you use a mixer in a drill to stir thicker material before you put it in the gun, it will spray better.