Import Parent Child Relationships for Companies and Contacts...
resolver
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...
This is now possible via regular import, as per a product update on August 15th. To see the update, open your HubSpot account, click on the account name in the top right corner, followed by Product Updates.
Copied from the announcement:
What is it?
Users can now include the "Parent company" property within a company import file to create parent child associations between companies in bulk.
Why does it matter?
Confidence that you can accurately reflect your business' data in the CRM is key. For many, this means creating parent-child relationships between company records. Today, the only way to create a parent-child relationship is manually on the company record, on a one-by-one basis. This simply doesn't cut it for those who are onboarding on to HubSpot and need to create potentially hundreds of theses associations.
With this update, you will be able to now take this action in bulk by using the imports tool, saving time and energy as you bring your data into HubSpot.
How does it work?
Before creating parent-child company associations via import, make sure that all your parent companies are already within the CRM.
Once all your parent records are in the CRM, find the record ID for your parent companies. You can do this by manually going to each record and searching for Record ID when viewing all properties. Alternatively, you can export a group of companies – the record ID will be the first column found within your import.
Next, create an import file for your child companies. Include a column called "Parent company" and add the record IDs of the corresponding parent companies into this column.
Finally, import this file into HubSpot. Make sure to map the parent company column to the HubSpot property of the same name.
Once your import is complete, you'll have created a parent-child relationship between the records in your import (child companies) and the records identified by the record IDs found within the Parent company column.
Hope this helps!
Karsten Köhler HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer
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.
Import Parent Child Relationships for Companies and Contacts...
resolver
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?
Import Parent Child Relationships for Companies and Contacts...
resolver
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.
Import Parent Child Relationships for Companies and Contacts...
resolver
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.
Import Parent Child Relationships for Companies and Contacts...
resolver
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.
Import Parent Child Relationships for Companies and Contacts...
resolver
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!!
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.
Import Parent Child Relationships for Companies and Contacts...
resolver
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.
may 6, 202111:14 AM - editado may 6, 202111:17 AM
Participante
Import Parent Child Relationships for Companies and Contacts...
resolver
@TrujayJay 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?
Import Parent Child Relationships for Companies and Contacts...
resolver
@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?
Import Parent Child Relationships for Companies and Contacts...
resolver
@TrujayJay 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.