Personenbezogene Daten müssen anonymisiert werden
und log Tabellen geleert werden
1. DB lokal einspielen
2. Folgendes SQL ausführen (phpmyadmin)
— =====================
— CUSTOMER ENTITY
— =====================
UPDATE customer_entity
SET
firstname = CONCAT(‘Vorname’, entity_id),
lastname = CONCAT(‘Nachname’, entity_id),
middlename = NULL,
email = CONCAT(‘user’, entity_id, ‘@example.com’),
prefix = NULL,
suffix = NULL,
dob = NULL,
taxvat = NULL;
— =====================
— CUSTOMER ADDRESS
— =====================
UPDATE customer_address_entity
SET
firstname = ‘Max’,
lastname = ‘Mustermann’,
street = ‘Musterstraße 1’,
city = ‘Musterstadt’,
postcode = ‘00000’,
telephone = ‘0000000000’,
company = ‘Musterfirma’,
fax = NULL,
vat_id = NULL,
region = ‘Thüringen’;
— =====================
— SALES ORDER (Gast & Kunde)
— =====================
UPDATE sales_order
SET
customer_firstname = ‘Vorname’,
customer_lastname = ‘Nachname’,
customer_middlename = NULL,
customer_email = CONCAT(‘order’, entity_id, ‘@example.com’),
remote_ip = ‘127.0.0.1’,
x_forwarded_for = NULL;
— =====================
— SALES ORDER ADDRESS
— =====================
UPDATE sales_order_address
SET
firstname = ‘Vorname’,
lastname = ‘Nachname’,
street = ‘Musterstraße 1’,
city = ‘Musterstadt’,
postcode = ‘00000’,
telephone = ‘0000000000’,
email = CONCAT(‘orderaddress’, parent_id, ‘@example.com’),
company = ‘Musterfirma’;
— =====================
— SALES ORDER GRID
— =====================
UPDATE sales_order_grid
SET
customer_name = CONCAT(‘Dummy Kunde ‘, entity_id),
customer_email = CONCAT(‘grid’, entity_id, ‘@example.com’);
— =====================
— QUOTE
— =====================
UPDATE quote
SET
customer_email = CONCAT(‘quote’, entity_id, ‘@example.com’),
customer_firstname = ‘Vorname’,
customer_lastname = ‘Nachname’;
— =====================
— QUOTE ADDRESS
— =====================
UPDATE quote_address
SET
firstname = ‘Vorname’,
lastname = ‘Nachname’,
street = ‘Musterstraße 1’,
city = ‘Musterstadt’,
postcode = ‘00000’,
telephone = ‘0000000000’,
company = ‘Musterfirma’,
email = CONCAT(‘quoteaddr’, address_id, ‘@example.com’);
— =====================
— NEWSLETTER
— =====================
UPDATE newsletter_subscriber
SET subscriber_email = CONCAT(‘newsletter’, subscriber_id, ‘@example.com’);
TRUNCATE TABLE customer_log;
TRUNCATE TABLE customer_visitor;
TRUNCATE TABLE report_event;
TRUNCATE TABLE customer_visitor;
UPDATE `core_config_data` SET `value` = ‘database_export’ WHERE `core_config_data`.`path` like “catalog/search/elasticsearch7_index_prefix”;
3. DB wieder exportieren