WordPress Multisite – global categories

function __add_global_categories( $term_id )
{
    if ( get_current_blog_id() !== BLOG_ID_CURRENT_SITE || ( !$term = get_term( $term_id, 'category' ) ) )
        return $term_id; // bail

    if ( !$term->parent || ( !$parent = get_term( $term->parent, 'category' ) ) )
        $parent = null;

    global $wpdb;

    $blogs = $wpdb->get_col( "SELECT blog_id FROM {$wpdb->blogs} WHERE site_id = '{$wpdb->siteid}'" );
    foreach ( $blogs as $blog ) {
        $wpdb->set_blog_id( $blog );

        if ( $parent && ( $_parent = get_term_by( 'slug', $parent->slug, 'category' ) ) )
            $_parent_ID = $_parent->term_id;
        else
            $_parent_ID = 0;

        wp_insert_term( $term->name, 'category',  array(
            'slug' => $term->slug,
            'parent' => $_parent_ID,
            'description' => $term->description
        ));
    }

    $wpdb->set_blog_id( BLOG_ID_CURRENT_SITE );
}
add_action( 'created_category', '__add_global_categories' );

This will run whenever a category is added on the main site. A few caveats/points worth mentioning;

  • If you have a lot of blogs, this function may get pretty intensive.
  • On average, we are running anywhere between 5 to 8 queries (possibly more) per blog – depending on the speed of your database, this function may need to be chunked.
  • Only newly added categories are ‘synced’. Updating and deleting categories are not (code will need to be revised).
  • If a newly added category has a parent, and the parent cannot be found within the multisite blog in question, the category will be created with no parent (this should only be the case if the parent category was created before this function was installed).

Related Posts:

  1. WordPress Multisite – global categories
  2. global categories – Share specific categories in wordpress multisite
  3. Get posts from sites in Multisite?
  4. Multisite – Protect categories from deletion?
  5. Category page doesn’t use category.php, instead it redirects to homepage
  6. 5 blogs on one WordPress site
  7. Multisite blog converting categories to subdomains
  8. Adding categories to all blogs at once
  9. WordPress MU 2.9.2 to 3.0.5 changes to category.php
  10. How to make category RSS feeds show full content
  11. Multi-site or categories?
  12. Multisite – create a category in specific site
  13. Default category link for a custom category is a broken link
  14. Archives for each category on WP Multisite
  15. How do I share categories across selected sites in a Multisite setup
  16. get_categories() returns “Uncategorised”
  17. wordpress multisite… collect all posts on main blog – exclude category?
  18. Can Categories be used to hack a Multisite-like setup w/ a single MySql db?
  19. How to Sync Menu, Widgets and other masters from Main Website to its Sub Site
  20. Categories show 404 error on multisite installation
  21. Global navigation in multisite: problem with categories
  22. Duplicate new categories across multisite network
  23. get_the_category return empty inside loop
  24. Limit Category/Tag Dropdown To blog_id in Multisite Install With Global Categories/Tags
  25. Using template file for single post in sub-directory multisite
  26. A search box for all sites – Multisite
  27. How to create default categories in new installs?
  28. Multiple parent categories
  29. How to populate a WordPress install with a lot of categories, quickly?
  30. How to structure Multisite sites into categories?
  31. How to create an automatic MultiColoumn MegaMenu with Categories WordPress
  32. Main menu not appearing on category pages
  33. Using URL parameters, list posts from category and custom taxonomy
  34. Display posts links from a category group by year
  35. List categories for author: list_categories function inside list_authors function
  36. Hide a certain category name without removing it?
  37. strip last comma from get_the_category
  38. Exclude a category from the filed under list only on some templates
  39. has_category() for parent category
  40. Getting the sub category
  41. How to insert category and subcategory using ‘wp_insert_post’ function?
  42. Show posts of category in a page
  43. How to create taxonomy values for pages and list them in wp-admin
  44. display woocommerce all category title on home page
  45. When to use ‘get_category_by_path’ vs. ‘get_term_by’ to get category object from `get_query_var( ‘category_name’ )`?
  46. One WP install, I need to map a custom domain name to each category
  47. Show thumbnail for category?
  48. get_the_category_list() does not give me all my categories
  49. How to disable category without deleting?
  50. Displaying multiple loops based off of category
  51. Limit number of terms that a custom taxonomy can save per custom post type
  52. Category pie diagram meta box in post editing page
  53. There any way to get de percentage of number of post by user and category?
  54. Exclude current post from loop
  55. Removing Uncategorized on post save if other category present?
  56. Exclude categories from wp_list_categories by category slug
  57. WordPress Categories in data-groups
  58. How to list all categories and their IDs using SQL query?
  59. How to access deleted term inside delete_product_cat action
  60. How to order get_categories() in the same order as the menu?
  61. Showing Categories for Page Edit – without plugin
  62. Difference between wp_list_categories and get_categories
  63. Show different menu on each woocommerce category page
  64. Have posts that belong to multiple categories, exclude some categories from homepage
  65. Display subcategories selectbox on each category page
  66. add_settings_field (exclude categories->reading) wp_category_checklist
  67. Retrieve post tags from from main wp_query
  68. Listing Post Categories on Home Page
  69. Get posts in a subcategory of a chosen parent
  70. How can I only display links from a child category
  71. Category Template – Show Last Entry as Featured
  72. can I ‘combine’ categories as a menu item?
  73. List taxonomy terms assigned to a post in hierarchical view
  74. How to set the same base url for two different taxonomies?
  75. Hide category name but show posts
  76. Count how many posts have a specified tag AND category
  77. Show the parent taxonomy by creating shortcode in woocommerce?
  78. Post List by category and under custom taxonomy
  79. Balance Tags to the_content Words Length
  80. How to create template for children category?
  81. Categories and Tags Conflict after Woocommerce Installation
  82. Setting category for post as default
  83. the_content() not showing full posts in category template
  84. Show parent category if there is no subcategory
  85. Add category links?
  86. foreach,having wp_query inside, breaks after showing one result
  87. Display a category name automatically using code in the functions.php file
  88. Removing categories, Comments etc from posts?
  89. Add html word before category
  90. Problem importing categories and sub-categories
  91. how to ask if in two categorys inside if
  92. How to add a tag above a category post that displays the category name in WordPress
  93. Woocommerce – Display product category of product in Orders page
  94. How to show video from wp option value?
  95. Changing Woocommerce categories programatically
  96. Add an Exclusive or featured tag line to article titles
  97. How to list out post category name and description in page
  98. Print child category slug nicename
  99. Order Categories by Character Count
  100. how do I exclude a category foreach

Leave a Comment