So, this just happened ... a customer has been subscribing to a recurring service for a few months. They then wanted to add another service, but instead of logging into their current account, they ordered as a guest which created a brand new account for them. From what I can tell, they also used a different C/Cards for each subscription. They want to "merge" the 2nd account into the 1st original account.
Is there a way I can do that by editing the records in the DB? If so, can you briefly let me know which table I need to make sure I keep in sync so I don't miss one and potentially break the order when it auto-renews next month...?
Thanks for the help!
-Ben