Our Batch Update Process feature allows you to import a file into Salesforce and communicate directly with iATS Payments, to make updates to an iATS Customer Code and NPSP records. A history log, excel templates, and email notifications are also included!
Using this method you can amend the schedule details, payment details, and perform actions such as cancel a recurring donation schedule in bulk.
Understanding key objects and concepts:
Steps to use Batch Processing:
|1.||To create the .csv file, start by exporting the report called iATS Batch Template – Update iATS CCode which you will find in the iATS Brickwork Reports folder. Use this template to create a .csv file to use with the data import tool of your choice. If you export the report (even if there are no results shown) you’ll find all the fields that you’ll need to complete to setup a new recurring schedule.|
|2.||Create a .csv file. Please refer to the Help Text for each field on an iATS Customer Code record to understand the values the record expects. Make any needed changes:
Important fields of note:
|3.||Import the file into Salesforce using the import tool of your choice, such as the Import Wizard or Data Loader. You are updating the iATS Customer Code object. If you like, review the newly created records for accuracy.|
|4.||To finalize the updates and send the changes to iATS Payments, navigate to the iATS Settings tab and scroll down to the “Batch Entry and Update Processing” section. You should see that there are at least as many records waiting to be updated as you updated iATS Customer Code records. Any extra will be records previously updated with the “Include in next batch update batch” by not yet run. Review those if necessary.|
|5.||Click the Process iATS Customer Code Updates button. Depending on how many records there are to updates, this process could take some time. Do not re-click the process button. You will also receive an email confirmation once the batch is finished and providing result details. You can also review the iATS Log that will be generated for further details.|