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.