Install the Wordpress Plugin
The Wordpress Connector has two parts, a Wordpress plugin that pulls your Airtable data into wordpress, and an API tool to connect with airtable.
To connect to wordpress, use the plugin. You can find it in the Wordpress directory by searching for ‘Aeropage’.
Add a Custom Post Type
Once the plugin is installed, just open it from the sidebar and ‘Add Post’.
After clicking ‘Add a Post’ you will be shown a form. When submitted this will create a custom post type and automatically add a new post for every record in your connected Airtable
Title
The title of the custom post type will usually be the same name as the table you’re importing data from in Airtable.
Dynamic URL
The dynamic url can be ‘SEO’ friendly by using the name eg ‘shure-headphones’ or it can be easier to manage potential duplicate names by using the unique id of each record.
API Token
Continue to the next steps to create a token to use with the api connector.
Auto Sync
A cron task that is executed every 10 mins which is based on Wordpress Cron implementation. WordPress Cron is WordPress's task scheduler that runs on site visits to handle tasks like publishing posts and checking for updates.
Wordpress Cron, and to an extent auto sync, relies on site traffic, so on low-traffic sites, tasks may not run on time.
If you have an access to the hosting server settings, you can update it like so:
Disable WordPress Cron in wp-config.php:
define('DISABLE_WP_CRON', true);
Set up a server cron job to run wp_cron.php every 10 minutes:
*/5 * * * * curl http://example.com/wp-cron.php?doing_wp_cron
To complete the form you will need an API token (below)...
Create API Connector & Token
The api connector stores your connection info and prepares the data in the response to be used in Wordpress.
Connect to Airtable
After clicking new and creating your project, copy and paste the url to the airtable data you want to connect. To find out more details on this step, click on the instructions button.
Setup your Connection
You can create dynamic values for your posts when they appear in ‘loops’ on your Wordpress archive pages, query and loop templates
Post Title
The value to use when naming each post. By default this will be the same as the primary name of the record.
Post Media
Attachments will be automatically downloaded to your wordpress media library and attached to your posts - the first image in the first field will be used as a featured image for the post.
In airtable, the record’s name will become the filename of the featured post in wordpress.
Post Categories
By toggling on, and choosing a multiple select field from Airtable - a Parent Category will be created in Wordpress with a child category for each option found in the select choices. When syncing each post will be added to their corresponding categories.
Update → this is a new feature added in the plugin update, 23rd March, 2023.
Post Excerpt
A short description of the post content to be added to each post for use in loops.
Post Meta (Fields)
By default, every field in your airtable record will be created as post metadata. If you want to prevent some data from being synced, click the field settings and toggle off the ones you want to exclude.
After changes…
After making changes, you need to refresh the data to see the result.
Posts Preview
You can see a preview of how your posts would look in a Wordpress loop by click on the ‘posts’ view. This can be used to confirm the Post Title, Image and Excerpt are correct before you syncronize with Wordpress.
Syncronizing Airtable to Wordpress
Once your data is setup in Aeropage…
Click on the ‘token’ field to copy it. Go back to Wordrpress plugin, ‘create post’ page. Paste your token into the API Token field.
Auto sync can be toggled on to check for new and changed data every 10 minutes.
In aeropage copy the token.
In wordpress, paste it into the form.
After a few seconds, you should see your data appear in the right - and a Success message.
You are now ready to save the post, which will syncronize you posts for the first time. After syncronizing your custom post will appear in the Wordpress menu, and a post will have been added for each record in your Airtable data.
The first time you sync it can take longer as it’s downloading your featured images.
You should also see the images for each post in your media library.
Update your Data
To manually resync your data, make changes or delete - just click the icons below.
Make changes to the configuration
Resyncronize your data manually.
If you have auto sync toggled on, your posts will be updated automatically every 10 minutes.