@Jacinta Thomas, if you want to let the vendor add the shipping rate as per weight, you can use WooCommerce Table Rate plugin : https://woocommerce.com/products/table-rate-shipping/
As this plugin is compatible with WCMp.
But I am afraid currently vendor can’t upload shipping rate via CSV. However you can do custom code and add this flow in your site.