WordPress – How to Bulk Expire Posts Quickly

In this post, we’ll show you how to bulk expire WordPress posts with a few clicks.

wordpress-bulk-expire-postsThis is really useful when you’re in a hurry and have to enable post expirations for hundreds of WordPress posts. Normally, you’d have to open and edit one post at a time in the normal WordPress editor. That would take a lot of hours and thousands of clicks.

Fortunately, you can easily bulk update the post expiration settings using the WP Sheet Editor plugin. It allows you to view and edit posts, pages, and custom post types using intuitive spreadsheets inside WordPress. Editing any field of your posts is as easy as editing Excel or Google Sheet cells.

WP Sheet Editor allows you to bulk edit fields added by other plugins such as the Post Expirator plugin. The fields are added automatically and appear in the spreadsheet as columns.

Once you install and activate the WP Sheet Editor plugin, you need to install the WP Sheet Editor Post Expirator extension. This extension will make WP Sheet Editor and Post Expirator fully compatible.

After installing the plugin and the extension on your website, follow these simple steps to bulk expire WordPress posts:

1- Open the WordPress posts spreadsheet

Set up the spreadsheet: The WordPress posts spreadsheet should be automatically set up, but you can follow this guide in case you want to learn how to set it up manually; it’s really simple.

To open the WordPress posts spreadsheet, go to WP Sheet Editor > Edit Posts. You’ll see all your posts as rows and their fields as columns.

wordpress bulk expire posts

If you right-scroll in the spreadsheet, you should see the fields added by Post Expirator. However, if you can’t see them, just hover over Settings and click Scan DB to find fields.

wordpress bulk expire posts

2- Optional. Bulk edit the post expiration settings manually in the spreadsheet

If you edit the expiration date of your posts manually, you will need to open and edit each post at the same time. This is really difficult and tedious; it will take you many hours to do it if you have a lot of posts to edit.

Fortunately, with WP Sheet Editor you can edit the Post Expirator cells in hundreds of posts. This is really useful if you want to add different dates, categories and expiration methods to many posts.

As you see, we have edited the following columns:

  • Expiration date: If it’s empty, the expiration is disabled.
  • Expiration Date Options: Category:
  • Expiration Date Options: Expire Type
  • Once the changes have been selected, click Save.

wordpress bulk expire posts

Editing expiration settings is really simple because you just need to edit the cells and save changes once. Forget about opening and editing posts individually!

3- Bulk expire WordPress posts

WP Sheet Editor allows you to bulk update the post expiration settings for hundreds of posts at once. You can edit all posts, pick up specific posts, or apply advanced search filters easily to edit the search results.

The Search tool allows you to use any field as a search filter and find posts with a few clicks.

wordpress bulk expire posts

For example, we show you how to find posts that will expire on November 30, 2020:

  • Tick the Enable advanced filters checkbox and select the following values.
  • Field: Post Expiration
  • Operator: =
  • Value: Select the date using the calendar.
  • Click Run Search.

wordpress bulk expire posts

Once you filter the posts, they will be displayed in the spreadsheet. As you see, finding posts using advanced search filters is really simple. Here are other ways to find your posts.

wordpress bulk expire posts

Once you filter the posts, you need to open the Bulk Edit tool to bulk expire all the posts that were filtered.

wordpress bulk expire posts

In the Bulk Edit tool, you can bulk update expiration dates, expiration type, and select the expiration category settings.

a) Bulk edit expiration date

You can easily bulk move the expiration date backwards or forwards. Just select these values:

  • Select the rows that you want to update: Edit all the rows from my current search (including non-visible rows)
  • What field do you want to edit: Expiration date
  • Select type of edit: Set value
  • Replace existing value with this value: Select the new date using the calendar
  • Click Execute Now.

wordpress bulk expire posts

b) Bulk update expiration type

You need to select these values to bulk update expiration type for all the selected posts.

  • Select the rows that you want to update: Edit all the rows from my current search (including non-visible rows)
  • What field do you want to edit: Expiration date options: Expire Type
  • Select type of edit: Set value
  • Replace existing value with this value: Select the new expiration type using the dropdown.
  • Click Execute Now.

wordpress bulk expire posts

c) Bulk change the expiration category settings

En caso de que el tipo de expiración sea uno que tenga que ver con categorías, puedes seleccionar las opciones de categoría rápidamente usando estos valores.

  • Select the rows that you want to update: Edit all the rows from my current search (including non-visible rows)
  • What field do you want to edit: Expiration date options: Category
  • Select type of edit: Set value
  • Replace existing value with this value: Select the new expiration category using the dropdown.
  • Click Execute Now.

wordpress bulk expire posts

That’s really simple!

As you see, bulk expiring posts is really simple with WP Sheet Editor. You don’t have to worry about editing the Post Expirator fields in hundreds of posts individually.

Do you need help?

You can receive instant help in the live chat during business hours, or you can contact us and we will help you via email.

Close