Publish Programmatic SEO to Wordpress Automatically

PageFactory is fully integrated with Wordpress, allowing you to publish programmatic content directly to your site.

Below are the steps you'll need to complete to set PageFactory up with your Wordpress website.

Before You Start

  • Ensure you're running Wordpress 5.6 or higher.
  • Make sure you have Pretty Permalinks turned on.

It's also suggested you start with a small sample of data in your spreadsheet initially, and test creating a handful of pages before processing the full sheet. It's much easier to fix things if something goes awry with three pages, than a thousand.

Step 1: Create a Template

Login to PageFactory, and click "New Template" in the left hand sidebar. Choose the template type "Wordpress", and click the "Create" button. You'll be taken to the template editor.


Step 2: Add Spreadsheet Column Names to PageFactory

Click the "Settings" tab. Enter the name of each spreadsheet column that should be accessed in the template. These will be used as placeholders (aka "variables") in your template. Make sure the column name in the spreadsheet is an exact match of what you enter here!

Example Spreadsheet:

bird data spreadsheet

How these columns would appear in PageFactory:

bird fact variables

Step 3: Build Your Content Template

Return to the template editor by clicking the "Template" tab. Begin creating a template for your content in the Template field.

Click the green plus sign in the editor to access your spreadsheet data. When PageFactory builds your pages, the spreadsheet column names will be replaced with data from the spreadsheet.

bird facts template populated

Step 4: Grant PageFactory Access to Your Site

Click the "Settings" tab to return to the settings page. Scroll down to the Website URL field in the Wordpress Settings section. Enter the root URL to your website, and click the "save" button at the bottom of the page (you can skip the other fields for now).

The green "Grant Access" button will now be clickable below the Website URL field. Click "Grant Access", and you'll be directed to Wordpress in order to create an Application Password for PageFactory.

wordpress settings grant access

The application password will be generated for the user account you use to log into Wordpress. This user must have the "Administrator" role in order for PageFactory to work.

Click "Yes, I approve this connection", and you'll be returned to the settings page in PageFactory. Now, you should see a message below the Website URL field that says PageFactory is authenticated with your website.

Step 5: Fill Out the Remaining Settings Fields

These fields will be used to create each page in Wordpress. Some fields, such as "Slug" and "Title", have a green plus sign above them. Just like the template editor, clicking the green plus sign will allow you to add spreadsheet column names to that field.

This is important because some fields, such as the "Slug" field, must be unique for each page. Use spreadsheet data to ensure that the slug generated for each page is unique.

wordpress settings

Step 6: Publish to Wordpress

Click the "Publish" tab, and choose the spreadsheet you want to apply to your template in the CSV File field. Note: The spreadsheet must be saved in CSV format and can not be bigger than 50 MB.

Click the Publish button and PageFactory will begin creating your content and syncing it with Wordpress.

publish wait message

During publishing, PageFactory will check if a page already exists on your Website by looking at the page's slug. If it finds that a page already exists, it will update that page with any changed settings or content. If it does not find a page with a matching slug, it will create a new page entirely.

During publishing, you can refresh the page to check the status of your publish. Most of the time, this shouldn't take more than a minute. But if you're processing a lot of data, it could take a few minutes.

Wordpress FAQ

How do I find an author's slug?

In Wordpress, navigate to the "Users" page. When you mouse over a user's name, you should have the option to "view" the user. Click "view", and this will take you to the author's page.

how to find link to author page

The last item in the url for this page, is the user's slug. It will be after "author", and in between the last two forward slashes. In this example, the slug is "test_d5v8ez".

author slug in url

How do I find an image's id?

In Wordpress, navigate to the "Media" page. Click on the image you would like to use. After clicking the image, the URL will have "item="in it. The number after "item=" is the id for that image.

get image id

In the example above, the id is 19.

How do I find a page's id?

In Wordpress, navigate to the "Pages" page. Click on the page you would like to use. In the url, you'll see "post=". The number after "post=" is the id.

get page id

In the example above, the id of the page is 9.