I am importing a list of SMALL companies they do not have a domain name. Many of these owners are using gmail and hotmail accounts. As I started the import, i got a notice that each line will be a record.
Is there a way to import contacts with companies in this circumstance?
Contact and companies are different record types, so if you want to import contacts and associate them to a company at the same time you need to do a multiple object import. On this page go to the section which says "Contacts and companies sample spreadsheet" and you can download an example of how to upload the data so it works for you: https://knowledge.hubspot.com/crm-setup/set-up-your-import-file
----------------------
Did my post help answer your query? Help the Community by marking it as a solution.
Jun 30, 202010:57 AM - edited Jun 30, 202010:58 AM
Top Contributor | Partner
Importing contacts with companies no domain name
SOLVE
Hi.
So it sounds like 2 things are going on so I'll break them down and respond to each separately:
1. Message/Notification about not able to upload Companies in General:
Like HubSpot uses email as the unique identifier when adding Contacts to to your portal, for Companies, it uses domain name.
If you were to upload a list of Contacts without email address, you would get the same notification, that each line would be a new record. This helps eliminate potential duplicates in your portal if it can verify that it is indeed the same record being updated, not added.
You do need at least Company Name OR domain name to upload a new Company record. If you are just updating Company Records you already have in HubSpot, you can use the Company ID, and then you avoid all of the above.
2. Associating Contact to Companies During Import:
Without seeing the whole error/warning or your spreadsheet headers, it appears you might be missing the "Common Field" Identifier that matches the Contact to the Company Record. This is explained in the link that was shared previously: https://knowledge.hubspot.com/crm-setup/set-up-your-import-file
Something else to consider: the setting on Companies that Automatically create/associate companies with contacts requires use of the contact's email address and company's doman to make the association. You can turn this off, if you are going to associate the conacts to the companies later, when you add in the domains.
Contact and companies are different record types, so if you want to import contacts and associate them to a company at the same time you need to do a multiple object import. On this page go to the section which says "Contacts and companies sample spreadsheet" and you can download an example of how to upload the data so it works for you: https://knowledge.hubspot.com/crm-setup/set-up-your-import-file
----------------------
Did my post help answer your query? Help the Community by marking it as a solution.
Thank you for your reply. THis is what I am doing 1 file - multiple objects - contacts and companies. I tried setting up dummy domain (not a .com or .net extentions) just a cut and paste of teh company name in hopes of creating an id that would tie the files... no luck so far
Jul 1, 202010:59 AM - edited Jul 1, 202011:10 AM
Top Contributor | Partner
Importing contacts with companies no domain name
SOLVE
Ok, without seeing your error files this is what I did to see if it helps:
Turned off "Automatically create & associate companies with contacts" in settings.
Created Test Company & Test Contact Spreadsheets. The common field is just a string of numbers/letters YOU make up and say this string "ABC123" on this company goes with this specific contact record (or vice versa). As long as it is unique for each company, you should be fine. : CompanyContact
Imported associated objects
Mapped the columns on both docs: CompanyContact
Completed the import and checked for errors in the error logs:
Verified that the Contacts & Companies Loaded into the Portal: CompanyContact
As you can see in the error log and the display in the portal, the only company that didn't import was the one with the incorrect domain name and its respective contact record (because I told the system to associate it with a company it couldn't import.
If I went back and corrected/wiped out the domain name on Company Test2IncorrectDomainFormat and reimported the associated contact as well, they will be uploaded.
I would say, check to make sure your files look like step 2, and then look at your error logs, they will tell you exactly what is incorrect on your upload files.
I am new to this and read your helpful response, but would like to check something. Are you both saying that if there is NO domain for the company but there IS a company name and again there is NO email address that a contact and company import cannot occur simultaneously it will only pull in at the contact level and no company name will be recorded. I am struggling to understand the rule in Hubspot. Thanks in advance for any advice
Your version of HubSpot shouldn't matter, so that's a good thing.
It looks/sounds like the dummy domain is what is causing the biggest issue. If you are going to put something in there, it HAS to have a .com/.net/."somethingvalid" EVEN if the domain doesnt exist. I'd suggest NOTHING, rather than have potential errors on the import (delete column P). The worst thing that will happen is you could potentially have duplicate companies, which you can easily merge.
In my example, the ONLY company domain that doesn't import is the incorrectly formatted one. From what I can see on your file, you have 2 - K & P (if you are using website from Column K for the company url). Column P in yours is formatted like the 2nd one in my example and why it is not importing:
Since you are using a single file, the association part is slightly different.
Import > Start an Import > File from computer > Next > One File > Next > Multiple objects > Next > Companies AND Contacts > Next > Upload files > Map Column Headers
In this case (1 file import) you will NOT use the common field column.
If you use a single file, you will need to have 2 Columns for properties like: Company Name (1 to associate to the Contact Object = Company Name and the other to associate to the Company Object = Company Name)
I outlined the properties/columns I am assuming you have for both Companies & Contacts in your example file. In this case the association is done when you are mapping the columns. So you just have to be careful what you are choosing when you are mapping the properties, that you select the right object. The system will make its best guess, but you need to double check it has chosen the right HubSpot Property that matches your data:
As long as you change the format of your dummy domain and choose the right object when you are importing the properties, that should resolve your issue. If you are still getting issues, please post your error file...that will tell us what the system is saying is wrong.
Ok, the pink error is what I was referencing in my last reply for "Company Name" needing to be duplicated for both Contact & Company Objects. You currently have it mapped to the Contact Object now, which works, you just have to do one more step:
You can tell what type of HubSpot property you are mapping to by the icon next to the property name (pink = company icon/property selected; green = contact icon/property selected).
So if you duplicate column A in your spreadsheet and call it "Name" then map it to the Company "Name" HubSpot property you should be good to go.
Sep 29, 20205:25 AM - edited Sep 29, 20206:18 AM
Member
Importing contacts with companies no domain name
SOLVE
Column headers on spreadsheet
Hi all,
I've read the previous posts but they aren't as clear to me as I had hoped. Please note, I am very new to this, so would appreciate any and all help offered.
I have attached the column headers for my spreadsheet.
Please note, I have no email addresses or domain names - so need guidance on what to use as unique identifier.
A step by step guide for a complete novice would be extremely helpful 🙂 thanks in advance.
I looked at the spread sheet samples you sent and This is the way mine are set up. Same line hold record "company" and "Conatact" If I understand you they will be pulledinto hubspot and if I look up the contact it will be associated with the company. Is that right?
Hmmmm.... can't say I've come across this as I have only worked with companies with a domain. This may not be great but to get the job done you could also use a 'dummy' domain eg www.<clientname>-<yourcompanyname>.com ?
----------------------
Did my post help answer your query? Help the Community by marking it as a solution.
Are yoou suggesting manually moving into each account and creating a dummy domain? Hub spot must not be designed for people selling to small businesses.
Jun 30, 202010:57 AM - edited Jun 30, 202010:58 AM
Top Contributor | Partner
Importing contacts with companies no domain name
SOLVE
Hi.
So it sounds like 2 things are going on so I'll break them down and respond to each separately:
1. Message/Notification about not able to upload Companies in General:
Like HubSpot uses email as the unique identifier when adding Contacts to to your portal, for Companies, it uses domain name.
If you were to upload a list of Contacts without email address, you would get the same notification, that each line would be a new record. This helps eliminate potential duplicates in your portal if it can verify that it is indeed the same record being updated, not added.
You do need at least Company Name OR domain name to upload a new Company record. If you are just updating Company Records you already have in HubSpot, you can use the Company ID, and then you avoid all of the above.
2. Associating Contact to Companies During Import:
Without seeing the whole error/warning or your spreadsheet headers, it appears you might be missing the "Common Field" Identifier that matches the Contact to the Company Record. This is explained in the link that was shared previously: https://knowledge.hubspot.com/crm-setup/set-up-your-import-file
Something else to consider: the setting on Companies that Automatically create/associate companies with contacts requires use of the contact's email address and company's doman to make the association. You can turn this off, if you are going to associate the conacts to the companies later, when you add in the domains.
You could do it in the import file rather than manually.
We work with many clients selling to small business and B2C. The difference here is the need for company records and doing this through an import whilst not having a domain to keep them unique. In the industries we have worked in even the smallest of business (1 person) have a domain. I'm not saying that's correct of all industries but I don't personally have the experience in setting up HubSpot this way. My way would work but it would be a workaround so perhaps there is a better solution.
----------------------
Did my post help answer your query? Help the Community by marking it as a solution.
No not at all. I'm just sorry there isn't a straight forward solution.
What I was suggesting was going back to the import spreadsheet and putting the unique dunmy domain in there so your import won't get the same errors as above.
----------------------
Did my post help answer your query? Help the Community by marking it as a solution.