Regarding different discussions here and after my own research for a solution reducing space on the server:
1, Delete media files after X days/months (/uploads/fancy_products_uploads)
2, Clear the database after X days/months (especially _fpd_data stored in woocommerce_order_itemmeta as it causes a lot of data)
3, Optional: Connecting the frontend user upload with AWS S3 or similar
Thanks!
9 Votes
rady kal posted
over 2 years ago
AdminBest Answer
This process can be done without any new feature to the plugin.
1. We do the same on our servers with Cron-Jobs. Most provider are providing Cron-Jobs which are running linux commands in a specific time interval. For example you can use this command:
Orders in WooCommerce are custom post types. As soon as you delete an order, it will also delete the related order item meta data.
0 Votes
3 Comments
Sorted by
C
CHRiSposted
over 1 year ago
Hello everyone, hello rady kal,
The immense database size affects us a lot and unfortunately this often leads to crashes in our shop. Which of course is very annoying!
Is there now a solution to reduce the size of the database or at least to control it?
We, like probably many others, would be very grateful if the problem could be taken up again.
Thank you very much, best regards Chris
0 Votes
d
dozeposted
over 2 years ago
I'm pretty sure all are familiar of the related discussion, but here's a link just in case:
https://support.fancyproductdesigner.com/support/discussions/topics/13000022983/page/1?url_locale=
It is not so simple as just use plugin to delete old orders. Then you will loose all statistics and details about old orders.
The feature request is to have possibility to clear FPD data in old orders. There is no plugin for that.
FPD should have some maintenance routine available to have it clear FPD data from orders that are older than certain date.
0 Votes
rady kalposted
over 2 years ago
AdminAnswer
This process can be done without any new feature to the plugin.
1. We do the same on our servers with Cron-Jobs. Most provider are providing Cron-Jobs which are running linux commands in a specific time interval. For example you can use this command:
WORDPRESS WooCommerce
Regarding different discussions here and after my own research for a solution reducing space on the server:
1, Delete media files after X days/months (/uploads/fancy_products_uploads)
2, Clear the database after X days/months (especially _fpd_data stored in woocommerce_order_itemmeta as it causes a lot of data)
3, Optional: Connecting the frontend user upload with AWS S3 or similar
Thanks!
9 Votes
rady kal posted over 2 years ago Admin Best Answer
This process can be done without any new feature to the plugin.
1. We do the same on our servers with Cron-Jobs. Most provider are providing Cron-Jobs which are running linux commands in a specific time interval. For example you can use this command:
This will delete all files in the folder directory that are older than 15 minutes. Here some tutorials about Cron Jobs:
2. There are third-party plugins that allows to delete specific post types which are older than a specific date.
Orders in WooCommerce are custom post types. As soon as you delete an order, it will also delete the related order item meta data.
0 Votes
3 Comments
CHRiS posted over 1 year ago
Hello everyone, hello rady kal,
The immense database size affects us a lot and unfortunately this often leads to crashes in our shop. Which of course is very annoying!
Is there now a solution to reduce the size of the database or at least to control it?
We, like probably many others, would be very grateful if the problem could be taken up again.
Thank you very much, best regards Chris
0 Votes
doze posted over 2 years ago
0 Votes
rady kal posted over 2 years ago Admin Answer
This process can be done without any new feature to the plugin.
1. We do the same on our servers with Cron-Jobs. Most provider are providing Cron-Jobs which are running linux commands in a specific time interval. For example you can use this command:
This will delete all files in the folder directory that are older than 15 minutes. Here some tutorials about Cron Jobs:
2. There are third-party plugins that allows to delete specific post types which are older than a specific date.
Orders in WooCommerce are custom post types. As soon as you delete an order, it will also delete the related order item meta data.
0 Votes
Login or Sign up to post a comment