Summary:
When integrating job data from Workday into a WordPress website, managing and displaying job locations effectively can be a challenge—especially when similar locations appear multiple times with minor variations. In this guide, Freshy walks through how to implement a consolidated taxonomy structure using WP All Import and Workday’s reference IDs.
Issue background
The Workday feed included multiple variations of “Home Office USA” locations, each corresponding to different states. This created unnecessary duplication on the job listings page. The goal was to consolidate these into a single unified taxonomy term—“Home Office USA”—within WordPress.
Diagnosis
Freshy’s team reviewed the import data and observed that each home office location was distinguished by a unique reference ID. These reference IDs (e.g., Aberdeen = ID 128) could be used to consistently map jobs to a centralized taxonomy term, regardless of their slight textual differences.
Resolution steps
- Mapping strategy confirmation
The decision was made to leave the Workday data unchanged and handle all taxonomy grouping logic within WordPress. - Custom import configuration
WP All Import was configured to map job locations based on Workday’s reference IDs. However, its native behavior with hierarchical taxonomies required additional tweaking. - Custom PHP function
A tailored function was written to place each location under a unified parent term (“Home Office USA”) based on its reference ID. This ensured all entries would fall under a single visible category. - Manual syncing process
Since the import isn’t automated, future new location entries in Workday need to be manually added in WordPress with a matching slug for consistent taxonomy mapping.
Final outcome
The job listings page now displays a streamlined “Home Office USA” location category. This improves usability and removes redundant location entries without disrupting the integrity of the imported data.
Need help consolidating Workday data in WordPress? Contact Freshy — our team creates seamless, scalable import workflows for complex integrations.
