A client placed an order using the wrong login account.
I want to change the order detail so that "Order Placed By" will reflect the client whos details are on the order the order and not the account that the person used to login . (He has more than one account)
I'm trying to manually import around 500 clients from a billing system that was custom built into WHMCS.
I've managed to import the clients into tblclients using phpmyadmin. I've also imported the server accounts using server sync.
How do I link the two together so that the client is linked to their hosting package.
I plan to do this via PHPmyadmin so could you let me know what table and what fields need to be edited?