Can anyone help me to get my BOM to update with the Material and Weights?

It automatically fills the Item No, Part No, Description and Quantity columns, but no others.

If anyone has any gems of wisdom they could share, I would be very grateful

Thanks

Dave