X-Cart: shopping cart software

X-Cart forums (https://forum.x-cart.com/index.php)
-   Changing and adding new features (https://forum.x-cart.com/forumdisplay.php?f=20)
-   -   GDPR and cleaning unused customers / orders (https://forum.x-cart.com/showthread.php?t=76293)

mcinque 06-04-2018 04:24 AM

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?


All times are GMT -8. The time now is 06:08 AM.

Powered by vBulletin Version 3.5.4
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.