You have not mentioned which software you are using.
That is important information (and also hardly a secret worth keeping). Each EDA suite has it's own way of implementing BOM tools. And these vary from simple scripts to extract a list of parts, to a complete database that can automatically substitute compatible parts from different vendors and create ordering information with a few mouse clicks.
Hobbyists who occasionally do some projects tend to prefer a simple list, while for companies who manage a lot of projects it is worthwhile to set up a database and improve efficiency though automation.
In general you have to set up such a database yourself, but I think there are exceptions. For example, I think that Easy Eda (which is "free to use" but not "Open Source / FOSS" has an integrated database, but only for parts ordered from JLC. If that is so, you probably pay for that software through a markup on the parts you order.
It's a bit like those programs that are "free" but are not able to generate Gerber or other artwork output. You can only order PCB's made from some specific manurefacturer.