Data Import: Updating existing donation records in bulk

This article provides step-by-step instructions for how certain fields in the donations table can be updated in bulk via CSV import.

Data Import - Update existing donation records

Sample CSV File

Field Mapping

Mapping Companies

Undoing a CSV Import

Import History

Training Video

Data Import - Update existing donation records

Within 360MatchPro, you can update donation records in bulk to make it easier for your team to view records in 360MatchPro and ensure they are up-to-date. Because 360MatchPro doesn't automatically update the Pending Payment and Match Complete statuses, the fastest way to update those statuses in bulk is by using the data import feature to update donation records. You can access this feature by navigating to Data Import/Export --> Data Import --> Update Records.  To learn more about donor statuses, view this article.

 

Sample CSV File 

You must include the column titles just like the sample CSV file, even if you don't have company information for a donation record. The columns that need to be included in the CSV file include:

  1. Campaign

  2. Identifier

  3. Amount

  4. Email

  5. Phone

  6. First Name

  7. Last Name

  8. Company Name

  9. Timestamp

  10. Status

 

 

The fields that can be updated through the CSV import feature are the following:
  1. Campaign name
  2. Phone number
  3. Donor's first name
  4. Donor's last name
  5. Company Name
  6. Donation amount
  7. Status

 

You can only update statuses if it is moving forward in the donor journey: Unknown Employer --> Ineligible --> Waiting for Donor --> Match Initiated --> Pending Payment --> Match Complete. Donor statuses can't be updated moving back in this donor journey. For example, if a donor's status is currently Match Initiated in 360MatchPro, you can't move their status to ineligible through the use of this Data import feature.

 

The field that can't be updated through the CSV import feature and must remain the same in the file:

  1. Donation identifier

  2. Donor's email address

  3. Donation date (timestamp)

 

Field Mapping

Once you've imported your CSV file full of donation records, you have the option of mapping 360MatchPro fields with your CSV file fields.

 

If you have followed the same field names within your CSV file, as it is shown in the sample CSV File. Click "Next" to bypass this step.

 

However, if you did not follow the same field names with your CSV file, as it is shown in the sample CSV File. You have to map 360MatchPro fields with the fields in your CSV file. Below is a screenshot of the field mapping:

 

 

Click "Next" to move on to the next page. Mapping Companies

360MatchPro will map any company names based on whether the company is included in our matching gift database. You can keep or not keep the company name.

 

 

Next, import the CSV File by clicking on the "Import Data" button.

It is important to keep in mind that you can't undo an updated donation record. Once you upload a CSV import of updated records, that action can't be reversed. The only option would be to update a new CSV file with the change you'd like to make. 

 

Import History

A new screen will direct you to your CSV Import History and will show you the following information:

1) The name of your CSV File

2) The date the file was uploaded

3) The Import Summary that includes donation records updated successfully failed to be updated, and duplicates.

 

 

Training Video