• Skip to primary navigation
  • Skip to content
  • Skip to primary sidebar
  • Skip to footer

ShivarWeb

Better Websites. SEO. Marketing. Business.

  • Home
  • Reviews
    • Business Tools
    • Domain Registrars
    • Ecommerce
    • Themes, Apps & Templates
    • Virtual Private Networks
    • Web Hosting
    • Website Builders
  • Marketing
    • Advertising & Paid Marketing
    • Analytics & Optimization
    • FAQs & Explainers
    • SEO & Content Strategy
    • Social Media & Email Marketing
    • Website Improvement
    • WordPress Tutorials
  • Guides
    • Setting Up A WordPress Website
    • Setting Up a WordPress Ecommerce Website
    • Selling On Etsy Successfully
    • Choosing The Best Ecommerce Platform
    • Choosing The Best Website Builder
    • Choosing The Best Shared Hosting
    • Resources & Recommendations
    • Coupons
  • About
  • Recent
You are here: Home / WordPress Tutorials / How To Make Bulk Edits To (Any) Content in WordPress

How To Make Bulk Edits To (Any) Content in WordPress

March 18, 2016 By Nate Shivar

How To Make Bulk Edits To (Any) Content in WordPress

I’ve had two different bosses in two different industries tell me that “if a task feels tedious then you’re using the wrong tools.”

And that is especially true with auditing, editing and implementing website changes.

Here’s an all too common scenario – you’re a marketer or website owner in charge of a large-ish website running WordPress. Unlike website software in the past, you can make content changes to your website. But it is still all too tedious.

If you have no developer resources and no MySQL skills, the best option you have is opening a bunch of pages in new tabs. Sometimes a plugin like Yoast SEO will include “bulk edit” options, but even then, it’s not very fast.

Yoast Bulk Changes

When I say “bulk edits” – I mean taking spreadsheet data, uploading it, and editing dozens to thousands of pages at once.

And that is what this tutorial is all about. Here’s a few common scenarios where you can use this technique –

  • Bulk title tag changes
  • Bulk meta descriptions changes
  • Changing post headlines
  • Editing content text to reflect a rebrand
  • Bulk adding a bunch of pages
  • Editing product content
  • Editing tags and category data

Basically anything else limited to your imagination where you’d otherwise need to open pages in WordPress and manually edit.

What You’ll Need

A general understanding of post_id in WordPress. The post_id field in WordPress is literally the ID number of every post/page you have in your WordPress database. Even though everything about a given post/page might change, the post_id always stays the same. If you are adding pages/posts in bulk, you’ll need to create these and make sure they are different than the ones you already have.

Post_ID’s are usually seen in Admin panel links –

Post ID in WordPress

Access to phpMyAdmin. phpMyAdmin is located in your hosting account. It allows direct access to your WordPress database.

Your spreadsheet software of choice AND LibreOffice. Excel and Google Sheets are great, but you’ll need to format your CSV file in a certain way for upload. Grab a copy of LibreOffice to make this simple.

The Really Simple CSV plugin. This plugin will allow you to upload your CSV file within WordPress and will match up & override database fields with your edits. Grab it here.

A backup of your WordPress database. Please, please do not attempt this without a backup of your WordPress database. If something goes wrong, you’ll need to import your old database back in via phpMyAdmin.

Step 1. Get your current content in spreadsheet form

To start, you need to get all page data from WordPress. You’ll have to get it directly from the database since post_id usually is not public or crawlable.

Go to phpMyAdmin.

phpMyAdmin

Locate your database.

Database Table

Locate your WP_Posts for changes to content

  • If you want to edit categories or tags, look at the terms and taxonomy tags.
  • If you want to edit content meta (like Yoast SEO changes) – also locate the _PostMeta table.
  • If you want to bulk edit content from other plugins like WooCommerce, BuddyPress, etc, look for their relevant database tables.

Export the table to CSV with column names.

CSV Export

Step 2. Clean Up Your CSV

