kagato

Thanks, once I knew the account prices were in tblhosting, it made working out the query pretty simple. I don't expect too many other people will find themselves in the same situation, but I'll provide my solution for reference. I corrected the new customers manually, so they were assigned to the correct packages (that was the long part), then I just had to run the following query to copy the price from the package into the customer's account: update tblhosting, tblproducts set tblhosting.amount = tblproducts.monthly where tblhosting.packageid = tblproducts.id; That should do it. I'm assuming 'amount' is the recurring charge (as opposed to 'firstpaymentamount'). All our customers were monthly, so the query would need amending for different circumstances.

Hi, This is a bit long-winded, but it's a messy problem. (I'll quote the background info, to separate it from the problem as it now stands) If I understand the situation right, WHMCS works the way we'd thought ClientExec would work, and each client keeps the pricing they had when purchasing. Which would have been fine, if we'd been using WHMCS before the price change... So what's the best solution here? I now have 60+ customers assigned to the correct plan, but with the wrong pricing; and ~20 customers assigned to the wrong plan, but with the correct pricing. Is there some sort of batch adjustment I can do (for either group, if not both), so I don't have to edit every single customer by hand?