Over the years, many duplicate shipto/dropship customers have been created in CUSTMST. We will attempt to locate and delete these duplicates as part of the conversion process to go live on the new website.
There is a program in LIVE.DATA IIUTIL DUPE.SHIPTO that looks for duplicate customers by matching customer name and zip code and writes these to a work file named DUPE.DROPSHIP. Field 2 of the work file shows how many customers shared the same name[1,7] and zip code[1,5]. This will be re-run to rebuild the work file, then a new process will be written to delete the customers using the following rules:
Timeline 78-4:
- Copy live.data IIUTIL DUPE.SHIPTO to DEV.DATA IIUTIL and get it on your task
- Run IIUTIL DUPE.SHIPTO in DEV.DATA
- Review the ASCII that is written showing all customers who have at least 2 customers with the same name/zip. Make sure that these really are duplicates.
- Write new IIUTIL DELETE.DUPE.SHIPTO which will delete the CUSTMST/CUSTMST.USR using the following rules:
Only if 0 orders in the #Orders column and a null in the Last OrdDate column (meaning customer has not placed any orders in the last 3+ years, so there's nothing in SOCUSTXRF).
Write the deleted CUSTMST & CUSTMST.USR records to a hold file in case we need to bring them back. Name the file "CUSTMST.DUPES"
Using the standard checks that are in the customer maint deletion program ARMS3000.1, validate that the customer can be deleted, then delete it using the logic in this program.
Re-run DUPE.SHIPTO ASCII after complete to see what's left. The rest may have to be manually cleaned up using the merge/purge process
Once this has been tested in DEV.DATA, we are going to run it against the newer data on the Testing Server in the LIVE.DATA account.