We are using the Guest Checkout function in TNEW and noticed that when someone chooses to checkout as a guest but then abandons their cart, a blank record is left in Tessitura with the name "TNEW Guest Checkout".
I know these abandoned records don't technically cause an issue except for the database management aspect. After just a few months, we have almost 900 of these records.
Has anyone else found a workaround for this?
So, I recently had some "free" time and modified Tessitura's Stored Procedure to Merge Constituents. If you create a new list that has all the blank "Guest Checkout" Accounts, then execute this procedure, it'll pull all constituents from the list and merge them.
I have uploaded the stored procedure (LP_MERGE_CUSTOMER2_FROM_LIST.sql) to my profile and this reply if anyone is interested. All you'll have to do is change the List ID on line 47 and instead of "ALTER PROCEDURE" you'd want to do "CREATE PROCEDURE" on line 9.
One thing to note, this procedure just merges one half of the list with the other... so either keep executing until you're down to one. Or you can write a script that will loop this procedure until the list count is one.
Thanks!