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

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.

🔄 Updating 2023 Articles for 2024: The Bulk Method

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:

1. WP All Export
2. WP All Import

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:
   

   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:
   
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.
   
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.
   
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”.
   
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“.
   
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.
   
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.
   
8. Here, you’ll see a summary of the updates you’ll be making.
   
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.

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.

Related:From Starbucks to Success: How Stephane Nasser Built OpenVC with Just 2 People

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