SmartCHECKOUT: GiveWP Export donations with custom fields i.e. BBMS Transaction ID

SmartCHECKOUT: GiveWP Export donations with custom fields i.e. BBMS Transaction ID

You may wish to do financial reconciliation between your GiveWP donations and Raiser's Edge NXT's gifts. BBMS Is Blackbaud Merchant Services and is the payment provider of choice for Blackbaud clients.

Unfortunately GiveWP do not by default export the Transaction ID from donations unless you specify the donation form used. The below allows you to export data from all your donation forms along with the Transaction ID from the BBMS.
  1. Install the free Chrome Extension: CJS (https://chrome.google.com/webstore/detail/custom-javascript-for-web/ddbjnfjiigjmcpcpkmhogomapikjbjdkadd)
  2. Visit your GiveWP Export page. This is in the WordPress admin area under Donations > Tools > Export CSV.
  3. Then click the CJS icon top right of Chrome and paste in the below code
The code:
  2. if (window.location.href.indexOf('type=export_donations') != -1) {
  3. setInterval(function() {
  4.   var $ = jQuery;
  5. if ($('.give-export-donation-button').length == 0) { return; }
  6. if ($('#give-give-donations-hidden-field-_give_bbms_payment_token').length > 0) { return; }
  7. $('.give-export-donation-button').before(
  8.   '<div style="left:-9999px;position:absolute">' +
  9. '<input type="checkbox" name="give_give_donations_export_option[_give_bbms_payment_token]" id="give-give-donations-hidden-field-_give_bbms_payment_token" checked>' +
  10. '<input type="checkbox" name="give_give_donations_export_option[_give_payment_transaction_id]" id="give-give-donations-hidden-field-_give_payment_transaction_id" checked>' +
  11. '</div>'
  12. );
  13. }, 50);
  14. }
When you now click Export you should have two additional columns with the BBMS Payment Token and BBMS Transaction ID.

    • Related Articles

    • SmartLETTERS: Merge fields

      Within your document you can use a wide range of merge fields. These will be taken from the output of Step 1 of your SmartSYNC flow. A non-exhaustive list is below. Merge fields for CONSTITUENT letters The standard fields are listed below. You can ...

    • SmartDONORCOVER: How the transaction fee is calculated and stored

      There are now two options in SmartDONORCOVER OLX on how the fee is calculated. Option 1. The exact fee calculation This is the default and is slightly complex to explain (below we use a fixed $0.26 and variable 2.798%): If your donor gives you $100 ...

    • SmartSYNC: Access NFP Donations to Raiser's Edge

      Access NFP provide their Appeal ID with each donation, we need to map this to the equivalent Campaign, Fund and Appeal in Raiser's Edge (RE). This page takes you through finding the Appeal ID and how to create a SmartSHEET to provide a mapping ...

    • SmartMETRICS Exports - include the System Record ID field and don't rename the column

      SmartMETRICS works with Raiser's Edge queries and exports now. When working with exports there are a couple of requirements: Ensure you select the Constituent System Record ID as one of your export outputs DO NOT rename the System Record ID column. ...

    • SmartSTOREOLX: Asking for additional information (e.g. a child's name)

      If you are using SmartSTOREOLX and wish to gather additional information during the purchase process you can do so using standard Online Express functionality. An example would be using SmartSTORE to gather class registrations where you would like to ...