How to bulk edit WordPress posts: the built-in steps
Bulk edit WordPress posts without a plugin in five dashboard clicks: tick rows on the All Posts list, pick Edit from the Bulk actions dropdown, press Apply, set the fields, then press Update. The whole sweep runs on one screen.
- Open Posts → All Posts and raise the screen option to show all targets on one page.
- Select posts via checkboxes — the top checkbox takes the current page only, not the entire archive.
- Choose Bulk actions → Edit → Apply; the bulk panel appears above the list.
- Change status, categories, tags, author or comment settings.
- Click Update — every selected post receives the change at once.
The screen paginates at whatever you set. The list defaults to 20 items per page; the Screen Options tab in the top-right corner accepts up to 999 per page (WPMU DEV's walkthrough, read 30 October 2026), which is how a large archive fits into one selection. Before any major operation, take a database backup — the undo doctrine closes this guide. For SQL-level work, the cPanel MySQL database guide opens phpMyAdmin safely. For a reversible safety net before big sweeps, see the WordPress backup service. These admin chores are the daily bread of anyone managing WordPress at scale on WordPress hosting.
Quick Edit on a single WordPress post vs Bulk Edit
Quick Edit is the inline panel that opens when you hover over one row on All Posts and click the Quick Edit link under the title: title, slug, date, author, status, password/private, categories, tags, sticky, comments and pings all change in place without opening the full editor or leaving the list. It edits exactly one post at a time. Bulk Edit is the same idea across many rows at once, with a smaller field set — the two overlap on author, status, categories and tags, and Quick Edit additionally takes the slug and date that the bulk panel does not.
Bulk editing categories, tags and status in WordPress
The bulk panel sets Status — published, pending review or draft — and assigns Categories and Tags to every selected post. One limit decides how you plan the job: bulk edit only adds terms, it never removes them. That is the documented behaviour of the core function that processes the sweep, bulk_edit_posts(), which updates all bulk-edited posts "adding (but not removing) tags and categories" (developer.wordpress.org, read 30 October 2026). Removing a category from many posts therefore means editing each post, or a SQL delete through the term_relationships table after a backup.
Changing the author of multiple WordPress posts
Author is a field in the bulk panel: select the posts, choose Bulk actions → Edit → Apply, pick the new author from the Author dropdown — only users who already exist on the site and can be assigned posts appear there — and click Update. For a change spanning thousands of posts, one statement against wp_posts does it without the panel: UPDATE wp_posts SET post_author = new_user_id WHERE post_author = old_user_id; — run it after the backup, with the SELECT preview first.
Bulk editing WordPress posts at scale with phpMyAdmin SQL
When hundreds of posts need a change no panel covers — a find-replace across content, a sitewide re-key — phpMyAdmin does it in one statement instead of a hundred clicks. The safety workflow: take a dated database backup first (cPanel → phpMyAdmin → Export), run the SELECT with the same WHERE clause before every UPDATE and read the rows it names, then run the UPDATE only when the preview matches intent.
Classic jobs: UPDATE wp_posts SET post_content = REPLACE(post_content, 'old-domain.com', 'new-domain.com') WHERE post_type = 'post'; for domain migrations, or a JOIN through term_relationships for category moves. Never learn SQL on production — test on a staging clone first.
Bulk featured images and custom fields on WordPress posts
The bulk panel has no featured-image or custom-field control: the official field list for the sweep stops at author, parent page, template, comments, status, categories, tags, pings and sticky (WordPress.com support, reviewed 5 October 2026). A featured image is stored as the _thumbnail_id row in the wp_postmeta table, so setting one across many posts is either a targeted SQL/metadata job or the territory of the spreadsheet-style bulk editor plugins that advertise exactly this — pick one, and verify it on staging before a production sweep.
Undoing and avoiding WordPress bulk-edit mistakes
Bulk Edit has no undo button. Two safety nets exist: posts moved to Trash sit there for 30 days before permanent deletion and can be restored from the Trash tab until then, and a database backup taken before the sweep restores everything else — including metadata changes the trash cannot. Two core behaviours also limit the blast radius: a post currently locked by another editor is skipped, not updated, and a page that would become its own parent is skipped too (developer.wordpress.org, read 30 October 2026). Change one field at a time, check the result on a live post, then continue.
Frequently Asked Questions
How do I bulk edit posts in WordPress?
Open Posts → All Posts, tick the checkboxes of the posts to change, choose Bulk actions → Edit and press Apply, set the fields in the panel that appears, then press Update. Every selected post gets the change in one pass.
Can I change categories of many posts at once?
Yes — the bulk panel assigns categories and tags to every selected post. Note the limit: it only adds terms, it never removes them (that is the documented behaviour of bulk_edit_posts() in core). Removing a category from many posts takes per-post edits or SQL through term_relationships.
How do I bulk delete old WordPress posts?
Filter the All Posts list to the posts you want gone (by date or category), tick them, choose Bulk actions → Move to Trash and press Apply. Trashed posts stay recoverable in the Trash tab for 30 days; Delete Permanently or Empty Trash removes them for good. Take a backup before large sweeps.
How do I change the author of multiple posts?
Select the posts, choose Bulk actions → Edit → Apply, pick the new author in the Author dropdown — the user must already exist on the site — and click Update. For thousands of posts, UPDATE wp_posts SET post_author = new_id WHERE post_author = old_id does it in one statement, after a backup.
What does Quick Edit do in WordPress?
Quick Edit is the inline panel that appears when you hover a row on All Posts: title, slug, date, author, status, password, categories, tags, sticky and comment settings change in place without opening the full editor. It edits one post at a time; Bulk Edit is the same idea across many rows.
Can I bulk edit posts without a plugin using SQL?
Yes. phpMyAdmin (cPanel → phpMyAdmin) runs changes the dashboard cannot: a content find-replace with UPDATE wp_posts SET post_content = REPLACE(...), an author swap on post_author, category moves through term_relationships. Take a dated database backup, preview with the SELECT using the same WHERE clause, then run the UPDATE. Test on staging first.
Is WebJi® an Indian company?
Yes. WebJi® is headquartered in Jaipur, Rajasthan and has operated since 2005. Billing, support and governance all run from India.
Do you provide GST invoices?
Every purchase and renewal gets a GST invoice with our GSTIN, and hosting prices are quoted exclusive of 18% GST. Claim input credit as applicable.