Does anyone know of an add-on for RMS that allows you to merge local customer records? Over the years, our stores have built up a large number of duplicate records and I would really like to clean up the data.
*This post is locked for comments
Does anyone know of an add-on for RMS that allows you to merge local customer records? Over the years, our stores have built up a large number of duplicate records and I would really like to clean up the data.
*This post is locked for comments
Rick,
That isn't correct. VIP Zone works perfect for local customers at a single store. I purchased it several years ago and have never had it easier when needing to merge customer accounts. A couple of clicks and that's it. There's a lot of other nice features too, but the customer merge was the feature I wanted. Again, it works just fine for local customers at a single store.
Craig
Rick,
Yes, I believe you could find those fields in the customer table and then duplicate the update statement to include that.
We don't use layaways here so I'm not sure if any other tables need to be looked at besides Customer.
It might be safer to go with an add-on that will ensure accurate merging like Jeff suggests; although like you said I have found mostly addons for HQ and not for a local store.
I always run these on a test database first, you could backup your current database, and see if it works how you want it to.
Thanks, guys. Scott, what about layaways, etc.? Won't I lose my links to them? Are there other tables I need to be concerned with?
Jeff, I looked at that VIP Zone and got all excited till I heard it only works on Global customers. Mine are all Local. I need something that will work on Local customers.
Rick,
Try DRS' VIPZone http://digitalretailer.com/rmsaddins/index.htm
This might not be practical if you have a large number of records, because it would require you to merge each individual account.
Also, I'm not sure if this is the cleanest SQL statements; but when we have to merge an account it's what I came up with to use.
UPDATE [Transaction]
SET CustomerID=(SELECT Customer.ID FROM Customer WHERE
Customer.AccountNumber='New Account#')
WHERE CustomerID in (SELECT Customer.ID FROM Customer WHERE
Customer.AccountNumber='Old Account#')
*This first part transfers all transactions from the old account to the new one.
UPDATE CUSTOMER
SET Customer.TotalVisits=(SELECT SUM(TotalVisits) FROM customer
WHERE customer.accountnumber IN ('New Account#','Old Account#'))WHERE AccountNumber='New Account#'
UPDATE CUSTOMER
SET Customer.TotalSales=(SELECT SUM(TotalSales) FROM customer
WHERE customer.accountnumber IN ('New Account#','Old Account#'))WHERE AccountNumber='New Account#'
UPDATE CUSTOMER
SET Customer.TotalSavings=(SELECT SUM(TotalSavings) FROM customer
WHERE customer.accountnumber IN ('New Account#','Old Account#'))WHERE AccountNumber='New Account#'
*This sums the total visits, total sales and total savings of the duplicate records.
Be very careful when running these type of statements, it could really mess up all of you customer data. Back up first.
And, if anyone has a better way please share!
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... 291,269 Super User 2024 Season 2
Martin Dráb 230,198 Most Valuable Professional
nmaenpaa 101,156