How to include Distributor fields into BOM?

With KiCad V7 or V8 (I don’t know) the cooperation with database was added (I also don’t know how).
As I had the need like you when KiCad was V4 I just copied my solution I was using for years with Protel.

I have described my way here (read also previous posts):

This description was for V7. With V8 it became even easier. I need not to go through file. Just at schematic Tools-Generate BOM window I can select all (by Ctrl+A) and copy it by (Ctrl+C) and then paste it in my spreadsheet.
For each element I then have as many alternative parts listed as I want.

Don’t know if it will be helpful, but may be you will be interested also in: