Skip to content

Instantly share code, notes, and snippets.

@daniDLL

daniDLL/anonymize_local_customer_emails

Last active June 1, 2022 12:18
Show Gist options
  • Save daniDLL/89cbe149c5e1db41ab7acccfbd9975c1 to your computer and use it in GitHub Desktop.
Save daniDLL/89cbe149c5e1db41ab7acccfbd9975c1 to your computer and use it in GitHub Desktop.
Download ZIP
anonymize-local-customer-emails
Raw
anonymize_local_customer_emails
UPDATE customer_entity SET email = CONCAT(SUBSTRING(MD5(UUID()), 1, 15) , '@example.com') where entity_id > 0;
UPDATE sales_order SET customer_email = CONCAT(SUBSTRING(MD5(UUID()), 1, 15) , '@example.com') where entity_id > 0;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment