I have a membership application which has a transaction table for membership dues payments referenced on the record id of the master table. Before you added the authorize.net capabilities, we started taking credit cards for membership payments through another authorize.net application.
I have about 6,000 credit cards transactions which I need to add to the payment transactions file using the email address in the master table and in the card transactions which I have loaded in another table in the db.
I need to solve this problem before I add the integrated functionality with the shopping cart. I have been testing stand alone sql using mysql studio, but would like to have everything in the phprunner app if I could. Error checking for existing or non-existent accounts is a major item(email is unique in the master table, plus I have a unique id consisting of a concatenated lowercase string of "firstnamelastnamezipcode". Better than 60% of our members don't have email.
Any suggestions!
Thanks,
Jm Freeman