Previously I wrote about how I handle Kicad libraries. That all is still quite valid for the current version of Kicad (5.1.6).
I thought that I should add both the Numbers spreadsheet that is my “parts database,” as well as the Python script I use to create an orderable BOM from the BOM exported from a Kicad schematic and that parts database.
The Python script is here.
The Numbers spreadsheet parts list is here. Export the spreadsheet as a CSV file for use with the script.