Delete abandoned carts in bulk

  • Resolved divijc

    (@divijc)


    7 years, 3 months ago

    Hi, I have more than 10,000 abandoned carts showing up in my store.

    1. Is there any way to delete carts in bulk?

    2. Also, is there any way to automatically remove abandoned carts after a certain number of days?

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Contributor chetnapatel

    (@chetnapatel)

    Hi,

    1) For Bulk Action:

    No, it is not possible to delete 10,000 abandoned carts in bulk. Our plugin does have the Bulk action functionality. But it can be deleted 30 Abandoned Carts in bulk.

    I can understand it is difficult to delete 10K carts by manually. So you can run the SQL query in the Database to delete those carts. If you want to delete it using database then I can provide you MySQL query to delete abandoned carts.

    2) Automatically delete the carts:

    Currently, it is not possible in the Abandoned Cart Lite to automatically delete the abandoned carts after a number of days.

    I would like to let you know that we are providing the same feature in our Abandoned Cart PRO plugin. We do have the setting named as “Automatically Delete Abandoned Orders after X days” for automatically delete the records of the abandoned cart from Abandoned Orders tab after the days which you will set in the setting.?

    Please check the screenshot: https://www.screencast.com/t/fw0clTaR4

    Please let me know.

    Regards,
    Chetna Bhutka

    Hi,

    I have around more than 8000 abandoned carts in the plugin database for our ecommerce website. One option to delete the database will be to uninstall the plugin and install it again but it will be not be feasible to do this every month. So I am thinking of deleting the data from the database.
    Can you provide me with the query so that I can delete the abandoned carts from the database?

    Plugin Contributor chetnapatel

    (@chetnapatel)

    Hi,

    For deleting carts 8000 abandoned carts, please run below query in the “wp_ac_abandoned_cart_history_lite” table of the database.

    DELETE FROMwp_ac_abandoned_cart_history_lite

    I am sharing the screenshot with this. As quotes are not being added with SQL queries.

    Screenshot: https://www.screencast.com/t/1Mq1fluQFD

    Please make sure that if the site has a different prefix than “wp_” for “wp_ac_abandoned_cart_history_lite” table name then you need to change that prefix with ‘wp_’ for the table name.

    Please let me know the result

    Note:

    Please take the backup of the database before running the SQL query in the Database.

    We highly recommend that you take the full backup before running any manual query directly on the database. I hope you can understand my concern for your site.

    Regards,
    Chetna Bhutka

    • This reply was modified 7 years, 1 month ago by chetnapatel.
Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Delete abandoned carts in bulk’ is closed to new replies.