Update domain name to blank/empty using import

apolbepis — Wed, 14 Jun 2023 08:47:25 GMT

In error, hundreds of Company records were created in Hubspot with an incorrect domain.

I want to correct this using company/object ID as a unique identifier and running an import with two columns, for example.

Record ID	Company Domain Name
12345678910

The import runs sucessfully, but the Company Domain Name remains intact with the previous value and is not overwritten as 'blank'. If run the same import but using a fictious domain name, such as deleteme.xyz the record is updated.

I dont have a domain name for these records, so how can I achieve this and remove the Company Domain Name (without doing it manually)?

Thanks

Re: Update domain name to blank/empty using import

TomM2 — Wed, 14 Jun 2023 17:16:50 GMT

Hey @apolbepis HubSpot does only update a property through an import if there's a value for the property, so an empty property will not trigger an update. There is a way to clear values in bulk via workflows, but that tool is only available to professional+ subscriptions.

The only workaround really would be to set the value to something like you mentioned such as "deleteme.com" or "unknown.com" which would update these to that value, but if you want them completely cleared, outside of workflows the only way would be manually.

topic Re: Update domain name to blank/empty using import in Tips, Tricks & Best Practices

Update domain name to blank/empty using import

Re: Update domain name to blank/empty using import