Shipping profiles for multiple suppliers

Hi

I have multiple suppliers(dropship) and about 2000 products. Each supplier had different shipping rates

Do I need to setup a separate shipping profile for each supplier?

I noted that if i setup separate profile for each supplier then products will not get carried over to each supplier. Do i need to do this manually? it is not easy to assign products for each supplier manually when you have 1000+ products.

Can someone please advise the best way to take care of this?

thank you