LearnPress – How to Import, Export, and Bulk Edit Courses

LearnPress is one of the great tools that can help us manage online schools and courses. However, it’s really difficult to manage our courses when we have thousands of them.

That’s why we want to show you how to manage your LearnPress courses using a spreadsheet. You’ll be able to export, import, and bulk edit information in seconds, so you’ll save a lot of time and clicks. For that you’ll need to use the Posts, Pages, and Custom Post Types Spreadsheet plugin.

This plugin allows you to manage your posts, pages, and custom post types created by other plugins on a spreadsheet. That spreadsheet contains advanced search tools, export/import tools, and a powerful bulk edit tool.

1- Install the Posts, Pages, and Custom Post Types Spreadsheet plugin

2- Set up the LearnPress courses spreadsheet

After installing and activating the plugin, you need to generate the spreadsheet that will allow you to manage your courses completely from it.

For that you need to go to Sheet Editor > Setup Spreadsheet.

Once there, you’ll see the Set up Spreadsheet tool.

You need to enter the Courses post type, scroll down and click on Save to generate the spreadsheet.

Now you need to select the columns you want to include in the spreadsheet. If you don’t want any of the available columns, you can move it from the Enabled (left) section to the Disabled (right) section.

Once you’ve selected the columns you’ll include in the spreadsheet, just click on Save to create the spreadsheet. It doesn’t even take five minutes.

Now you’ll see the spreadsheet containing all your LearnPress courses and their complete information. All the courses will be displayed in the rows while the course sections and fields will be displayed in the columns.

3- How to export and import LearnPress courses with a few clicks

With WP Sheet Editor, you can export the complete information of your LearnPress courses to a CSV file that you can edit with Excel or Google Sheets. Once you download the CSV, you can apply changes offline using Excel. Finally, you can quickly import the changes and even create new courses completely from the CSV and import them to WordPress with a few clicks.

To export your courses to a CSV file that can be edited with Excel or Google Sheets, you just need to click on Export. It’s on the top toolbar.

Now you need to select the columns that you will export.

  • Click on Select all or enter specific columns in What columns do you want to export.
  • Tick the I understand it will export the posts from my current search checkbox.
  • Optional. Tick the I will edit this file with Microsoft Excel checkbox. This is necessary because sometimes Excel doesn’t recognize the comma as separator, so this checkbox fixes that problem.
  • Finally, click on Start new export.

After downloading the CSV file to your computer, you can edit it using Excel or Google Sheets.

For example, you can edit the courses’ duration. For that just go to the lp duration column and change the number of week the courses last.

After making the changes you need, you need to save the changes and you’ll be ready to import the info back to the LearnPress spreadsheet.

Once you have the CSV file ready, you can quickly import all the changes. Just open the import tool by clicking on Import on the top toolbar.

Now you need to select the CSV file from your computer, so you need to do this:

  • Source: CSV file from my computer
  • Click on Choose File and search for it on your computer.
  • Click on Next.

Next, click on Import all the columns to continue.

Select the Update existing items, ignore new items option in the Do you want to update or create items dropdown.

Match the CSV fields to the WordPress fields. You can pair up the IDs for the plugin to match the files and import the information in the right places:

  • Field 1: CSV Field: record_id
  • Field 1: WordPress Field: ID

Now just click on Next.

Now the plugin will show you a preview of how the information will look once it’s imported. If it’s ok, click on The preview is fine, start import.

If you check the columns you imported, you’ll see that all the fields you edited will be modified.

4- How to bulk edit LearnPress courses

With WP Sheet Editor, you can apply changes to hundreds of LearnPress courses. It’s really easy because you don’t have to open them one by one, but you can search for all courses that have a specific keyword in the title, a specific price, a specific category, etc., and then simply edit all the search results.

a) How to do advanced course searches with WP Sheet Editor

You can read the following article to learn how to use any of your courses’ field as a search parameter. This way you can find all courses with a specific keyword in the title, specific price, passing condition, number of students, etc.

Once you’ve searches for the courses using the search parameters you prefer, you’re ready to proceed to bulk edit the search results.

b) How to bulk edit courses in minutes

Open the Bulk Edit tool with one click.

With this tool, you can apply massive changes to all the filtered courses. Therefore, one you open it, you’ll be able to apply any change to all the search results. In the following drop-down sections we show you how to bulk edit the filtered courses.

To bulk edit the duration for all the courses you’ve filtered, select the following values in the Bulk Edit tool.

  • Select the rows that you want to update: Edit all the rows from my current search (even non-visible rows)
  • What field do you want to edit: lp duration
  • Select type of edit: Set value
  • Replace existing value with this value: 10 week, for example.
  • Click on Execute now.

Now you’ll see how your courses’ duration has been updated from 6 weeks to 10 weeks.

To feature all the filtered courses, you need to select the following values in the Bulk Edit tool:

  • Select the rows that you want to update: Edit all the rows from my current search (even non-visible rows)
  • What field do you want to edit: lp featured
  • Select type of edit: Set value
  • Replace existing value with this value: Tick this checkbox.
  • Click on Execute now.

After that you’ll see all your courses featured in the spreadsheet.

These are the values you need to select in the Bulk Edit tool in order to change the course author for all the selected courses:

  • Select the rows that you want to update: Edit all the rows from my current search (even non-visible rows)
  • What field do you want to edit: Lp Course author
  • Select type of edit: Set value
  • Replace existing value with this value: Enter the author’s ID in this field.
  • Click on Execute now.

To block the lessons’ content in all the filtered courses, you need to select the following values in the Bulk Edit tool:

  • Select the rows that you want to update: Edit all the rows from my current search (even non-visible rows)
  • What field do you want to edit: Lp Block Lesson Content
  • Select type of edit: Set value
  • Replace existing value with this value: Write, “yes”.
  • Click on Execute now.

Select the following values in the Bulk Edit tool in order to change the evaluation method for all the filtered courses.

  • Select the rows that you want to update: Edit all the rows from my current search (even non-visible rows)
  • What field do you want to edit: Lp Course Result
  • Select type of edit: Set value
  • Replace existing value with this value: evaluate_quiz, for example. You can select any of these values: evaluate_lesson, evaluate_quiz, evaluate_passed_quizzes, etc.
  • Click on Execute now.

These are the values you need to select in the Bulk Edit tool if you want to enable the Enroll required option for all the filtered courses:

  • Select the rows that you want to update: Edit all the rows from my current search (even non-visible rows)
  • What field do you want to edit: Lp Required Enroll
  • Select type of edit: Set value
  • Replace existing value with this value: Tick this checkbox.
  • Click on Execute now.

Saving a lot of time is really simple!

As you can see, the Posts, Pages, and Custom Post Types Spreadsheet plugin is a great assistant when it comes to managing thousands of LearnPress courses.

You can save a lot of time exporting, importing, and bulk editing your courses information in minutes.

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 Menu