How to clear old entries in order history

  • Posts: 220
  • Thank you received: 8
6 years 1 month ago #288869

-- HikaShop version -- : 3.2.2
-- Joomla version -- : 3.8.3
-- PHP version -- : 5.6.33

Hi,

The history table in the dbase is getting very very big. There are thousands of orders and each order has several entries in the order history table.
This information is useful for recent orders. But it's superfluous for old orders that have been processed many months ago.

Is there a way to clear entries in the order history that are older than say a year?

Perhaps like the way the clearing of old entries is done in the Email History Plugin?

Kind regards,
Udo

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

  • Posts: 81515
  • Thank you received: 13069
  • MODERATOR
6 years 1 month ago #288870

Hi,

There is no such system in place.
The history table doesn't store much data normally. While you indeed have several entries per order, that's the same with the order_product table.
But even with thousands of orders, it shouldn't be a big deal and should change performances keeping them.

Nevertheless, if you want to clear the history, you can edit the hikashop_history table and remove the old entries in there via your PHPMyAdmin.

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

  • Posts: 220
  • Thank you received: 8
6 years 1 month ago #289044

Thanks for the reassurance.
I was afraid it might slow down performance.

Regards,
Udo

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

Time to create page: 0.058 seconds
Powered by Kunena Forum