We run loyalty program for customers.
When customers (both online and offline) purchase something, a field called " Loyalty point" is populated with the reward point that a customer obtained from their purchase.
Problem is: When a web customer registers online and makes a purchase via PayPal Express Checkout, the system creates a new customer record and populates the customer record with a new Loyalty point. If the customer has made a purchase before, they have an existing record with the Loyalty point field populated.
To deal with duplication, Mass Duplicate Update is used to merge customers with the same email addresses once a month.
When Mass Duplicate Update is carried out, customers' loyalty point gets overwritten from the duplicate record into the Master record.
Instead of overwriting the Loyalty point data, the Loyalty points need to be ADDED together and populate the new Customer Record when Mass Duplicate Merging is done.
Old Record: Loyalty Point = 20
New Record: Loyalty Point = 40
Merged Record, Loyalty = Old + New = 60
I am thinking of creating a new custom field with a SUM function and run two saved searches on customers records to source the data then add them together in an exported Saved Search then repopulate the Loyalty Field. But it sounds too complicated.
Any suggestions for storing the customers' loyalty points from an existing customer record into the new customer record when record is being merged
using an automated method?