WooCommerce - Loop through products to get terms

WooCommerce - Loop through products to add terms to wp_postmeta to enable ordering, sorting or filtering on terms

You’ll need something like this to loop through your products. It goes in functions.php for your child theme. Uncomment the add_action() to make it run. It may take ages, so comment it again after its done its job. The prints are there so you can see if its finding the right data. Comment them if they are correct. Finally, uncomment the update_post_meta() to actually do the update.

This has the potential to screw up the wp_postmeta table big style, so back up the table or the database first, or better, run it on a dev install first.

If you only want certain terms in the wp_postmeta table, you’ll need an if ($name == 'my_term' ) {}in there.

Its meant as a framework, so some further effort and debugging may be needed.

// add_action( 'init', 'update_postmeta' );
  function update_postmeta() {
    global $post;
    // get all the products
    $args = array(
     'post_type' => 'product',
     'post_status' => 'publish',
     'numberposts' => -1 );
    $selected_posts = get_posts( $args ); // array of 38 posts

     // loop through them
    foreach( $selected_posts as $post ) {
      setup_postdata($post);
      $post_id = get_the_ID();
      print 'Post ID: '.$post_id;
      $object_ids = array( $post_id );
      $taxonomies = array ( 'product_tag' );
      $terms = wp_get_object_terms( $object_ids, $taxonomies );
      if ( !is_wp_error($terms) ) {
        print ' Nr terms found: '.count($terms).'<br>';;
        if ( $terms ) {
          foreach( $terms as $term ) {
            $name = $term->name;
            $slug = $term->slug;
            print 'Name: '.$name.' Slug: '.$slug.'<br>';
            // update_post_meta( $post_id, $name, $slug );
          }
        }
      }
      print '<br>';
      wp_reset_postdata();
    }
  }