Delete Duplicate Posts

Description

This plugin searches and removes duplicate posts and their meta data.

You can delete posts, pages and other Custom Post Types enabled on your website.

The plugin deletes not only the post, but post meta and other references to the post, cleaning up space in your WordPress website.

Features

  • Select individual posts to delete or select all.
  • Manual or automatic deletion
  • Keep oldest or newest version.
  • Get status email when something is deleted.
  • Integrated log shows all activity.

Read more on the plugin page on cleverplugins.com.

Screenshots

  • Duplicate posts were found.
  • Details in the log.
  • Settings in free version

Installation

  1. Upload the delete-duplicate-posts folder to the /wp-content/plugins/ directory
  2. Activate the Delete Duplicate Posts plugin through the \’Plugins\’ menu in WordPress
  3. Use the plugin by going to Tools -> Delete Duplicate Posts

FAQ

Should I take a backup before using this tool?

Yes! You should always take a backup before deleting posts or pages on your website.

What happens if it deletes something I do not want to delete?

You should restore the backup you took of your website before you ran this tool.

Reviews

October 27, 2021
First of all I am giving it 5 stars because from a Product Catalogue with 25K products, I found and deleted easily almost 6K products. But, I received this message from my host: Composer detected issues in your platform: Your Composer dependencies require a PHP version ">= 7.3.0". You are running 7.2.34. PHP Fatal error: Composer detected issues in your platform: Your Composer dependencies require a PHP version ">= 7.3.0". You are running 7.2.34. in /var/www/vhosts/domainName/httpdocs/wp-content/plugins/delete-duplicate-posts/vendor/composer/platform_check.php on line 24 PHP version of the server is 7.4.25
October 12, 2021
My site had a LARGE number of custom posts (150K+) that we had imported. During the import, duplicates were created to the tune of almost 40K posts. I set up the plugin to run in automated mode knocking off 100 posts every 30 mins. It took a LONG time - weeks - but it did the job without bringing down the server or corrupting the db. All while still permitting front and back-end access. I played around with the config settings to get to the sweet spot for the number of posts to delete at one time and the correct repeat cycle. It paid off. Well done folks.
September 13, 2021
The plugin is really helpful, deleted 1600 duplicates from 200000 products from our store. Many thanks to the developer!
Read all 83 reviews

Contributors & Developers

“Delete Duplicate Posts” is open source software. The following people have contributed to this plugin.

Contributors

“Delete Duplicate Posts” has been translated into 1 locale. Thank you to the translators for their contributions.

Translate “Delete Duplicate Posts” into your language.

Interested in development?

Browse the code, check out the SVN repository, or subscribe to the development log by RSS.

Changelog

4.7.4

  • 2021/10/27
  • Fix bug with Composer dependencies for PHP less than 7.3

4.7.3

  • 2021/10/15
  • Fix problem with deleting old log entries in database.

4.7.2

  • 2021/09/30
  • Fix problem with log database not being created automatically.
  • Added button in sidebar to recreate missing database tables.

4.7.1

  • 2021/07/21
  • Security Hardening

4.7

  • 2021/07/11
  • FIX: Duplicates not always properly detected, thank you for the reporters to help fix this bug 🙂
  • NEW: Improved and faster lookup of duplicates.
  • NEW: See number of posts per post type.
  • NEW: See peak memory usage in the log.
  • NEW: See combined count by post_status in the log.
  • NEW: If there is a problem looking up duplicates in the database (shared servers have limited resources), the problem will be shown in the log.
  • Updated language files.
  • Tested up to WP 5.8

4.6.2

  • 2021/04/14
  • Updated 3rd party libraries for PHP 8
  • Tested up to WP 5.7
  • Minor bugfixes
  • 303,187 downloads

4.6.1

  • 2020/01/12
  • Hotfix – “The plugin generated 15 characters of unexpected output during activation” – Thanks Fabio.

4.6

  • 2020/01/12
  • Beta feature: Limit amount of duplicates to find. On big sites with many duplicates the plugin can time out. This feature allows you to limit the amount of results. This feature is only available for free while being tested. Thank you Fabio.
  • Minor text or layout fixes.
  • 286,392 downloads

4.5

  • 2021/01/11
  • New: Manually select which duplicates to delete (or use the automatic)
  • Fix: WordPress 5.6 jQuery compatibility.
  • Fix: Not allowing to disable final post status if only one left. Thank you @nd62.
  • Work on improving PHP 8 compatibility.
  • Updated 3rd party libraries to latest version. Freemius v. 2.4.1
  • 283,070 downloads

4.4.8

  • 2020/11/30
  • Fix bug with email not sending. Thank you Fatih.
  • 272,622 downloads

4.4.7

  • 2020/11/09
  • Introducing Multisite compatibility
  • Updated 3rd party Freemius library to v. 2.4.1
  • Tested with WordPress 5.5.3
  • 265,176 downloads

4.4.6

  • 2020/08/06
  • Code cleanup
  • Tested with WordPress 5.5
  • Updated SDK Freemius to 2.4.0.1
  • 250,931 downloads

4.4.5

  • 2020/07/06
  • Fix – automatically deactivate free version if pro version is activated – Thank you Jordi.
  • Fix – Missing link to privacy data.
  • Fix – Not correctly identifying original post when comparing with post meta values – Thank you Reinhard.
  • New – more details how long a process took is now stored in the log.
  • 242,749 downloads

4.4.4

  • 2020/06/08
  • Code cleanup and security hardening.
  • 235,094 downloads

4.4.3.1

  • 2020/05/08
  • Removes some debug code, whoopsie.
  • 227,615 downloads

