Supporting tables
How to set up all the right tables when syncing WordPress
There are six tables every WordPress instance has:
Name | Type |
|---|---|
Pages | Main |
Posts | Main |
Users | Supporting |
Categories | Supporting |
Tags | Supporting |
Media | Supporting |
(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. This page will help you understand what each of these supporting tables does and how to use them in Whalesync.
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.
- 1.In Airtable, create a table called "Users"
- 2.In your Posts table, created a linked record field to Users called "Author"
Airtable Posts table - 3.In Whalesync, map both the Users and Posts tables on the table mapping screen.
Mapping the Posts and Users tables on the Whalesync table mapping screen - 4.Map the Author field in the Posts table.
Mapping the Author field on the Posts table in Whalesync - 5.Save and turn sync on!
Now all your Users will sync from WordPress to Airtable!
🎉
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 add media (e.g. images) to 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:
- 1.In WordPress, upload all the images you need in the Media page.
- 2.In Airtable, make sure you have a Media table.
- 3.In Airtable, make sure to add a linked record to the Media table in the Pages and Posts tables called "Featured media".
Here's an example of what the Media table looks like in Airtable:
Tip: Name your images in Airtable something simple and descriptive.
Last modified 3d ago