Import Parent Child Relationships for Companies and Contacts...

I have over 500 parent companies each with anywhere from 10 to 500 child companies that I really don’t want to set all the realtionships by hand. I also have thousands of contacts that I need to relate to their companies. Please help…

I am having a similar issue. I don’t understand why I can bulk update any contact field except the associated company. Associated company is one of the most important contact attributes and a central piece of the HubSpot sales and marketing system. Given the volume of contacts that would come to the CRM using a freemail domain and the large number of “child” governement organisations that would use a “parent” domain email address, bulk company association seems a fundamental activity. It is certainly available in other CRMs I have worked with.

Exactlly… I’ve imported a small group of 100 child companies and their contacts. Now I have to spend the next hour or so to set all of the realtionships. I really hope there’s a way to automate this.

I have spent considerable time on calls with Hubspot and I actually feel like I am being painful for asking for something that appears to be so fundamental, especially given the importance HubSpot puts on the organisational hierarchy. I have 8000 contacts and growing, and my only choice is to create an independant hierarchy of fields to segment my contacts into their organisation and parent organisation. This will be far quicker than manually associating them individually, but I lose any of the company analytics by doing so. It still makes no sense to me that this is not a priority. I came across from Zoho and looked at Salesforce, but ultimatey wanted to use 1 platform for my CRM and marketing. I think I am going to have to abandon that as I just can’t justify the resource required to achieve something so basic. I have even paid for the marketing and sales platforms!!

Hey @Swaabi,

We can import these relationships for you and it is not an issue. Would be happy to help. You can email me direct at scot@trujay.com and can guide you on some options with our migration tool.

Scot

Hi Scot,

Good Day

How do you import parent-child companies? I have 1000+ Parent Company and each has 5 or more child companies. I am currently associating relationship one by one.

Thanks

Hi @Rache ! I work with Scot. If you want to reach out to me at jay@trujay.com, I can walk you through our process.
Best,

Jay

@noahmckeon I’m having issues with parent/child relationships not coming over from SalesForce, is this something that has been resolved and maybe I am just missing a setting somewhere?

@DDavis13 Are you referring to using the HS <> SFDC sync to bring parent/child relationships across? If so, this unfortunately isn’t a function available in the sync. We could do it as a one-time import, but we’re not able to sync it continuously. What is your use case?

@noahmckeon yes we are trying to move files from SFDC to HS. I was able to move the over 5600 accounts (companies) over but the relationships didn’t come over. So if there is a way to do this that would be easier than me going into each of them manually.

@DDavis13 Yes, there’s a much easier way! Shoot me an email at jay@trujay.com and we can get this sorted for you.

**
_hubspot-button-accept-as-solution-gif-v00.gif
**

Q: Import Parent Child Relationships for Companies and Contacts…?

Short A: You’ll want to use a 3rd-party import service to maintain associations while importing from another CRM into HubSpot CRM.

Longer A:

The one we like is Import2 -- awesome service.

UPDATE (2019):

The HubSpot CRM Associations API now supports parent/child relationships.

UPDATE:

- see [Now Live] 5 Updates to Import You Don’t Want to Miss (1-Aug-2018)

- see [Now Live] Import, Deduplicate, and Search Objects Using Object ID (16-Aug-2018)

- see [HubSpot Connect] - Import2 Wizard Integration (26-Jul-2018)

- see Introducing Parent-Child Relationships in HubSpot CRM (26-Jan-2017)

Unfortunately setting parent/child relationship is not yet possible with API. Therefore 3rd party tools would not be able to do it either.

You can vote for this feature though at https://community.hubspot.com/t5/HubSpot-Ideas/Add-API-to-Manage-Parent-Child-Company-Relationships/idi-p/179078#M14324

I tried using this 3rd party importer. However, it created duplicate accounts. I tried adding company ID to the Import only to find the 3rd party doesn’t use Company IDs. Know of another way?

If you have been using Import2 Wizard for the task, please note that it has 2 functions:

- Import, that will always create a new record

- Export, that will update existing records and therefore will not create any duplicated for you.

And if you reach out to Import2 help, I am sure you will get help with getting this setup correctly to avoid the duplicates

Hi Carly! We (Trujay / Data2CRM) use the Company ID when doing parent/child imports, so we can easily help you. Feel free to reach me at jay@trujay.com and we can get you squared away quickly.
Warmly,

Jay

Hi all,

We can help. Please feel free to reach out to me directly (jay@trujay.com) for additional info!
Best,

Jay Hendricks

Founder/CCO
Trujay
trujay.com

Hey there @DCPS,

We can migrate Parent/Child relationships for you no problem and have done this for many of our customers. Feel free to reach out to me at scot@trujay.com, would be happy to discuss.

Best,

Scot

Hey All,

If this is still something you are looking for, @Dave_ at Integration Fox has built a tool that does this really well and is able to recreate it for others incredibly affordably

Based on setting a Parent Company ID property either manually or via an import, Integration Fox automatically creates a Parent/Child relationship with the matching Company.

Easy!

We really need this feature to be an option. I am updating our database and as we work with schools and districts, i have over 9000 districts that need up to 800 child companies associated with them and doing this manually is not feasable. It is causing us to not be able to use companies and company properties as well as we should be as well as associating contacts with those companies.