I am using Odoo.sh version 17. I imported 50 products and ran into an issue. One of the columns was the Vendor (which I meant for the Product>Purchase>Vendor so I mapped it to Product>Vendors>Vendor. Made sense to me. Let's call the Vendor ABC Lighting.

When the import ran it created 50 products and 50 different contacts, all called ABC Lighting. 

I tried running the import again matching the product ext ID and tried multiple fields that I thought COULD be the correct vendor ID I was trying to match. All it did was create a new Product, but that new product was mapped to this new Vendor ID. 

So, what am I missing here? Is there a way to accomplish what I am doing?

Thanks!