I have a large amount of data I am importing into HubSpot. I have had to create a fake Company Domain Name as most records either had no website or many email addresses that did not reflect the company. For instance, Test Company would be testcompany.com.
My issue now is that the Company Domain Name is overwriting the Website URL in instances where there is a website. I have tried bulk editing the records, and Website URL is not an option to bulk update.
Is there a way to prevent this or work around it?
Hi @bglick84,
HubSpot prevents bulk edits of certain fields, yes. For example, you can’t bulk edit first names if contacts. The workaround would be a workflow and the “Edit record” workflow action.
Are you saying that the company domain name is overwriting existing website URL values? Could you share a screenshot if the property history if an affected record? (Hover mouse over value in “Website URL” field, click “Details”, share screenshot of left sidebar)
Best regards
Hey @bglick84!
This happens because Company domain name is HubSpot’s primary identifier for companies, and when you update it, HubSpot may automatically sync it to the Website URL property. If you’re using fake domains just to allow the import, that’s likely what’s overwriting real website values.
The cleanest workaround is to avoid using fake domains and instead use a custom property (like “Import ID” or “Temporary Domain”) for deduplication, or split your import into companies with real domains and those without. If the overwrite already happened, Website URL can still be corrected via a new import or workflow, even though it’s not available for bulk edit in the index view.
If you need further help with this at ZUID we can help, we offer free consultations!
Carolina De Mares
ZUID.
Goirkekanaaldijk 12
5046 AT Tilburg
Nederland
@bglick84 if the overwrite already happened, here is a workflow-based fix:
1. Export companies with Company Domain Name and Website URL
2. Filter for rows where Website URL equals Company Domain Name
3. Create re-import file with correct Website URLs
4. Use Edit record workflow action or re-import with Company ID
For prevention, create a custom Import Batch ID property for deduplication instead of fake domains. Cleaner long-term.
HubSpot domain-matching is aggressive by design but causes migration headaches!
Thanks! I have created a custom Import Batch ID property for deduplication but on a test import, it duplicated the records. My batch ID value is tod-4wwelding and I have 2 records with the same value. It imported both. How do I get it to use this new field as deduplication?