Revamp Your 2023 Blog Content for 2024: A Step-by-Step Guide to Bulk Updating

As we usher in 2024, keeping your digital content up-to-date is more crucial than ever.

Disclosure: We might receive commission on purchases made through links on this page. Learn more.

Particularly for WordPress users, refreshing your blog posts, pages, or WooCommerce product data to reflect the new year is a vital task that can seem daunting.

But fear not; with the right tools and approach, this process can be streamlined and simplified. In this article, I’ll share an efficient method to transition your content from 2023 to 2024 using two essential WordPress plugins.

This guide will provide a step-by-step process to make this transition smooth and hassle-free.

Staying current is key, especially with blog posts or WooCommerce data. Your content transition from 2023 to 2024 shouldn’t be a headache.

If you’re using WordPress, it’s surprisingly simple with just a couple of plugins:

What’s great about these two plugins is that you can buy them in a lifetime bundle of $169, covering unlimited websites.

Let me walk you through the steps to refresh your content:

1. Export All Posts Containing “2023”

First, use WP All Export to filter out posts with “2023”.

  1. Go to All Export > New Export
  2. From the dropdown menu on “Select Specific Post Type”, select “Posts”.
  3. Click “Add Filtering Options”. Here, filter the Post Title, Excerpt, SEO Title, or SEO Meta Description containing “2023”.
    1. If you’re using Yoast SEO Plugin, this is the SEO Title custom field: _yoast_wpseo_title, and this is the SEO Meta Description custom field: _yoast_wpseo_description
    2. If you’re using the Squirrly SEO plugin (like me), use the SEO Title custom field: _sq_title, and SEO Meta Description custom field: _sq_description

    The end result of the filters will be like this:
    Export All Posts

    Note: Since media files in the HTML content of posts might include 2023 in them, filtering the HTML content might be misleading. That’s why I skipped the content in this step.

  4. Click “Customize Export File” to go to the next step. Here, from the “Available Data”, drop and drag ID, Title, Excerpt, and Permalink in the “Standard” list. Get the SEO Title and Meta Description custom fields from the “Custom Fields” List.
  5. Choose “Export Type” as a CSV file.
  6. You might want to save these settings as a template for later use. Give it a name such as “All Posts Including 2023”. You’ll have a screen like this:
    Drag & Drop
  7. Click “Continue” to go to the “Export Settings” page. Basically, you don’t need to make any changes here. I give the export the same name as the export settings here.
    Export is ready
  8. Click “Save & Run Export” to start the export. The export will take about one minute.
  9. When the export is completed, download the CSV export file.

2. Replace “2023” with “2024” in the Export File

Next, import the CSV to Google Sheets and make the year update.

  1. Create a new Google Sheet by clicking here. Name the Google Sheet as “All Posts Including 2023”.
  2. File > Import > Upload the downloaded CSV file > Import Data
  3. Select the “Title” Column and open the “Find and Replace” menu with the CMD + SHIFT + H keyboard shortcut for Mac. If you’re using Windows, use CTRL + SHIFT + H.
  4. Find 2023 and replace it with 2024. Click the “Replace all” button.
    Google Sheets
  5. Repeat the same step by replacing 2023 with 2024 in the Excerpt, SEO Title, and SEO Description columns. It’s crucial not to do it across the whole Google Sheet since we don’t want to change the ID or Permalink of the posts.
  6. Download the edited data to a CSV file: File > Download > CSV.

3. Import the Updated File for Bulk Editing

Finally, use WP All Import for the updated data.

  1. WP All Import > New Import. Here, upload your updated CSV file.
  2. Select “Existing Items”, and click “Continue to Step 2”.
    New Import
  3. You don’t need to make any changes in this step. Just make sure that your data is imported properly. Click “Continue to Step 3“.
    Review import file
  4. Here, from the import file preview on the right, we’ll Drag & Drop the Title, Excerpt, SEO Title, and SEO Meta Description to the right places. There is no need to drag the other values.
  5. Give it a name such as “Replace 2023 with 2024 in posts, “ and continue to step 4.
    Drag & Drop
  6. Select “Records in this import file will be matched with Posts on your site based on…“ as “Post ID,” and Drag and drop the ID column in the import file preview on the right.
  7. On the “For each record in this import file, every time this import is run…” options, only select the options given in the screenshot below so that we’ll update only the titles, excerpts, SEO titles, and SEO descriptions of the posts. Continue to the next and final step.
    Import Settings
  8. Here, you’ll see a summary of the updates you’ll be making.
    File is all set up
  9. Just go ahead and click “Confirm & Run Import”. Based on the number of posts you’ll be updating and your server speed, It will take some time to update the posts.

Confirm & Run

Import Complete

And voila! You’ve successfully updated your content for 2024!

This method, leveraging the powerful combination of WP All Export and WP All Import plugins, demonstrates how bulk updating can be a time-saving and straightforward task.

Remember, staying current is not just about keeping up with the times; it’s about presenting your audience with the most relevant and accurate information.

By following these steps, you ensure that your digital presence remains fresh and up-to-date, reflecting the dynamism and attentiveness of your brand.

Here’s to a productive and successful 2024, with your content perfectly aligned with the new year!

Unlock solo business potentialbusiness growthcontinuous improvementfreedom to own your story
We will be happy to hear your thoughts

Leave a Reply

BizStack — Entrepreneur’s Business Stack