IMPORTANT: These steps will completely remove all customers and their orders that meet the criteria you specify. DO NOT PERFORM THESE STEPS UNLESS YOU ARE SURE OF WHAT YOU ARE DOING.
AND, MAKE SURE YOU HAVE A GOOD BACKUP OF YOUR DATABASE BEFORE ATTEMPTING THESE STEPS!
1. Make a backup of your database (Tools > Backup/Restore > Backup, save it to your hard drive).
AND, MAKE SURE YOU HAVE A GOOD BACKUP OF YOUR DATABASE BEFORE ATTEMPTING THESE STEPS!
1. Make a backup of your database (Tools > Backup/Restore > Backup, save it to your hard drive).
2. Go to Misc/Setup > Company/Misc Info from the pull-down menu at the top of the screen
3. Hold down Ctrl and Shift on your keyboard while you type S Q L, and then click OK on the message that appears
4. Copy and paste the code below into the SQL text box there:
--------------------
DELETE FROM CONTACTS
WHERE CLIENTFLAG = 'T' AND EMPLOYEEFLAG <> 'T'
AND (LASTORDERDATE IS NULL OR LASTORDERDATE < '1/1/2005')
AND (LASTCONTACTDATETIME IS NULL OR LASTCONTACTDATETIME < '1/1/2005')
AND (LASTDONEORDERDATE IS NULL OR LASTDONEORDERDATE < '1/1/2005');--------------------
So, this code above will remove all clients who have not had any orders done since then January 1, 2005. If you want to choose some other date, you can just change the date used inside the single quote marks. The date has to be in 'm/d/yyyy' format. If there is some other criteria you'd like to use to delete customer records from your database, please submit your request using our Contact form and someone will send you back the SQL code you need to accomplish that.
5. click Execute.
purging database delete customers delete clients remove customers remove clients purge clients purge customers cleanup database clean up database
Add to favorites