We run a quarterly NCOA ( Nation Change of Address ) update on our Customer Addresses.
We also have customer integration running 24/7 to another product.
I do not want to overwhelm those integrations while doing the data import to NetSuite. >100K records.
I extract all active US customer address data, send for processing.
When I get the file back, I want to import the address corrections and set a last NCOA processed date to the exported date even on records that did not change.
I do not want to have this import flag/trigger a sync to our other systems.
I can already bulk update these without triggering integration very quickly.
This does not need to happen via CSV import, I could stage the data in MSSQL.
I am doing this already for other endpoints.
The data loaded will fall into 2 groups.
The first is anyone that moved will have the updated address or if the data was correctable, it will standardize to USPS standards. Main Street will be Main St etc.
I will load the fixed address data, update a field with Mailable Address=True and add a processed date.
The second group are records that do not conform to USPS mailing standards.
Invalid street name or number etc.
For this group I want to update the processed date, and set Mailable Address=False.
This prevents waisted mailing and we comply to standards!
It also can alert us to gathering updated information if we communicate with the customer.
I predetermine the groups in staging and do 2 data load steps.
In SQL, I would do a MERGE and the modified on fields can be updated without changing the modified date.
Also, if the address processed date is prior to the last modified date, I do not want to load the data as it has changed since I sent the data for processing.
This is within 24 hours, so that is minimal.
I am looking for the equivalent to "Celigo Update" for Sales Force Accounts and Contacts.
Please sign in to leave a comment.