4.4.3

  • 2020/05/07
  • Plugin now looks for duplicates in posts and pages per default, no need to set it after activating plugin.
  • Fix: “Error deleting post” showing even if the post was deleted. Thank you Murray 🙂
  • The log is now updated when list of duplicates is updated.
  • 225,725 downloads

4.4.2

  • 2020/05/04
  • Fixing activation bugs – Thank you @locutus45 and @paul1427
  • Fixing code not working with PHP 5.6
  • Fixed missing translation strings – Thank you Canny for translating to Korean! 😀
  • Added automatic reload when manually deleting duplicates.
  • 222,012 downloads

4.4.1

  • 2020/05/03
  • Fixing bug in install routines
  • 219,984 downloads

4.4

  • 2020/05/02
  • Tested up to WP 5.4.1
  • Pro: Choose different post stati to look for; publish, draft, scheduled, pending, private and any other custom post status.
  • Code improvement, works faster.
  • 218,123 downloads

4.3

  • 2020/04/25
  • Rewrote plugin to better handle big sites with lots of duplicate content.
  • Fixed automatic deletion (cron job) not working properly on some sites.
  • Security fixes and hardening throughout the plugin.
  • Log is now AJAX based to help load on big sites.
  • Duplicate list now loads via AJAX to help with load on big sites.
  • Added inline help – Helpscout
  • Updated Freemius 3rd party SDK to 2.3.2
  • Added option to upgrade to Pro version.
  • Updated language files.
  • Removed option to run every minute – Sorry, but not a good idea for many websites and hosting companies do not like it either.
  • 213,367 downloads

4.2.1

  • Direct link to support forum
  • Fixed missing file in 3rd party SDK.

4.2

  • Fix – the limitation on how many posts were deleted per batch did not always work, it does not.
  • PHP notices removed from the log thank you @brianbrown

4.1.9.5

  • Security fix

4.1.9.4

  • Added two more intervals, every minute and every 5 minutes.
  • Updated 3rd party script Freemius

4.1.9.3

  • Fixed bugs introduced with updating to WordPress 4.9.1 – Thank you to all who reported the problem.

4.1.9.2

  • Fixed esc_sql() for WordPress 4.8.3

4.1.9.1

  • Fix missing 3rd party scripts.

4.1.9

  • Optimized delete routines – Thank you Claire and Vaclav 🙂 Up to 20-30% faster deleting.
  • Added timing functions so you can see how long it takes to delete in the log.
  • Permanently delete posts and pages – no longer goes to trash.
  • Fix – The log is now shown with latest events at top.
  • Updated 3rd party scripts – Freemius update 1.2.1.7.1 to 1.2.2.9

4.1.8

  • Updated Freemius SDK.
  • Fixing problem with keeping latest or oldests posts.

4.1.7

  • Fixed PHP Notification – Logs were not automatically cleaned.

4.1.6

  • Fixed missing icon
  • Listed freemius as contributer

4.1.5

  • Fixing PHP Warning if no post types selected

4.1.3

  • Fixed a mistake in Freemius configuration :-/

4.1.2

  • Added language .pot file
  • Improved Danish translation
  • Added Fremius for more usage details – Opt-in

4.1.1

  • Fix PHP notices
  • Clean up code comments
  • Logo now in Retina

4.1

  • Fixes which kinds of posts that can be cleaned- Thanks Mark – https://cleverplugins.com/support/topic/delete-duplicate-post-of-a-different-post-type/
  • Option up from max 250 posts to 500 – Thanks Mark.
  • Improved visual style in the table listing.

4.0.2

  • Fixes problem with cron job not working properly.
  • New: Choose interval for automated cron job to run.
  • Adds 3 cron interval 10 min, 15 min and 30 minutes to WordPress.
  • Minor PHP Notice fix.
  • Code cleaning up

4.0.1

  • Added log notes for cron jobs and manual cleaning.
  • Added missing screenshots, banners and icons.

4.0

  • Big rewrite, long overdue, many bugs fixed
  • NEW: Choose between post types.
  • Optional cron job now runs every hour, not every half hour.
  • The log was broken, it has now been fixed.
  • Removed unused and old code.
  • Improved plugin layout.

3.1

  • Fix for deleting any dupes but posts – ie. not menu items :-/
  • Fix for PHP warnings.
  • Fix for old user capabilities code.

3.0

  • Code refactoring and updates – Basically rewrote most of the plugin.
  • Removed link in footer.
  • Removed dashboard widget.
  • Internationalization – Now plugin can be translated
  • Danish language file added.

2.1

  • Bugfixes

2.0.6

  • Bugfix: Problem with the link-donation logic. Hereby fixed.

2.0.5

  • Bugfix: Could not access the settings page from the Plugins page.
  • Ads are no longer optional. Sorry about that 🙂
  • Changes to the amount of duplicates you can delete using CRON.

2.0.4

  • Bugfix : A minor speed improvement.

2.0.3

  • Bugfix : Minor logic error fixed.

2.0.2

  • Bugfix : Now actually deletes duplicate posts when clicking the button manually.. Doh…

2.0

  • Design interface updated
  • New automatic CRON feature as per many user requests
  • Optional: E-mail notifications

1.3.1

  • Fixes problem with dashboard widget. Thanks to Derek for pinpointing the error.

1.3

  • Ensures all post meta for the deleted blogposts are also removed…

1.1

  • Uses internal delete function, which also cleans up leftover meta-data. Takes a lot more time to complete however and might time out on some hosts.

1.0

  • First release