Try our conversational search powered by Generative AI!

Clearing OrderReportData


Commerce 13.3.1

With the introduction of 


Is there an exposed API that would allow us to clear down the table without creating a sproc? We're trying to sanitize PII data when bringing down production databases and while we're able to delete/obfuscate orders, contacts etc I am unable to find anything that would allow us to remove this data.

Any tips?

Aug 21, 2019 14:25

Once you obfuscated order data, if you run the collect report data again it should generate new report data and overwrite existing one. If that is not the case then it is safe to truncate the table.

There is currently no api to clear report data, but we might look into it

Aug 21, 2019 14:52
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.