Tutor LMS – How to Bulk Edit Courses in a Spreadsheet

In this tutorial, we will show you how to bulk edit Tutor LMS courses using a spreadsheet on WordPress. You’ll use a course grid editor that will simplify your course management completely.

Related tutorial:

• Export and Import Tutor LMS Courses using CSV
• Export and Import Tutor LMS Courses with Google Sheets

For this, we will use the WP Sheet Editor plugin, which allows you to view and manage posts, pages, and custom post types (courses, products, donation forms, etc.) in a spreadsheet.

Bulk editing Tutor LMS courses with WP Sheet Editor offers several advantages:

1. Advanced Search: Simplify course management by grouping, sorting, and filtering courses according to specific criteria.
2. Efficiency: Make changes to multiple courses simultaneously, saving you a significant amount of time compared to editing them one by one.
3. Error Reduction: Minimize the risk of errors and inconsistencies that can occur when editing courses individually.
4. Quick Updates: Rapidly update course data, such as pricing, descriptions, and other data across your entire eLearning platform.
5. Advanced Bulk Editing: Bulk update thousands of courses with a few clicks. Just select the courses to edit, the field to update, and run a bulk update.

By using WP Sheet Editor for bulk editing Tutor LMS courses, you can streamline course management, maintain consistency, and save a lot of time!

1- Set up a spreadsheet for Tutor LMS courses

In order to edit your Tutor LMS courses, you need to generate a spreadsheet.

Go to WP Shet Editor → Setup spreadsheet.

Once there, tick the Courses post type and click on Save.

Now select the columns (fields) you want to view in the spreadsheet.

You can disable specific columns by moving them from Enabled to Disabled.

Once you’re done, click on Save to generate the spreadsheet.

After that, you’ll see a spreadsheet displaying all your Tutor LMS courses.

Every row is a course and every column is a course field.

2- Edit Tutor LMS courses in a spreadsheet

You can edit your Tutor LMS courses using the spreadsheet.

Each course field works according to the field type, as we will show you below.

a) Edit dropdown fields in the spreadsheet

The dropdown fields work by displaying the options you have to select.

This can be really useful to edit course status and course level in the spreadsheet.

b) Edit checkbox fields in the spreadsheet

If you want to make your courses public or activate Q&A for your courses, you can do so by checking a checkbox in the corresponding column.

c) Edit upload file fields in the spreadsheet

You can edit image fields from the spreadsheet.

Just go to the column and click on the cell you want to edit to open the media library to upload or select images.

This is very useful to change the featured images of the courses easily.

Here you can see that we have opened the media library from the spreadsheet.

d) Edit course benefits, materials, requirements, audience, etc.

You can easily edit the course benefits, course materials, course requirements, course target audience by adding text and separating each item on a specific line.

e) Edit course duration

You can edit the course duration using the fields in the spreadsheet. Just add the number of hours, minutes and seconds in the corresponding fields.

f) Edit maximum students

If you want to change the maximum number of students admitted to your courses, you can do it using the column. Just add the number.

3- Advanced search for Tutor LMS courses

WP Sheet Editor allows you to make advanced searches in your courses. You can search courses by course category, course level, is course public, etc.

This saves you a lot of time, even if you have to edit courses individually in the spreadsheet.

You need to start by opening the Search tool.

Here are some advanced search examples for the Tutor LMS spreadsheet:

a) Search for Tutor LMS courses by category

You can find courses within specific categories.

For example, to find all courses on the “productivity” category, you need to enter the category and click on Run search.

After that, all the courses that belong in the selected category will be displayed on the spreadsheet.

b) Search for public Tutor LMS courses

If you want to search for all public courses, you need to tick the Enable advanced filters checkbox.

Next, you need to select the “Tutor Is Public Course” field, the = operator, and tick the “Value” checkbox.

Finally, click on Run search to filter all your Tutor LMS public courses.

As you can see, we have filtered all the public courses on the spreadsheet.

c) Search for Tutor LMS courses by course level

You can find all Tutor LMS courses that have a specific course level.

For this, you need to tick the Enable advanced filters checkbox.

Now you need to select the Tutor Course Level field, the = operator, and select the level in the “Value” field.

Finally, click on Run search.

As you can see, we have filtered all the courses in the Beginner level, and they are displayed on the spreadsheet.

These are just a few examples of advanced searches you can perform with WP Sheet Editor.

You can do your own searches, using any field in your courses as a search filter.

You can search for courses by price, category, tag, featured image, course benefits, course requirements, course duration, etc.

4- Bulk edit Tutor LMS courses with a few clicks

WP Sheet Editor contains the most powerful bulk editing tool, as it allows you to bulk update any Tutor LMS field in thousands of courses. This way, you can save hundreds of hours of work because you can make any bulk change with a few clicks:

• Bulk update course pricing
• Bulk change course level
• Update course duration in bulk
• Bulk edit course description
• Change course titles in bulk
• Add text before or after some text in course titles
• Bulk edit course audience
• Bulk edit course benefits
• Update course materials in bulk
• Edit course requirements in bulk
• Bulk change course max number of students
• And so on

You need to start by opening the Bulk Edit tool.

In this example, we want to show you the values you need to select to bulk update course level in all your selected courses:

• Select the rows that you want to update: The Bulk Edit tool allows you to bulk update all courses, all the courses from a specific search, or all the courses you have manually selected using the spreadsheet.
• What field do you want to edit: You need to select the field you want to edit. Remember that you can edit any field in bulk. In this case, we will select the Tutor Course Level field.
• Select type of edit: Here you need to select which type of bulk change you want to apply. In this case, we will select the “set value” option, but you can replace specific values, clear values, copy from other columns, run advanced formulas, etc. It all depends on the field you have selected and the change you want to apply.
• Now you need to add the new values. This will depend on the type of edit you have selected.
• Click on Execute Now.

Start bulk updating Tutor LMS courses now!

WP Sheet Editor allows you to manage your Tutor LMS courses using a spreadsheet. You can edit courses from the spreadsheet, all in one place. You can also do advanced searches using any field as search criteria. In addition, you can edit hundreds or thousands of courses at once, using the bulk editor.

This course grid editor will completely boost your productivity!