Currently Hubspot doesn't allow to click on several deals when in the deal overview and edit the associated company field. You need to click into each deal and then associate a company to it. This is a very manual process.
Another way could be to allow mass upload/update of deal properties in Hubspot. Currently, when you upload deals, you have to manually assign them to companies.
I'd like to download the deals with associated contacts, then download the contacts with associated companies and domain names, do a VLOOKUP to associate a company to a deal and then upload it back into Hubspot. Such thing could be done already in the backend of Hubspot and I am surprised that such a basic functionality to auto-associate a company to a deal is not available yet.
+1 to this. I'am migrating from another CRM and really miss this feature. It can probably be done with some API calls, but as a non-programmer I would really like this to be part of the application.
I have found a workaround by using this external importtool: http://wizard.import2.com/home (cost me 26 euro’s, but saved me a lot of time)
What I eventually did:
- Export all data from old CRM in CSV’s
- Import all deals and componies in Hubspot using normal import. In the deals import I created a new field ‘import company’ holding the company name of the deal
- Then I exported all deals from Hubspot, so I had an export containing all Unique Deal ID’s
- Then I used http://wizard.import2.com/home to update all deals with the Associated Company using ‘import company’ as mapping in the CSV
That is the procedure that I used, but you should check out http://wizard.import2.com/home because it gives you the ability to link deals with companies and contacts. Hope this helps. Bytheway I found this solution by searching this forum.
Very much needed for tickets at the moment. I'm importing tickets from ZenDesk to Hubspot, our sales team has been using Hubspot for years and so all of our contacts and companies are already created. So I need to import hundreds of tickets and associate them to existing contacts and companies one by one? There MUST be a better way.
Why can't Associated Contacts, or Associated Companies be an actual property of a ticket or deal, therefore allowing us to update them in our initial imports?
Even if you built a workflow that would add the associated company, that'd work. I don't think that functionality exists though
'once deal is created and at stage 1, enroll in workflow where if a company exists with the same domain as the deal (custom property), associate the deal and company. and move the deal to stage 2 in the pipeline. If there is no company with a domain that matches the deal (custom property), then create company with said domain and associate the company.'