Ya, it's ugly. I know a merge is not reversible. Monday night, one of my users somehow merged 167 customers into their "parent" company (it's the partner in real life, but it's set up as the parent in NS). She doesn't know how she did it.
With these customers came all their Contacts, opportunities, sales orders, support cases, custom records that track what they own, and on and on. Some of them had login access to the Customer Center so, temporarily, they could log in and see whatever info is available in the Customer Center for all of the 166 other customers (cases, primarily).
I considered hitting up NetSuite for a rollback, but... didn't. We have nearly 8k customers and I determined it better to take a different path. Instead, I dug into System Notes of various records to figure out who exactly was merged, and get their customer ID and name. Recreated the customer records so I have something to assign all their records to, and ground through 10k+ records of cases and the custom records and contact records using System Notes to extract Old Value, get crazy with VLookup in Excel and assign them to the appropriate customers.
I did all of that in about 12hrs Tuesday evening so Support could work cases with the customers appropriately and we could sell new orders to the customers.
THE BIG SCARY: what's the best approach to clean up all the transactions? Journal Entries also were pointed to the parent. Closed transactions, closed periods. We just implemented NetSuite 5 months ago, if that's good news...
Another big question: how can someone accidentally merge 167 records? The email address on all of them is the same as the parent, so the duplicate detection picked that up as it should. The user is fairly savvy, and I'm inclined to believe her when she says she wasn't touching the merge functionality. Is there a potential bug? Some way-too-quick-and-easy method to merge all those?