Optimize Database and Delete Older transaction for User

  • Resolved Mehrshad Darzi

    (@mehrshaddarzi)


    4 days, 15 hours ago

    I have a WooCommerce site with about 25000 users.
    The wp_woo_wallet_transactions table in my database has taken up approximately 4 GB of space.
    Please give me a script that only shows the last 10 transactions per user and completely deletes other row , so that my database gets optimized.
    Based on my analysis, the system calculates the wallet balance by summing all records, so I want you to provide a script that does not break the plugin’s mechanism.”

Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter Mehrshad Darzi

    (@mehrshaddarzi)

    4 days ago

    I suggest adding a transaction archiving in plugin option.
    When disabled, the system should automatically keep only the last 10 transactions per user in the database and delete all older ones. Additionally, the full transaction report page should be hidden from the wooCommerce user menu

    Plugin Author Subrata Mal

    (@subratamal)

    3 days, 1 hour ago

    @mehrshaddarzi You can delete all user transactions using the bulk actions feature on the wallet transaction page.

    Thread Starter Mehrshad Darzi

    (@mehrshaddarzi)

    2 days, 22 hours ago

    1. Doesn’t this change the user’s wallet balance?
    2. Do you mean this page? [/wp-admin/?page=woo-wallet-transactions&user_id=209191]
Viewing 3 replies - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.