Updating Company Owner via Bulk Import

[JQuijano]

I have this problem where I need to change the company owner to empty or unassigned. I'm using the Company ID and Company Owner properties. I tried the keyword "No owner", "Unassigned" or just an empty field for the Company Owner propeties and yet after importing, HS told me that they failed to upload it due to that Company Owner property is undetectable. What keyword should I use to change ownership to none for Company Owner properties? Thank you

[RBozeman]

Hi @JQuijano,

I replied to one of your earlier threads but wanted to share some context here. Not sure if this feature is something that you are still looking for. You can, as Karsten mentioned above, use that process to bulk update owners but it is a bit time-consuming to set all the filters and run the process after each import. 

Using Insycle (full disclosure, I work there), you can bulk update any particular field on import. So you could easily wipe your Owner fields while importing information, saving you time on the process just mentioned. 

Additionally, you can add contacts to lists, format fields, associate contacts, and find & replace data directly when imorting, so that the data is consistent and the way that you would like it when it hits HubSpot. 

Thanks!

Ryan

[karstenkoehler · Accepted solution]

Hi @JQuijano,

The easiest way to do this would be to import those records (without an owner column) and clear the property after the import.

After importing the file, you can scroll down a bit in the import section of the tool. Hover over the import and click "View companies". You'll be redirected to the company index page, pre-filtered to show only the imported companies. (Below a screenshot of a contact import.)

Now follow these steps: https://knowledge.hubspot.com/crm-setup/how-can-i-bulk-edit-contacts-companies-deals-or-tasks#edit-r...

Simply set the Company owner property to "No owner":

Best regards!

[JQuijano]

Oh I see. So I need to collect all the Companies I need and edit it after the import. I just thought that it would be possible directly for bulk import. Thank you for this help Karsten 🙂