Supporting tables
How to set up all the right tables when syncing WordPress
Last updated
How to set up all the right tables when syncing WordPress
Last updated
There are six tables every WordPress instance has:
| Name | Type |
|---|---|
(If you have Custom Posts enabled, you will see more tables for each Custom Post type)
The star of your site are the Pages and Posts - everything else is there to support them.
Tip: We highly recommend that you map all four of the supporting tables in Whalesync! You can use our Airtable template which has all six tables pre-configured.
The Users table lists all the users of your site. Tables like Media, Pages, Posts all have a field called Author that can point to a user in this list.
Note: Whalesync does not support creating new users at this time. You will have to create new users in the WordPress UI.
(Alternatively, you can use our template, which has everything set up for you)
In Airtable, create a table called "Users"
In your Posts table, created a linked record field to Users called "Author"
In Whalesync, map both the Users and Posts tables on the table mapping screen.
Map the Author field in the Posts table.
Save and turn sync on!
Like the Users table, if you want to sync WordPress Categories and Tags, you'll need to set up supporting tables.
Tip: Make sure "allow linking to multiple records" is toggled so you can link multiple categories and tags.
Just like the other supporting tables above, you'll need to create a dedicated Media table in order to manage the media (e.g. images) of your WordPress posts.
Note: Whalesync does not support creating new media at this time. Any new images must be uploaded in WordPress and not Airtable.
Here is an example of how this would work with Airtable and Whalesync:
In WordPress, upload all the images you need in the Media page.
In Airtable, make sure you have a Media table with "Title" and "Source url" fields at minimum.
In Airtable, in the Pages and Posts tables make sure to add a "Featured media" column of a type linked record pointing to the Media table.
In Whalesync, make sure to map all relevant tables: Posts, Pages, Media.
In Whalesync, make sure to map all relevant fields: in Posts/Pages map the "Featured media" field in particular. In the Media table, map all your fields.
Save and turn sync on!
Here's an example of what the Media table looks like in Airtable:
Tip: Name your images in Airtable something simple and descriptive.
Now all your Users will sync from WordPress to Airtable!
In Airtable you can see all your images in the Media table, and for any Post or Page record that has an image associated with it, you will see it in the "Featured media" column. More importantly you can assign an image to a particular Post or Page from Airtable!
Pages
Posts
Users
Categories
Tags
Media
