Follow us on Twitter X-Cart on Facebook Wiki
Shopping cart software Solutions for online shops and malls

GDPR and cleaning unused customers / orders
 
Reply
   X-Cart forums > X-Cart 4 > Changing and adding new features
 
Thread Tools Search this Thread
  #1  
Old 06-04-2018, 04:24 AM
 
mcinque mcinque is offline
 

Advanced Member
  
Join Date: Sep 2006
Posts: 65
 

Question GDPR and cleaning unused customers / orders

To minimize data losses in an eventual data breach, and to use personal data only for the time and scope needed (keep personal data of the customer only for the online sell service and for support, then forget them), I would like to clean up all orders and customers info older than X years in a shop.

By using some queries I will drop all the lines which contains data related to an order older than X years ago or a customer that logged in > X years ago, considering the following tables:

CUSTOMERS
Code:
xcart_address_book xcart_customers

ORDERS & RELATED
Code:
xcart_order_status_history xcart_order_extras xcart_order_details_stats xcart_order_details xcart_partner_payment xcart_partner_product_commissions xcart_orders

Am I forgetting other tables related to orders/customers or that have dependances to the ones listed here?
Reply With Quote
Reply
   X-Cart forums > X-Cart 4 > Changing and adding new features


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -8. The time now is 12:37 PM.

   

 
X-Cart forums © 2001-2018