CRM

HHH
Participant

Deals - How can I bulk update Deal properties?

SOLVE

I am trying to import properties/values to update fields in Deal records, such as 'Amount' and 'Hubspot Owner'.

 

I created a csv with four records where the 'Deal Name' was identical with the record I wanted updated in Hubspot.  Unfortunately, the Import created duplicate records.

 

Is there a bulk way to update Deal values?

1 Accepted solution
Dylan
Solution
HubSpot Product Team
HubSpot Product Team

Deals - How can I bulk update Deal properties?

SOLVE

Hi everyone, thank you so much for your comments and feedback here. I'm excited to let you all know that this feature is now widely supported in HubSpot, you can import using Object ID (contact, company, deal, ticket) as of today. There are a handful of other capabilities along with this that you may find interesting - the full details are broken down in this blog post.

View solution in original post

7 Replies 7
Dylan
Solution
HubSpot Product Team
HubSpot Product Team

Deals - How can I bulk update Deal properties?

SOLVE

Hi everyone, thank you so much for your comments and feedback here. I'm excited to let you all know that this feature is now widely supported in HubSpot, you can import using Object ID (contact, company, deal, ticket) as of today. There are a handful of other capabilities along with this that you may find interesting - the full details are broken down in this blog post.

ashley_milne
Top Contributor

Deals - How can I bulk update Deal properties?

SOLVE

@HHH

 

Yes, you can bulk-update deals, but you have to use a 3rd party tool at this time (as other users have noted, HubSpot does not have this functionality at this time). 

 

I'd recommend using Import2 Wizard, as the steps are quite simple (and we've already successfully helped quite a few HubSpot users with similar requests!). You would still need the HubSpot unique deal ID to do the update, but, we are working on adding the feature to use name or other deal fields  as the unique identifier in addition to ID. Assuming you don't have your ID's already, you will use the following steps:

 

1. Download your HubSpot deals into CSV, being sure to check "include all properties"

 

Screen Shot 2018-07-27 at 12.05.48.png

 

2. Use this CSV to update the deal fields you need (you can use VLOOKUP for this if you have your updated deal data in another spreadsheet and you don't want to manually copy it over - guide)

 

Screen Shot on 2018-07-27 at 12_08_29.png

 

3. Start a "New Update" with Import2 Wizard, where you upload this CSV you created and map the fields you wish to update (note: you can update all fields, including associated contact/company, amount, owner, custom fields, etc. with this method). 

 

Screenshot 2018-07-27 12.14.42.png

0 Upvotes
lknight2591
Participant

Deals - How can I bulk update Deal properties?

SOLVE

The ability to bulk update deal properties seems like a pretty easy feature to add, and would be immensefully helpful.

Phil_Vallender
Most Valuable Member | Diamond Partner
Most Valuable Member | Diamond Partner

Deals - How can I bulk update Deal properties?

SOLVE

Hi @lknight2591

 

You can bulk edit deals once they are in HubSpot. More info here: How do I bulk edit contacts, companies, tasks, or deals?

 

Hope this helps.

Phil Vallender | HubSpot Website Agency
0 Upvotes
lknight2591
Participant

Deals - How can I bulk update Deal properties?

SOLVE

You can't bulk edit all  properties, for example Associated Company, Associated Contact etc. except through the API. This is a simple functionality that is included in other CRMS like Salesforce where you can associate based on bulk upload, matching on Company and Contact ID. 

Phil_Vallender
Most Valuable Member | Diamond Partner
Most Valuable Member | Diamond Partner

Deals - How can I bulk update Deal properties?

SOLVE

Hi @HHH

 

Unfortunately, deals do not have a deduplication field currently, meaning it is not possible to import updates to existing deals, yet. 

 

More info here: How do I import Deals to the CRM?

 

Hope that helps.

Phil Vallender | HubSpot Website Agency
0 Upvotes
HHH
Participant

Deals - How can I bulk update Deal properties?

SOLVE

Paul,

 

Thanks for the response.  This is disappointing, but I understand.  Do you know if there is a way to update Properties for specific Deal records through the API?

 

Thanks,

Hugh

0 Upvotes