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 ...

    • SmartTRACK NXT Gift Custom field Add-on: A Step-by-Step Guide

      SmartTRACK has an add-on that records the source of a gift in the gift custom fields. This allows you to analyse your campaigns in depth directly in NXT. To enable this feature you must complete several steps. 1. Connect SmartTRACK in the Blackbaud ...

    • SmartIMPORT: Custom code features

      There are two custom code options within SmartIMPORT. First, the 'Start code' block runs at the start of the import process with the spreadsheet row data available. Second, the 'Search code' which runs just after we have searched for a matching ...

    • 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 ...

    • 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. ...