CRM

BKelly710
Participante

Importing parent/children

resolver

I have a spreadsheet of 600+ companies I want to import into HubSpot. Some of these are parent/children companies with matching domains. Ie 3M Corporate and 3M Fulfillment Center - different addresses, but same domain. How do I import this so it reflects that and doesn't ignore the children companies?

0 Me gusta
2 Soluciones aceptadas
Olivia_Bagnall
Solución
Guía | Partner nivel Platinum
Guía | Partner nivel Platinum

Importing parent/children

resolver

@BKelly710 Happy to help here!

So I am afraid it is not possible to have two companies by the same domain in HubSpot and even if it was I would not advice it. 

What is good though is that we do not have any domain validation so you don't have to import contacts with their accurate domain. This makes it possible to manage franchises and child companies in a kind of round about way. 

You can import the parent company with the real domain and then add an extra top level domain to the children. 

For example: 
KFC HQ = kfc.com
KFC Orlando = kfc.com.ol
KFC Nyw York City = kfc.com.nyc 

The downside of this approach is that if you have automatic contact to company association based on email + domain turned on then all contacts will automatically get associated to the HQ first. In my experience, companies who work with franchises or multiple branches would turn this setting off.


 

Olivia Bagnall

Inbound Consultant and Project Manager

Baskey

 
 
 
o.bagnall@baskey.eu
www.baskey.eu
Rheingasse 14, 50676 Köln
 
 
 

Olivia Bagnall
Platinum HubSpot Partner | HubSpot Specialist | Community Champion
BA°SKEY

Book a meeting

If you need further help with anything, please don't hesitate to book a call above


Ver la solución en mensaje original publicado

karstenkoehler
Solución
Miembro del salón de la fama | Partner
Miembro del salón de la fama | Partner

Importing parent/children

resolver

Hi @BKelly710,

 

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.

 

karstenkoehler_0-1660658546384.png

 

 

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

Beratungstermin mit Karsten vereinbaren

 

Did my post help answer your query? Help the community by marking it as a solution.

Ver la solución en mensaje original publicado

2 Respuestas 2
karstenkoehler
Solución
Miembro del salón de la fama | Partner
Miembro del salón de la fama | Partner

Importing parent/children

resolver

Hi @BKelly710,

 

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.

 

karstenkoehler_0-1660658546384.png

 

 

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

Beratungstermin mit Karsten vereinbaren

 

Did my post help answer your query? Help the community by marking it as a solution.

Olivia_Bagnall
Solución
Guía | Partner nivel Platinum
Guía | Partner nivel Platinum

Importing parent/children

resolver

@BKelly710 Happy to help here!

So I am afraid it is not possible to have two companies by the same domain in HubSpot and even if it was I would not advice it. 

What is good though is that we do not have any domain validation so you don't have to import contacts with their accurate domain. This makes it possible to manage franchises and child companies in a kind of round about way. 

You can import the parent company with the real domain and then add an extra top level domain to the children. 

For example: 
KFC HQ = kfc.com
KFC Orlando = kfc.com.ol
KFC Nyw York City = kfc.com.nyc 

The downside of this approach is that if you have automatic contact to company association based on email + domain turned on then all contacts will automatically get associated to the HQ first. In my experience, companies who work with franchises or multiple branches would turn this setting off.


 

Olivia Bagnall

Inbound Consultant and Project Manager

Baskey

 
 
 
o.bagnall@baskey.eu
www.baskey.eu
Rheingasse 14, 50676 Köln
 
 
 

Olivia Bagnall
Platinum HubSpot Partner | HubSpot Specialist | Community Champion
BA°SKEY

Book a meeting

If you need further help with anything, please don't hesitate to book a call above