Part 1 of 2 | AI-Powered WordPress Taxonomy Migration<\/p>\n
In this video I walk through the first half of a 4-step Python pipeline
\nthat semantically enriches WordPress tags using NLP and knowledge graphs \u2014
\nall running locally in Docker.<\/p>\n
What you will see:<\/p>\n
Step 1 \u2014 Connect Python directly to a WordPress MySQL database and fetch
\n100 taxonomy terms (post_tag) with post counts. No plugin required \u2014 raw
\nSQL via Python.
\nCommand used:
\n python source\/pipeline\/001_step_1_list_tags_categories_wp.py \\
\n –limit 100 –taxonomy post_tag –no-dry-run<\/p>\n
Step 2 \u2014 Run spaCy Named Entity Recognition (NER) on each tag to classify
\nthem automatically: is “Amazon” a company (ORG), a location (GPE), or a
\nproduct (PRODUCT)? NER answers that without any manual labelling.
\nCommand used:
\n python source\/pipeline\/002_step_2_spacy_ner.py \\
\n –limit 100 –taxonomy post_tag –no-dry-run<\/p>\n
Step 3 starts \u2014 Wikidata enrichment kicks off for 100 tags. Because the
\nWikidata API queries take several minutes to complete, I leave Step 3
\nrunning and pick up the results in Part 2 (video 001_b).<\/p>\n
Stack used:
\n– Python 3.9 managed via Anaconda (conda env: tags_treatment)
\n– Docker + WordPress + phpMyAdmin running locally on ports 8080 \/ 8081
\n– spaCy NER model: en_core_web_md
\n– MySQL connector for direct WordPress DB access<\/p>\n
Why this matters for SEO:
\nMost WordPress sites accumulate taxonomy chaos \u2014 hundreds of tags with
\nzero semantic meaning attached. This pipeline is the first step toward
\nconverting raw taxonomy strings into structured, AI-readable breadcrumb
\nproposals. That is the foundation for GEO (Generative Engine
\nOptimization): making your content legible to LLMs and AI agents, not
\njust to search-engine crawlers.<\/p>\n
Full article: https:\/\/wp.me\/p3Vuhl-3rb
\nGitHub: https:\/\/github.com\/bflaven\/ia_usages\/tree\/main\/ia_seo_ia_semantic_breadcrumb_webmcp<\/p>\n
Continue in Part 2 (001_b): Wikidata results + breadcrumb JSON +
\nWordPress plugin demo.<\/p>\n","protected":false},"excerpt":{"rendered":"
Part 1 of 2 | AI-Powered WordPress Taxonomy Migration In this video I walk through the first half of a 4-step Python pipeline that semantically… <\/p>\n