How to set up all the right tables when syncing WordPress
Overview
There are four tables every WordPress instance has:
Name
Type
Pages
Main
Posts
Main
Categories
Supporting
Tags
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.
Tip: We highly recommend that you map Categories and Tags in Whalesync!
You can use our Airtable template which has these tables pre-configured.
Supporting Tables
Categories and Tags
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.
Users
The Users table lists all the users of your site. Tables like Pages and Posts all have a field called Author that can point to a user in this list.
Note: Whalesync does not support mapping the Users table at this time. You will have to manage users in the WordPress UI.
Media
The Media table contains media like images, audio, and videos that you've uploaded to your Wordpress site. Posts, Pages, and custom post types have a field called Featured Image that can point to a media item in this list.
Note: Whalesync does not support mapping the Media table at this time. Compatible media will be automatically uploaded into the Wordpress Media Library during the sync.
