There are many different situations which may require a bulk update of records in OpenCRM.

A couple of examples are:

• A User changes name, or leaves the company, or records need to be reassigned from one User to another.
• The Quote Stage of a set of Quotes needs to be updated.
• You wish to bulk edit the status of a set of Leads

Within OpenCRM you can bulk update the value of any field.

In order to do this, you need to select the records to update, either individually by ticking the boxes for each record:

or in bulk by ticking the box at the top of the grid

This will tick all the records showing.

To learn how to select a full set of records from a view you have created (for example if you wanted to bulk update "All New Leads This Month"), please refer to the following FAQ on how to create a view: http://opencrm.co.uk/crm-knowledgebase/kb625872/How-can-new-views-be-created.html

Below the grid you have a box titled "Update". Here you can select the field you wish to update, and in the blank field you can enter the new value

When you hit "GO" a warning message will appear.

As the warning message clearly indicates, there is no way of reversing this process once you have completed it!

• Rate This Article

  
  
• Feedback and Comments

  Name:

  
  

You may also be interested in:

• Social Network links on Companies, Contacts and Leads - how do we find usernames from the various Social Media Networks?  Updated : 12-04-2013 14:24
  OpenCRM::Leads OpenCRM::Contacts OpenCRM::Companies
• I want choose some records from a list and export these records only, is there a simple way of doing this?  Updated : 14-05-2012 10:01
  OpenCRM::Leads OpenCRM::Contacts OpenCRM::Companies

• How does the Mapping tool work in OpenCRM? I want to see the locations of my Leads, Companies and Contacts on a Map, how do I do this?

    Updated : 20-05-2013 14:53
  OpenCRM::Leads OpenCRM::Contacts OpenCRM::Companies
• How can I change the fields visible on the Basic and Advanced Search screens?  Updated : 03-04-2012 15:11
  OpenCRM::Leads OpenCRM::Contacts OpenCRM::Activities OpenCRM::Companies OpenCRM::Opportunities OpenCRM::Quotes OpenCRM::Orders::Sales Orders OpenCRM::Orders::Purchase Orders OpenCRM::Invoice OpenCRM::Projects OpenCRM::Helpdesk
• How do I code emails in order to track click throughs, enquiries and to automatically manage remove me requests?  Updated : 17-02-2012 11:53
  OpenCRM::Leads OpenCRM::Emails OpenCRM::Contacts OpenCRM::Companies OpenCRM::Settings::Templates Hosted::Portal
• 

  What are Action Plans in OpenCRM and how can I use them to get the most out of my OpenCRM solution? And what are Conditional Action Plans?

    Updated : 14-05-2012 16:34
  OpenCRM::Leads OpenCRM::Emails OpenCRM::Contacts OpenCRM::Activities OpenCRM::Companies OpenCRM::Opportunities OpenCRM::Quotes OpenCRM::Orders::Sales Orders OpenCRM::Orders::Purchase Orders OpenCRM::Invoice OpenCRM::Projects OpenCRM::Helpdesk OpenCRM::Documents OpenCRM::Events OpenCRM::Campaigns OpenCRM::Settings OpenCRM::Settings::Additional
• Can round-robin be used to assign records when importing data?  Updated : 14-11-2011 11:00
  OpenCRM::Leads OpenCRM::Contacts OpenCRM::Companies OpenCRM::Helpdesk OpenCRM::Settings::Users OpenCRM::Settings::Additional
• How can I get Leads into OpenCRM from a contact form on my website? How do the OpenCRM contact forms work and how do I customise them? Applies to Version 3.02+  Updated : 31-10-2011 11:20
  OpenCRM::Leads OpenCRM::Data Import-Export
• How can I get Leads into OpenCRM from a contact form on my website? How do the OpenCRM contact forms work and how do I customise them? Applies to All versions  Updated : 31-10-2011 11:19
  OpenCRM::Leads OpenCRM::Data Import-Export

• A tab count shows a " * " and no value, A tab count shows " ~ ". Large tab counts seem a bit inaccurate. How does tab count caching work? Why does opening a record with a large number of linked items take a long time? Why can I only see 1000 records in linked grids?

    Updated : 30-03-2013 10:41
  OpenCRM::Home OpenCRM::Calendar OpenCRM::Leads OpenCRM::Emails OpenCRM::SMS OpenCRM::Contacts OpenCRM::Activities OpenCRM::Reports OpenCRM::Companies OpenCRM::Opportunities OpenCRM::Quotes OpenCRM::Orders::Sales Orders OpenCRM::Orders::Purchase Orders OpenCRM::Invoice OpenCRM::Projects OpenCRM::Helpdesk OpenCRM::Helpdesk::FAQ OpenCRM::Documents OpenCRM::Products OpenCRM::Products::Stock Items OpenCRM::Dashboards OpenCRM::RSS OpenCRM::Contracts OpenCRM::Personnel OpenCRM::Events OpenCRM::Property OpenCRM::Campaigns OpenCRM::Interface-Display OpenCRM::Settings OpenCRM::Settings::Users OpenCRM::Settings::Templates OpenCRM::Settings::Additional OpenCRM::Settings::Custom Fields OpenCRM::Settings::Google Sync OpenCRM::Portal OpenCRM::Add-in::Outlook OpenCRM::Add-in::Pop2OpenCRM OpenCRM::Add-in::SOAP OpenCRM::Add-in::SageLink OpenCRM::Add-in::Web Form OpenCRM::Add-in::Custom Module/code OpenCRM::Editor OpenCRM::Sage Integration OpenCRM::Phone Integration OpenCRM::Data Import-Export