You’ll notice that your CSV file is a bit cluttered. You’ll need to use your spreadsheet software of choice to delete and clean-up the sheet.

The key is to leave the Post_ID column in place, plus a column that will help you recognize what post is what (ie, post title) and the post_type field to distinguish between posts, pages, and any other content types you have.

If you also downloaded another table, such as the _PostMeta table, you can use the PostID to match up the SEO Titles via VLOOKUP.

Meta Post ID

If you want to add new content, then go ahead and assign a Post_ID that does not already exist.

If the column that you want to edit is already there, then leave it and skip to the next step. If it’s not, you’ll need to add a new column header. Here are the default database headers that you can add –

  • post_author: (login or ID) The user name or user ID number of the author.
  • post_date: (string) The time of publish date.
  • post_content: (string) The full text of the post.
  • post_title: (string) The title of the post.
  • post_excerpt: (string) For all your post excerpt needs.
  • post_status: (‘draft’ or ‘publish’ or ‘pending’ or ‘future’ or ‘private’ or custom registered status) The status of the post. ‘draft’ is default.
  • post_password: (string) The password to protect the post. The password is limited to 20 characters.
  • post_name: (string) The slug of the post.
  • post_parent: (int) The post parent id. Used for page or hierarchical post type.
  • menu_order: (int)
  • post_type: (‘post’ or ‘page’ or any other post type name) (required) The post type slug, not labels.
  • post_thumbnail: (string) The uri or path of the post thumbnail. E.g. http://example.com/example.jpg or /path/to/example.jpg
  • post_category: (string, comma separated) slug of post categories
  • post_tags: (string, comma separated) name of post tags
  • tax_{taxonomy}: (string, comma separated) Any field prefixed with tax_ will be used as a custom taxonomy. Taxonomy must already exist. Entries are names or slugs of terms.
  • comment_status: (‘closed’ or ‘open’) Default is the option ‘default_comment_status’, or ‘closed’.

Note: Empty cells in the csv file means “keep it”, not “delete it”.

Note: To set the page template of a page, use custom field key of _wp_page_template.

If you are an SEO using Yoast SEO for WordPress – here’s the database headers you can work with –

  • _yoast_wpseo_focuskw – use to define your target/focus keyword in Yoast.
  • _yoast_wpseo_title – use to define your title tag for that page.
  • _yoast_wpseo_metadesc – use to define your meta description on that page.
  • _yoast_wpseo_primary_category – use to define your primary category for breadcrumbs.
  • _yoast_wpseo_canonical – use to define your canonical.
  • _yoastwpseo_meta-robots-noindex – use to define if it’s a NOINDEX page (1 is yes value)
  • _yoastwpseo_meta-robots-nofollow – use to define if it’s a NOFOLLOW page (1 is yes value)

To find other fields for other plugins, navigate through your database to find the field you’re looking for. Note the value to figure what the right value looks like. You can also download the Really Simple CSV sample CSV.

Edit Fields

Sample CSV

Step 3. Make Your Changes & Format Correctly

An Excel / Google Sheets tutorial is out of the scope of this post. But at this point, you’ll need to get the changes you want in all the right rows / columns.

Formatting in Excel

Then, save the file as a CSV.

Next, open up the file with LibreOffice. Then, re-save as a CSV with the following conditions –

1. Select UTF-8 as charset.
2. You must use field delimiter as “,”
3. You must quote all text cells.

CSV Settings

Step 4. Upload via Really Simple CSV

Install Really Simple CSV if you have not already.

Go to your WordPress Dashboard → Tools → Import → CSV

Upload your CSV file.

Upload

Then audit a sampling of your pages or use a crawler like Screaming Frog to quickly look at all your pages.

Enjoy the feeling of incredible productivity.

Video Walkthrough

Next Steps

Decide if you need to make bulk changes to WordPress. Scroll back up to the What You’ll Need and get everything in order.

Note for marketers with larger websites – it’s usually not ideal to do a “hot fix” on a production (ie, live site). Ask your developer if you have a staging site that you can upload and test changes before “pushing” the changes live.

