Try our conversational search powered by Generative AI!

Script to redact persoanl data inline with GDPR


Does anyone know of / have a script to redact personal customer information from the commerce database?

We have a need on occassion to pull down a backup of the production database and looking for a way to easily redact customer personal information so we are compliant with GDPR.

Before I make a start with a script was hopinh someone might already have a starting point.


Jun 08, 2021 10:57

Purchase Orders you shouldn't need to delete since its a financial transaction record and doesn't fall under GDPR (Please consult a GDPR expert).

In terms of Commerce tables, take a look at Contact, Address, Organization and and go from there. More here:

Also check what your membership setup is. May not be a problem if you've replaced it with an external provider.

Jul 05, 2021 13:29
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.