Syncronizing Old and New Ecommerce Data

Contact data

WWW=Who(Person), What(Company), Where(Address)
---
OOO repeat business
OON company moved? Emp xfer to new div?
ONO company changed name?  New div? New co?
ONN new job or maybe co. moved and changed names
NOO new employee? Common Name?
NON new emp., diff location or division
NNO Co folded? New emp & co rename?
NNN new business

O = Old
N = New

ROUTINES
-Normalize Company Name
-Verify/Normalize Address w/USPS Zip+4
http://www.usps.gov/ncsc/lookups/lookup_zip+4.html -Normalize short names to full w/nickname. e.g. Jim Jones => James (Jim) Jones. QUESTIONS -Is there a company name registry? -Database of common name abbreviations?

See also: