This our my requirement from the customer, for old orders we have to delete everything created in Commerce system so we have the same state is it has never been created. So no leftovers of email address, order details can remain anywhere in the database. How to achieve this?
I found that PurchaseOrder and Contact I can delete through API, that seems to be easy, although I am not sure if any leftovers will remain in the database.
I am wondering what is the suggestion here what should be done in addition. I found in another thread that for OrderReportData table there is no API. Also what about cls_RecentReferenceHistory, I found sensitive data there as well. Is there anything else which we should remove? How could these be safely removed?
Using Commerce 12.14
I notice this text on https://world.episerver.com/documentation/developer-guides/gdpr-guidelines/the-episerver-platform-and-gdpr/episerver-commerce/:
You should be able to delete most types of data by querying the Episerver Commerce database. A request to the Managed Services team for deleting data can be made in cases where you cannot delete the data yourself.