{"id":5813,"date":"2026-09-24T16:56:42","date_gmt":"2026-09-24T07:56:42","guid":{"rendered":"https:\/\/donguri3.net\/server-tech\/tsf-sitemap-add-bogo-posts-2\/"},"modified":"2026-09-24T16:56:44","modified_gmt":"2026-09-24T07:56:44","slug":"tsf-sitemap-add-bogo-posts","status":"publish","type":"post","link":"https:\/\/donguri3.net\/en\/server-tech\/wordpress-blog-seo\/tsf-sitemap-add-bogo-posts\/","title":{"rendered":"How to Add Bogo’s English Articles to The SEO Framework’s Sitemap"},"content":{"rendered":"

When implementing multilingual support in WordPress, “Bogo” is widely used as a simple and lightweight plugin. However, in environments where “The SEO Framework” (hereafter TSF) is used concurrently as an SEO plugin, specification issues arise during standard XML sitemap generation.<\/p>\n

Even if you create and publish translated versions of Japanese articles (such as English articles) using Bogo, the sitemap (sitemap.xml) automatically generated by TSF will only output the original Japanese articles, and the URLs of the English articles will not be added at all. Leaving this state unaddressed prevents search engine crawlers from being notified of the existence of multilingual articles, leading to significant delays in indexing and missed opportunities.<\/p>\n

Automatic Registration of English Article URLs and Last Modified Dates to the XML Sitemap<\/h2>\n

The purpose of this article is to dynamically and automatically add published English articles created by Bogo (posts with the en_US locale) to the XML sitemap generated by TSF.<\/p>\n

Rather than simply adding the URLs, the last modified date (Lastmod) of each article is also accurately linked and outputted. This creates an environment where search engine crawlers can retrieve appropriate update information when new articles are published or past articles are updated.<\/p>\n

Three Technical Factors Preventing Sitemap Addition and Reflection<\/h2>\n

During our investigation, three factors were identified that hinder the addition and proper display of English articles in the sitemap.<\/p>\n

Automatic Query Filtering by Bogo<\/h3>\n

If you attempt to retrieve posts using standard WordPress functions (such as get_posts), Bogo’s internal filters kick in and automatically exclude articles outside the current language context (defaulting to Japanese) from the query results. As a result, standard queries process zero English articles.<\/p>\n

Strictness of Array Specifications Required by The SEO Framework<\/h3>\n

TSF’s sitemap extension filter hook (the_seo_framework_sitemap_additional_urls<\/a>) is designed to accept URLs as array “keys” and store “associative array-format metadata” in their values. If the format does not match, URLs will be numerically indexed or the update date (lastmod) will be discarded and left blank.<\/p>\n

Multi-layered Caching by Web Servers and CDNs<\/h3>\n

In environments where OpenLiteSpeed’s cache module (LiteSpeed Cache) or the QUIC.cloud CDN is enabled, access to sitemap.xml is heavily cached as static files on edge servers and elsewhere. This causes the PHP processing in functions.php itself to be bypassed, resulting in a state where configuration changes and debug logs are not output.<\/p>\n

Implementing Hooks via functions.php and Configuring Multi-Layered Cache Exclusions<\/h2>\n

To resolve the above factors, we will implement direct data retrieval from the database, construct an associative array compliant with TSF specifications, and configure cache exclusion settings.<\/p>\n

Adding Code to functions.php<\/h3>\n

Add the following code to your child theme’s functions.php. To bypass Bogo’s query exclusion, we use $wpdb to directly retrieve the en_US article IDs and update dates from the database, and assign them to an array structure tailored to TSF’s specifications.<\/p>\n

\n\/\/ =================================================================\n\/\/ The SEO Framework: Add Bogo English Articles to Sitemap (Official Spec Compliant)\n\/\/ =================================================================\nadd_filter( 'the_seo_framework_sitemap_additional_urls', function( $custom_urls ) {\nglobal $wpdb;\n\nif ( ! is_array( $custom_urls ) ) {$custom_urls = array();\n}\n\n\/\/ 1. Directly retrieve published article IDs and update dates for "en_US" from MariaDB\n$en_posts =$wpdb->get_results( "\n    SELECT p.ID, p.post_modified_gmt \n    FROM {$wpdb->posts} p\n    INNER JOIN {$wpdb->postmeta} pm ON p.ID = pm.post_id\n    WHERE p.post_status = 'publish'\n      AND p.post_type = 'post'\n      AND pm.meta_key = '_locale'\n      AND pm.meta_value = 'en_US'\n" );\n\nif ( empty( $en_posts ) ) {\n    return $custom_urls;\n}\n\n\/\/ 2. Assign in an associative array format adhering to official TSF specifications (URL as key, lastmod array as value)\nforeach ( $en_posts as$post ) {\n    $permalink = get_permalink($post->ID );\n\n    if ( function_exists( 'bogo_url' ) ) {\n        $permalink = bogo_url($permalink, 'en_US' );\n    }\n\n    $custom_urls[$permalink ] = array(\n        'lastmod&#text' => $post->post_modified_gmt,\n    );\n}\n\nreturn $custom_urls;\n}, 10, 1 );\n<\/pre>\n
 <\/p>\n
LiteSpeed Cache Exclusion Settings<\/h3>\n
Add LiteSpeed Cache exclusion settings so that the sitemap is generated dynamically.<\/p>\n
Open the WordPress admin dashboard and go to “LiteSpeed Cache” > “Cache” > “[4] Excludes”, and register the following under “Do Not Cache URIs”:<\/p>\n
\n\/feed\n\/feed\/\nsitemap.xml\nsitemap_index.xml\n\/sitemap\n\/wp-sitemap\n<\/pre>\n
Also, if you are using static CDN features, add sitemap.xml and sitemap_index.xml to the “Excludes Paths” under “[CDN]” > “Static CDN Settings”.<\/p>\n
Complete Cache Purge<\/h3>\n
After saving the settings, completely clear the following caches:<\/p>\n
    \n
  1. Open the WordPress admin “SEO” settings and click “Save Changes” to regenerate TSF’s internal transient cache.<\/li>\n
  2. Run “Purge All” in LiteSpeed Cache.<\/li>\n
  3. Run “Purge CDN Cache” from the QUIC.cloud dashboard or admin screen.<\/li>\n<\/ol>\n
    Proper Display of English URLs and Last Updated Dates in the Sitemap<\/h2>\n
    After purging the cache, we accessed and verified the sitemap endpoint from a browser and terminal.<\/p>\n
    Verification URL:
    \nhttps:\/\/donguri3.net\/sitemap.xml<\/a><\/p>\n
    <\/pre>\n
    As an output result, we confirmed that the CDN and web server cache statuses were bypassed, and all English article URLs (e.g., https:\/\/donguri3.net\/en\/…) were successfully added to the XML source. We also verified that accurate update dates were outputted to the <lastmod> tags corresponding to each URL, and the correct dates and times were displayed in the “Last Updated” column on the browser’s XSL stylesheet display.<\/p>\n
    Conclusion<\/h2>\n
    We identified the cause and implemented a countermeasure for the issue where English articles created with Bogo were not being outputted to The SEO Framework sitemap. To bypass Bogo’s language filters, we implemented code to directly extract data using $wpdb and pass it to the hook in an associative array structure compliant with TSF specifications. Furthermore, by executing cache exclusions and purging for LiteSpeed Cache and the QUIC.cloud CDN, all English article URLs and accurate update dates were successfully reflected on the sitemap.<\/p>\n","protected":false},"excerpt":{"rendered":"
    When implementing multilingual support in WordPress, “Bogo” is widely used as a simple and lightwe […]<\/p>\n","protected":false},"author":4,"featured_media":5564,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_locale":"en_US","_original_post":"https:\/\/donguri3.net\/?p=5563","footnotes":""},"categories":[1166],"tags":[52,15,14,61,10],"class_list":["post-5813","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-wordpress-blog-seo","tag-https","tag-litespeed","tag-openlitespeed","tag-wordpress","tag-server","en-US"],"_links":{"self":[{"href":"https:\/\/donguri3.net\/wp-json\/wp\/v2\/posts\/5813","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/donguri3.net\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/donguri3.net\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/donguri3.net\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/donguri3.net\/wp-json\/wp\/v2\/comments?post=5813"}],"version-history":[{"count":1,"href":"https:\/\/donguri3.net\/wp-json\/wp\/v2\/posts\/5813\/revisions"}],"predecessor-version":[{"id":5816,"href":"https:\/\/donguri3.net\/wp-json\/wp\/v2\/posts\/5813\/revisions\/5816"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/donguri3.net\/wp-json\/wp\/v2\/media\/5564"}],"wp:attachment":[{"href":"https:\/\/donguri3.net\/wp-json\/wp\/v2\/media?parent=5813"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/donguri3.net\/wp-json\/wp\/v2\/categories?post=5813"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/donguri3.net\/wp-json\/wp\/v2\/tags?post=5813"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}