Want to create multiple vendors for a single product

[kazzza]

Hello, I would like to attach multiple vendors to a single product.

E.g. Product A has multiple vendors, V1 and V2
I want to list Product A as a single product, without showing the customer that it is from two vendors.
The cost price is different but the selling price is the same.

Product A automatically sells inventory stock from V1.

However when Product A runs out of inventory stock from V1, it automatically switches to selling the inventory stock from V2 instead.

Could I know if this is possible? Please instruct me with clear instructions, that would be absolutely helpful. Thank you so much for your help.