Overhaul WordPress Comment System
Budget: €10,000 – €20,000 EUR
I’m sitting on a WordPress site with a lively readership but a comment backend that’s buckling under 4,000 items in the moderation queue. Real discussion is drowning in spam and our editors no longer bother opening the queue. I’ll provide you a database export of the entire comment table so you can work against the real data, not a sanitized sample.
What I need from you is a complete rescue of the comment system:
• Bulk triage: a reliable, repeatable method—scripted or plugin-based—to sort the existing queue into publish / delete / needs-review buckets so we can clear it once and move forward. Please outline the rules or machine-learning approach you plan to use so the outcome is defensible.
• Ongoing spam protection that’s invisible to genuine readers. I’m fine with services or custom logic, but no “prove-you’re-human” hurdles every time someone posts.
• Usability upgrades: threaded replies, the ability for commenters to edit their post for a short window, and email alerts when someone replies (with a one-click unsubscribe link that works).
• Lightweight moderation tools our small team can keep up with: inline approval/reject, quick view of commenter history, and a simple “report” button that funnels flagged posts into their own queue. A block/ban action needs to stop repeat offenders at the source.
• Advice we can trust: recommend plugins, custom code, or a hybrid solution—whatever best fits WordPress today. If a detour into custom PHP or an external API makes sense, let me know the pros and cons.
• Performance awareness: the comment table is already huge; any new indexes or schema tweaks must keep page loads snappy.
Hand-off expectations
1. Cleared queue with a log of actions taken.
2. Documented anti-spam and moderation workflow we can follow.
3. Deployed and tested features (staging first, then live) with rollback instructions.
4. Short screencast or step-by-step guide for editors.
If you’ve previously tamed large WordPress comment databases and can show real-world spam-fighting wins, you’ll be a great fit.
What I need from you is a complete rescue of the comment system:
• Bulk triage: a reliable, repeatable method—scripted or plugin-based—to sort the existing queue into publish / delete / needs-review buckets so we can clear it once and move forward. Please outline the rules or machine-learning approach you plan to use so the outcome is defensible.
• Ongoing spam protection that’s invisible to genuine readers. I’m fine with services or custom logic, but no “prove-you’re-human” hurdles every time someone posts.
• Usability upgrades: threaded replies, the ability for commenters to edit their post for a short window, and email alerts when someone replies (with a one-click unsubscribe link that works).
• Lightweight moderation tools our small team can keep up with: inline approval/reject, quick view of commenter history, and a simple “report” button that funnels flagged posts into their own queue. A block/ban action needs to stop repeat offenders at the source.
• Advice we can trust: recommend plugins, custom code, or a hybrid solution—whatever best fits WordPress today. If a detour into custom PHP or an external API makes sense, let me know the pros and cons.
• Performance awareness: the comment table is already huge; any new indexes or schema tweaks must keep page loads snappy.
Hand-off expectations
1. Cleared queue with a log of actions taken.
2. Documented anti-spam and moderation workflow we can follow.
3. Deployed and tested features (staging first, then live) with rollback instructions.
4. Short screencast or step-by-step guide for editors.
If you’ve previously tamed large WordPress comment databases and can show real-world spam-fighting wins, you’ll be a great fit.
Related categories:
PHP
Web Security
WordPress
MySQL
Usability Testing
Data Analysis
Database Management
API Integration