Product export doesn't show stock

The product export has a column called ‘Variant Inventory’ (column R) where it shows how much stock we have for each product.
However, if we add new locations then this column disappears.
Is there any way to add a new location while keeping the stock count in the product export?

Alternatively, is there any way to add the Vendor, RRP, and Cost columns to the inventory export?

Thanks