In many cases it could be useful to create a bunch of posts at once with WordPress. The bad news is: WordPress itself has no solution to this problem. The good news: We do!
With our LPagery WordPress plugin you are able to bulk create posts via a CSV File, or other sources in the Pro version. LPagery gives you the opportunity to add placeholders on a template page you can design with WordPress, then adds in the data from your source (e.g. CSV File) and provides you with your new pages in a matter of seconds.
In this article I will show you different use cases and then show you how to use LPagery to bulk create posts in WordPress. If you want to take a look on how it works, check out our video tutorial:
To bulk create posts with WordPress you simply have to follow 6 simple steps:
Some of the functionalities presented in this article are not available in the free version
While we offer a premium version of LPagery, you don’t necessarily need it to bulk create pages with WordPress.
To download the free version of LPagery you simply need to:
Go to your WordPress dashboard and head over to the ‘Plugins -> Add new’ section and search for ‘LPagery’. Alternatively you can download it here: https://wordpress.org/plugins/lpagery/
After installing LPagery, you will then need to create your source file for the posts you want to create. You can do this with any software that lets you create CSV or XLSX files.
In the top row of the spreadsheet you fill in one placeholder per column:
The example above will give you the following placeholders:
{city}, {service} and {your-placeholder}
next:
Fill in your data
Next up you will have to add your data to the spreadsheet. Keep in mind:
Every row will equal one generated post later on.
The example above will give you the three posts. If you have a heading on your template post with this content:
„Your {your-placeholder} {service} service in {city}„
The result pages would be:
„Your best Plumbing service in New York„
„Your professional Plumbing service in London„
„Your excellent Plumbing service in Tokyo„
For LPagery to work you will need a template post. Simply follow these steps to set it up:
If you want to use an already existing post, simply ignore this step and move on to the next step.
First, you will have to create a new regular WordPress post. Go to ‚Posts‘ in the admin bar on the left and click ‚Add New‘. Now edit the post with WordPress just like you would any other post.
To make the template post dynamic and able to adapt to your desired content, you need to add placeholders on the site, which you determine while creating a CSV File.
For example: If you have set up a CSV File with the following Placeholders:
You can then use the placeholders like this:
“Your {your-placeholder} {service} service in {city}“ as a heading on your post.
Then three posts would be generated and the content would be changed to:
„Your best Plumbing service in New York„
„Your professional Plumbing service in London„
„Your excellent Plumbing service in Tokyo„
When you are done with preparing the template post, simply publish the post and afterwards you will be able to select the post in LPagery as template page.
With LPagery Pro you have some options after you created and selected your template page. You can change the URI slug of the created pages, assign a category and a parent page, as well as selecting the status of the created pages (Published, Private, Draft).
Per default LPagery will add the title of the template page as the URI slug. You can leave this as is, if you want to have the page title as slug. If you want to customize the URI you can do this using the same placeholders you used on your template page. For example:
my-service-in-{city}
as input in the URI field, would result in
„www.your-domain.com/my-service-in-city/„
(„city“ would be replaced with whatever cities you have in your CSV file or are detected with the radius option)
You can select a parent page for the created pages so the created pages will then be child elements of your parent page.
If you decide to connect the generated pages to a parent page, the slug of the parent page will automatically be applied to the URI of the newly generated pages. If we added a parent page to the example above, which has the slug „services“, the URI would look like this:
„www.your-domain.com/services/my-service-in-city/„
LPagery has a built in category function, which enables the WordPress categories to not only work on posts but also on pages. This way you are able to create a category and then assign your created pages to this category. This way you can ensure a good website structure.
If you are using the free version of LPagery, you only have the option to upload a CSV or XLSX file. Simply select your source CSV/XLSX file and you are good to go.
If you are using LPagery Pro you have more options to choose from. Of course you can also use a CSV/XLSX file and this option might be the best one for most occasions but you can also link to a Google Sheet URL the Google Sheet structure is exactly like the structure of a CSV file mentioned before.
Make sure that LPagery can access your Google Sheet.
If you want to create posts automatically for cities in your area, select the ‘Radius’ option. Now you can modify a couple of options. Also make sure that you use the placeholder {city} on your template page, as this is the placeholder which will then be replaced by the cities around your business location.
When you are done with the setup, just click on ‘Next’. In the Popup you will then see all posts that will be created (Every row represents one page) and with LPagery Pro you will be able to make changes to the pages via the popup (e.g. deleting rows or adding new rows and collums).
Then click ‘Generate Pages’ and all posts will be generated. This can take some time depending on the size of your template page and amount of created posts.
Creating Posts in Bulk can be useful for everybody
It doesn’t matter if you are running a small local business, a blog, an online shop or even a huge marketing agency. LPagery offers a helpful solution for everyone who wants to save time and optimize their online marketing efforts by bulk creating posts with WordPress.
Enables the creation of unique, personalized landing pages at scale by offering unlimited placeholders for dynamic content.
Essential for crafting content-rich, unique pages for each visitor or target group, optimizing for local SEO, e-commerce variability, or specific event details.