Wordpress - Custom PHP - Verify Synced Data

We have a Wordpress site where people register their children for a sports league through Gravity Forms. After registration, their info is pushed into into another system called FreeAgent through custom code and the FreeAgent API. Last season, some enries didn't get pushed over and we were missing data, so we want to create an automated verification process that will verify the data was passed over, and if it's missing, push the data over again. Details are below. 1. All code can be found in our child theme [login to view URL] and childtheme/funcincludes/[login to view URL] 2. I've setup a dev site for you to work on 3. The form is here: [login to view URL] (pw: play) 4. Form id is 118 5. We would like to open up registration on Tuesday 3/26. Looking to have this completed before then. Pre Tasks 1. Before pushing children's names to Freeagent, remove all strange characters from their names (comma, apostrophe, etc.). Those seem to mess up the sync. 2. Currently the field for 'Season' (id: 259) will replace the existing value in Freeagent. ie. So if a player or contact previously played in 'Spring 2023' that would be replaced with 'Spring 2024' We don't want that. Make it so the Freeagent field keeps the old value and adds the new season. So it should be {'Spring 2023', ''Spring 2024'}. The field in Freeagent allows multiple choices. The sync code will need to be updated to look up existing Season value in Freeagent and add them both to the field (old season values and new season). Sync Verify Tasks note: parent can choose to register 1, 2 or 3 players. When talking about players 2 and 3, it only applies when parents registered that many children. 1. There are 4 records that we want to verify were pushed correctly: - Parent: syncs to 'Contact' in FreeAgent - Player 1: syncs to 'Player' in Freeagent - Player 2: if two players - Player 3: if three players were registered 2. After the initial sync, the Wordpress entry should be updated with the matching Freeagent Id for each record. These are saved back to the following fields: - FreeAgent Contact Id (id: 326) - First Child FreeAgent ID (id: 310) - Second Child FreeAgent ID (id: 311) - Third Child FreeAgent ID (id: 312) We'll use these id's to look up the matching records in Freeagent to see if they exist 3. On each entry there is a hidden field 'FA Sync Verified' (id: 334) This will be used mark entries as verified. (more on this later) 4. Setup a cron, or other automated script to run every 6 hours. 5. The cron script will pull all entries where 'FA Sync Verified' != true 6. Loop through these and check Freeagent for matching records. Use API to pull existing record from freeagent based on Freeagent Id in entry. If any don't match, try to re-sync the entry. Check following criteria: - On Wordpress entry, check that all Freeagent Id fields have valid values ('FreeAgent Contact Id', 'First Child FreeAgent ID', etc.) The Freeagent Id follows a pattern, see existing function isValidFAPattern(). Sometimes if the sync fails this field will have something like 'error' or 'timeout'. Empty or invalid Ids need to be re-synced. - Check that contact was synced to 'Contact' record and these match: first name, last name, email, season - Check that players (1, 2 or 3) were synced to 'Player' records and these match: first name, last name, date of birth, grade level, season 7. If a record is verified as synced, update the record with 'FA Sync Verified' (id: 334) = true 8. If a record cannot be verified, try to re-sync it. 9. If a record fails re-syncing twice, the system should send me an error email, with the id of the entry so I can evaluate it. Please let me know if you have any questions. I am available to assist if you have problems and can provide full access to all systems needs.