Adjusting products via DB

[DMN31]

Hi everyone -

 

Another question for the forum, hoping someone can help. We're updating customers accounts that have old services that now have an updated version in our catalog. So basically going into their product/service page and changing it to an updated version of that product so we can delete the old ones once customers are moved off of them from within WHMCS. We ran into a few that have 200-500 old customers under certain products. This would take forever to do manually like we have on the rest, so I wanted to see if there's any quick methods to do this?

 

Thank you

[brian!]

this would take forever to do manually like we have on the rest, so I wanted to see if there's any quick methods to do this?

one option would be run a SQL query to update the database directly - the complexity of that query would be determined by whether you're just swapping product x for product y, or whether you also need to change pricing etc at the same time.

 

if you're not familiar with writing SQL queries, it's best to follow 2 pieces of advice... get someone who is familiar to write it for you - and whatever you do, backup the database before making any changes!