Huge table ac_abandoned_cart_history_lite

Hi @fernandot,

Our plugin has an option “Automatically Delete Abandoned Orders after X days” which will automatically delete abandoned cart orders after X days. Can you please tell me what value you have set for this option?

The setting “Automatically Delete Abandoned Orders after X days” is located at WooCommerce -> Abandoned Carts -> Settings -> General -> Settings. Kindly set the value for this option to 365 first, so that will delete a major chunk of the records from the database table.

Once these records get removed from your site, we recommend you to set a lesser value like 30/60/90 days to this option so the abandoned carts will get removed after this period instead of being stored for such a long in the DB.

Please do the same and let me know if the table “ac_abandoned_cart_history_lite” reduces the data or not.

Hi @priyankajagtp

The value is set at 365 days, so I did set it at 90 days or less, but the table remains with the same weight (157 Mb)

Hi @fernandot,

Thank you for your reply.

We will need to troubleshoot this issue at your end. For that, we kindly request you to drop us an email at support dot tychesoftwares dot com where we can discuss this issue in detail.

Sent

Hi @fernandot,

Sorry, I just checked the above and realized that I have mistakenly shared the incorrect email address to our ticketing portal. The correct email address is support at tychesoftwares dot com

So can you please re-send the email to this correct address?