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.
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.
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.
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!
How these columns would appear in PageFactory:
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.
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.
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.
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.
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.
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.
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.
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".
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.
In the example above, the id is 19.
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.
In the example above, the id of the page is 9.