PSA: Work orders with specific materials
On the off chance that somebody doesn't know:
At least in the Steam version, you can specify the exact material to use for a work order by clicking in the magnifier symbol (e.g. "build 20 obsidian thrones").
Here I was, linking stockpiles like crazy for the longest time, and the answer is so simple!
My mind is blown ...