WordPress.org

Ready to get started?Download WordPress

Forums

Easy Digital Downloads
[resolved] Completely Delete all Data from the DB (9 posts)

  1. nikoza
    Member
    Posted 12 months ago #

    Hello and thanks for the great plugin.

    I am using it in a site that gets a lot of traffic and I have both free and paid downloadable products. I want to keeping all the data for security and performance reasons out of the db.

    I noticed that all purchases are stored in the xx_posts table. How can I delete all the data stored in the db. I am not interested in any kind of reporting from the plugin as I do custom reports from my spreadsheets.

    I cannot seem to find any button that totally deletes everything.

    Is there something like that. If not what should I do?

    Regards,
    Nick

    http://wordpress.org/extend/plugins/easy-digital-downloads/

  2. Pippin Williamson
    Pippin's Plugins and Plugin Reviewer
    Plugin Author

    Posted 11 months ago #

    Do you mean that you want to periodically delete the data, or that you need to delete all of the data just one time?

  3. nikoza
    Member
    Posted 11 months ago #

    Hello Pippin,

    I would love to have a button in the options somwhere to delete everything from the DB and once every few days (manual click will be fine) but if it is not available any other custom solution I could use right now it will be just fine.

    Thank you

  4. Pippin Williamson
    Pippin's Plugins and Plugin Reviewer
    Plugin Author

    Posted 11 months ago #

    That will only be possible if you build it yourself, since it is pretty far outside of what a typical EDD user would need.

    If you're able to build it yourself, I can tell you to the data to remove.

  5. nikoza
    Member
    Posted 11 months ago #

    Hello Pippin,

    I really don't believe that it is that far. I think many more than just be might be interested in keeping the db lighter. I assume that this will also increase the loading of the site.

    Let's hope that I will be able to build it amd maybe as a plugin to release later. I think it will make a good one.

    Can you please tell me where in the db should I look?

    Regards,
    Nick

  6. Pippin Williamson
    Pippin's Plugins and Plugin Reviewer
    Plugin Author

    Posted 11 months ago #

    The increased size of the DB doesn't impact site load time, not unless you have a plugin that is behaving improperly.

    Data you'd need to remove:

    From wp_posts: all items with the post_type = edd_payment
    From wp_postmeta: all items connected to the edd_payments items. Related by post_id.

    From wp_posts: all items with the edd_log post type
    From wp_postmeta: all items connected to the edd_log items, related by post_id.

  7. Pippin Williamson
    Pippin's Plugins and Plugin Reviewer
    Plugin Author

    Posted 11 months ago #

    FYI: when you delete payments, the file downloads associated with the purchases will fail.

  8. nikoza
    Member
    Posted 11 months ago #

    Hello Pippin,

    Thank you for your help.
    I was away for a few days with now stable internet connections.

    I am about to finish the first version of the plugin that deletes purchases but I am confused of factors that I may have missed. Would you be interested in taking a look?

    Thank you again,
    Nick

  9. Pippin Williamson
    Pippin's Plugins and Plugin Reviewer
    Plugin Author

    Posted 11 months ago #

    Sure!

Reply

You must log in to post.

About this Plugin

About this Topic

Tags

No tags yet.