Supporting tables

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.