OpenCart Community

I'm wondering what is the best practice to lighten up the database, particularly the order table.
I've got about 6 years of orders and would like to lighten it up by only keeping the last 3 years and archiving the rest.

I know first and foremost download a back up copy and store it safely.
But should I just then, delete previous orders rows in phpmyadmin and that it? or is there a better method?


Thanks

One of those Extensions may solve your Problem:
https://www.opencart.com/index.php?rout ... n_id=28516
https://www.opencart.com/index.php?rout ... n_id=27309
https://www.opencart.com/index.php?rout ... n_id=40368
https://www.opencart.com/index.php?rout ... n_id=22905
https://www.opencart.com/index.php?rout ... n_id=16049
https://www.opencart.com/index.php?rout ... n_id=13504

Thank you!
I'll check those out

For anyone that searches the forum,
I ended up doing the following:

1. Backup my database
2. Went into phpmyadmin
3. ran the following sql command :
DELETE from `order` where date_added < '2018-01-01'

This deleted orders older from January 1 2018.

Exporting (backup) old entries and deleting them is not really what you have written: archive.
Such would be for me to move older entries to an extra table and to be able to call old(er) entries when I need them.

You only are deleting them, but have to reimport them again when you need some ..
Completely different!