Can anyone tell me the SQL query to reset all customer pricing levels back to "standard"
Thanks
Bill
Hobby Central
*This post is locked for comments
Hello Bill,
Thank you for your questions.
Thank you Jeff for providing a solution.
Let us know if you have any other questions.
This will set all customers to a Standard Price Level!!
Backup First!!!
UPDATE Customer SET PriceLevel = 0
Backup First!!!
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,802 Super User 2024 Season 2
Martin Dráb 229,133 Most Valuable Professional
nmaenpaa 101,154