WP Job Manager – Bulk Edit Job Listings, Export and Import

In this tutorial, we will show you how to bulk edit job listings added with the WP Job Manager plugin.

WP Job Manager allows you to create job listings on your WordPress website, which is great. However, when it comes to managing your job listings, the experience is not intuitive. This happens because the normal WordPress bulk actions are too limited.

That’s why, in order to bulk manage your job listings, you need the WP Sheet Editor – Post Types plugin. It allows you to view and manage posts, pages and custom post types using spreadsheets on WordPress. In this case, it will allow you to manage your WP Job Manager listings.

After completing the payment process, you will get a zip file that you need to install as a plugin on your website.

1. Go to Plugins > Add New Plugin.
2. Click on Upload plugin.
3. Click on Choose file.
4. Locate the file on your computer.
5. Click on Install now.
6. Click on Activate plugin.
7. Enter your license and click on Activate License.

Set up the spreadsheet

After installing the plugin, you need to set up the spreadsheet to start using it. But it’s really simple. You just need to go to Sheet Editor > Setup spreadsheet.

Select the Jobs post type and click on Save.

Next, you need to select which columns you want to view in the spreadsheet (Enabled) and which columns you want to hide from the spreadsheet (Disabled).

Once you’re done, click on Save.

Finally, you will see the spreadsheet containing all your job listings.

Now you can start bulk managing your job listings using the spreadsheet, which allows you to edit any field according to the field type. You can use the spreadsheet to:

• Bulk edit job type
• Update job location in bulk
• Bulk change job expiration date
• Enable remote job in bulk
• Etc.

Optional – Search for the job listings you will bulk edit

WP Sheet Editor allows you to search for job listings based on any field. For example, you can search for jobs by job type, job location, company name, remote job, filled job, etc.

To do this, you need to open the Search tool.

Once you’re in the Search tool, you need to select the search terms you want. In this example, we will search for all the job listings that match these search parameters:

• Job type = Freelance
• Remote position = Yes
• Job expires = December 31 of 2024
• Job published = Between September 1 and September 30 of 2024

To do this, you need to select these values in the Search tool:

• Enter job types: Freelance
• Tick the Enable advanced filters and add these two filters:
  • Filter 1: Remote Position = Yes
  • Filter 2: Job Expires = 12/31/2024
• Date range from: 09/01/2024
• Date range to: 09/30/2024
• Click on Run search.

After running the search, all the job listings that match the search terms will be displayed in the spreadsheet. You can see the active filters above the spreadsheet.

Bulk edit WP Job Manager listings

If you want to edit multiple WP Job Manager listings you can do it using the Bulk Edit tool.

It allows you to bulk edit all your job listings, edit all the listings from a specific search (like the one we run in the previous section), or all manually selected listings.

We will show you several examples of how to bulk edit your job listings, so you need to start by opening the Bulk Edit tool.

Now you need to select the values in order to bulk update any field on multiple listings. Let’s see some examples:

Example 1: Mark job listings as filled in bulk

You need to select these values:

• Select the rows that you want to update: Edit all the rows from my current search / Edit all the rows that I manually selected
• What field do you want to edit: Filled
• Select type of edit: Set value
• Replace existing value with this value: Check or uncheck the checkbox
• Click on Execute Now.

Example 2: Bulk edit the job expiration date

You need to select these values:

• Select the rows that you want to update: Edit all the rows from my current search / Edit all the rows that I manually selected
• What field do you want to edit: Job Expires
• Select type of edit: Set value
• Replace existing value with this value: Select the new date
• Click on Execute Now.

Example 3: Bulk edit the job type

You need to select these values:

• Select the rows that you want to update: Edit all the rows from my current search / Edit all the rows that I manually selected
• What field do you want to edit: Job types
• Select type of edit: Set value
• Replace existing value with this value: Enter the job type here
• Click on Execute Now.

Example 4: Select the company logo in bulk

You need to select these values:

• Select the rows that you want to update: Edit all the rows from my current search / Edit all the rows that I manually selected
• What field do you want to edit: Featured Image
• Select type of edit: Set value
• We will replace the existing media with this file: You can Upload the file or paste the File URL
• Click on Execute Now.

Example 5: Bulk enable the remote position

You need to select these values:

• Select the rows that you want to update: Edit all the rows from my current search / Edit all the rows that I manually selected
• What field do you want to edit: Remote Position
• Select type of edit: Set value
• Replace existing value with this value: Check or uncheck the checkbox
• Click on Execute Now.

Export job listings to a CSV file

To export your job listings to a CSV file, you need to first open the Export tool.

Now select the following values:

• What columns do you want to export: Select the columns/fields you want to export.
• Which rows do you want to export: All the rows from my current search.
• What app will you use to edit this file: In this example, we will select Microsoft Excel (Office 365)
• Name of this export: You can add a name and reuse these settings in the future.
• Click on Start new export.

Create and edit job listings in a CSV file

After exporting your job listings to a CSV file, you will be able to start editing the job listings’ data with Excel, Google Sheets or any other CSV editor.

You can add new job listings or edit existing job listings.

Import WP Job Manager listings from a CSV file

If you want to import job listings to create new items or update existing items, you need to start by opening the Import tool.

Now you need to select the following values in the Import tool:

• Source: CSV file from my computer.
• Click on Choose File and locate the CSV on your computer.
• Click on Next.

You can Import all the columns or Select individual columns to import.

Now you have to select if you want to import all the rows as new, create new rows and update existing rows, only create or only update.

If you select any option to update existing rows, you need to match the data in the CSV with the data on WordPress using any field as an identifier like ID or any other field.

Once you’re done, click on Next.

Finally you’ll see a preview. If everything is OK, you need to click on The preview is fine, start import.

This is how you can bulk edit job listings, export them to a CSV file, and import them from a CSV into WordPress.

The integration between WP Job Manager and the WP Sheet Editor – Post Types allows you to save a lot of time editing a lot of job listings in minutes or even seconds.