Otherwise, you may want to create a local or demo site to test this out before making hundreds of database edits to your live site.

Last note – if you are on a shared server, be careful about uploading too many changes at once. At best, your upload will timeout. At worst, you’ll crash your server like I did trying to edit 10,000 pages at once. Check your server limits and consider breaking your CSV into smaller chunks.

Found this post useful? Link to it on your resources or roundup page or share it with the share buttons!

Related posts:

  1. How To Turn Off Comments in WordPress
  2. How To Work With The WordPress Media Library
  3. How To Work With Images in WordPress
  4. How To Use WordPress Posts + Pages (step by step)

Filed Under: WordPress Tutorials

About Nate Shivar

I'm Nate Shivar - a marketing educator, consultant, and formerly Senior SEO Specialist at a marketing agency in Atlanta, GA. I try to help people who run their own websites...run them a little better. I like to geek out on Marketing, SEO, Analytics, and Better Websites.

Thanks for reading!

Primary Sidebar

The Author / Editor!

Nate ShivarI’m Nate Shivar – a marketing educator, consultant, and formerly Senior SEO Specialist at a marketing agency in Atlanta, GA. I try to help people who run their own websites…run them a little better. I like to geek out on Marketing, SEO, Analytics, and Better Websites.

See Nate Shivar's Twitter

Read More About Nate…

Topics

Marketing
  • Advertising & Paid Marketing
  • Analytics & Optimization
  • SEO & Content Strategy
  • Social Media & Email Marketing

 

Reviews
  • Business & Productivity Reviews
  • Domain Registrar Reviews
  • Ecommerce Platform Reviews
  • Themes, Apps & Templates
  • Virtual Private Network Reviews
  • Web Hosting Reviews
  • Website Builder Reviews

 

Web Design
  • FAQs & Explainers
  • Website Improvement
  • WordPress Tutorials

Popular Posts

Reviews
  • Shopify Review: Pros & Cons of Using Shopify For eCommerce
  • Namecheap or GoDaddy? Where To Get Your Website Domain Names
  • Bluehost vs. GoDaddy: Who To Choose For Web Hosting?
  • InMotion Hosting Review: 6 Pros & 4 Cons of InMotion Hosting
  • Wix Review: 6 Pros & 6 Cons of Using Wix For Websites
  • Squarespace Review: 5 Pros & 4 Cons of Using Squarespace
  • Weebly Review: 6 Pros & 3 Cons of Using Weebly For Your Website

 

Marketing
  • How To Advertise Your Website Online Effectively in 5 Steps
  • How To Advertise On Reddit: My Experience & 9 Ideas for Advertising on Reddit
  • Beginner’s Guide To Using Yoast WordPress SEO Plugin
  • How To Use Keywords On Your Website: Guide to Keyword Mapping for SEO
  • How To Use Google Search Console Effectively
  • Ahrefs Guide: How To Use Ahrefs for SEO, Content & Link Building

Search!

FTC Disclosure

I receive customer referral fees from companies mentioned on this website. All data & opinions are based on my experience as a paying customer or consultant to a paying customer.

Footer

Featured Pages

Home
About
Blog
Resources
How To Set Up A WordPress Website
Set Up A WordPress Ecommerce Website
Guides, Quizzes & Comparisons
Web Hosting Reviews
SEO & Content Strategy
Privacy Policy

Featured WordPress Resources

  • How To Use WordPress Category & Tag Pages for SEO
  • Shopify vs. WooCommerce & WordPress: Differences & Using Them Together
  • Wix vs. WordPress (Self-hosted .org & WordPress.com)
  • How To Use The WordPress Dashboard + Initial Settings

Howdy! No Infinite Scroll Here :)

Recent Blog Posts

  • Website Builders Explained
  • Website Hosting Explained
  • Namecheap or GoDaddy? Where To Get Your Website Domain Names
  • Squarespace vs. Weebly vs. Wix: Website Builder Comparison

Copyright © 2019 · Have a lovely day!