Here you can select any item or category, and another item or category, and it will tell you what chain of recipes to use to get from one to another. Note that this ONLY includes item types that can carry all traits, so it doesn’t include useable items, weapons, etc. Exploration items carry all traits, so they’re included.
Note that this finder app is a generalized open source project I published:
Feel free to utilize it on your own page – please give me a linkback, either to this page or the GitHub, if you would, though. If you have a CSV file from any Atelier game with recipes and materials, it should work for all of them.