Purge old data

  • Posts: 14
  • Thank you received: 0
  • Hikashop Essential
2 months 4 weeks ago #329441

-- HikaShop version -- : 4.4.0
-- Joomla version -- : 3.9.24
-- PHP version -- : 7.3.25
-- Browser(s) name and version -- : Chrome 87.0.4280.88
-- Error-message(debug-mod must be tuned on) -- : none

Is there some supported process to purge old data?

For example, orders and e-mail logs that are more than 18 months old?

I assume that this can be done through a mass action, possibly triggered monthly.


Please Log in or Create an account to join the conversation.

  • Posts: 72738
  • Thank you received: 11091
2 months 4 weeks ago #329449


For the email logs, in the Hikashop Email History Plugin settings, that you can edit via the joomla plugins manager, you can set the parameter "Number of days" to define a retaining period for the log and the rest will be automatic.

For orders, there is no such mechanism as in most case, you want to keep everything.
But yes, you could create a mass action with a trigger "every month", a filter on the "order_modified" column with a condition < {time}-47340000 and an action delete the elements.
Note that in that case, you also need to configure your cron task:

The following user(s) said Thank You: dawehnes

Please Log in or Create an account to join the conversation.

Time to create page: 0.056 seconds
Powered by Kunena Forum