How do you distinguish "leave unchanged" from "clear this field" in CRM bulk updates?
Consider a CSV used to update existing contacts by record ID. Some phone cells are blank because the source has no new information; others are blank because someone deliberately removed an incorrect number. Those are two different instructions, but the file looks the same.
Ignoring every blank preserves good data, yet also preserves numbers that should be cleared. Treating every blank as a deletion risks wiping fields the export simply didn't include.
I'd lean toward a separate, explicit clear-field instruction and a preview that shows additions, replacements and deletions before import. For example, a blank phone cell would leave it alone, while a clear_phone flag would remove it. That adds a little work for whoever prepares the file.
How do you make that distinction in a repeatable bulk-update process, and who reviews intentional clears? I'm interested in the import convention and review step, rather than a CRM recommendation.
[link] [comments]