November Happy Hour will be moved to Thursday December 5th.

Script to redact persoanl data inline with GDPR

Vote:
 

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.

Thanks

#256224
Jun 08, 2021 10:57
Vote:
 

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: https://world.episerver.com/documentation/developer-guides/commerce/customers/Customer-object-model-and-database-diagrams/

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

#258476
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.