How to Utilize the Bulk Record Update Feature
Bulk Record Update allows you to update multiple records in your system at the same time. Bulk record update lists can be a Comma Delimited Text (.csv) file and must contain the Shape record ID of the records you want to update to ensure the correct records are updated.
- Go to Settings>Bulk Record Update
Start by navigating to “Settings” in the navigation bar. Next click the dropdown labeled “Account Management” to find the “Bulk Record Update” settings page. Bulk Record Update: https://secure.setshape.com/bulkrecordupdate
- Upload the CSV file, including the record ID, for the contacts that you wish to update
Click on the “Drop Files to Upload” area and choose your CSV file to update within Shape. Once your file has been uploaded, you’ll need to map the columns of your spreadsheet to the appropriate fields within Shape.
- Map the fields from your CSV to the fields in Shape and confirm import.
Please note, the record ID is required for bulk record updating. If you do not include the record ID then the system will not know where to update and the data will not be imported to the system. As soon as all the fields are properly mapped, you’ll want to click on “Confirm Import” at the bottom.
- Check on the progress of your import
You can navigate to Reports > Import Report to check on the progress once the import has been initiated. Once the import is complete you can check your files to ensure that the information you just updated has now been filled out properly. Import Report: https://secure.setshape.com/import-report
How to Export the Lead ID
Since the Shape Lead ID is required when performing a bulk record update, you can follow the below steps to export the Lead ID from Shape to include in your CSV file:
- Navigate to your List View
You can export from any list view in the system but you will want to ensure that the records you wish to update are included on the list you go to.
- Use Filters to Narrow Down your Records
On your lists you will find the “Filters” button that you can utilize to filter out any records that you do not need to update. You can use any combination of filters, as well as custom filters, to get the results that you are looking for.
- Add the “ID” Column on your List
At the top of your list, you will find the “Manage Columns” button. Once this is clicked, a popup will appear where you can set what pieces of data are visible on your list. Search for “Lead ID” and click the checkbox next to it. Lastly, click “Apply” to apply your changes.
- Click “Export” Once Finished!
Click Export>CSV to export your current list! Depending on the amount of records you are exporting, this can take some time but you can check your progress anytime from the Export Report linked here Exports will be available for download for 48 hours once completed.
Frequently Asked Questions
Where can I find the record’s ID?+
The record ID is a column in Shape labeled “ID”. Simply bring this column onto your list view and export your records to a CSV which will include the record ID.
How is the bulk record update commonly used?+
Most commonly, it is used for updating a field in multiple records that was imported incorrectly and was left blank. This avoids having to delete and re-import the records to correct the mistake!