Listing Product Attributes in Alphabetical Order (Woocommerce)

Question

For starters thank you for taking a look / any assistance you may offer.

I am trying to create a custom page template that creates a list in alphabetical order displaying all the results for a specific (Woocommerce) product attribute across my site.

So in my case the product attribute is "Artist"

I found some code that does a similar thing for posts, which altered gives this:

<?php 
/*
Template Name: Artists

*/
$posts_per_row = 4;
$posts_per_page = 400;
?>

<?php get_header(); ?>
<?php get_template_part( 'headers/page', 'header' ); ?> 

<style type="text/css">
.letter-group { width: 100%; }
.letter-cell { width: 5%; height: 2em; text-align: center; padding-top: 8px; margin-bottom: 8px; float: left; }
.row-cells { width: 75%; float: right; margin-right: 180px; }
.title-cell { width: 25%;  float: left; overflow: hidden; margin-bottom: 8px; }
.clear { clear: both; }
</style>

 <div class="ps-container">
        <div class="container clearfix">
<div id="main-background">

   <div id="main-column">
      <h1><?php the_title(); ?></h1>

      <div class="margin-top"></div>  

      <div id="a-z">

         <?php
         $paged = (get_query_var('paged')) ? get_query_var('paged') : 1;
         $args = array (
            'posts_per_page' => $posts_per_page,
            'post_type' => 'product',
            'orderby' => 'title',
            'order' => 'ASC',
            'paged' => $paged
         );
         query_posts($args);
         if ( have_posts() ) {
            $in_this_row = 0;
            while ( have_posts() ) {
               the_post();
               $first_letter = strtoupper(substr(apply_filters('the_title',$post->post_title),0,1));
               if ($first_letter != $curr_letter) {
                  if (++$post_count > 1) {
                     end_prev_letter();
                  }
                  start_new_letter($first_letter);
                  $curr_letter = $first_letter;
               }
               if (++$in_this_row > $posts_per_row) {
                  end_prev_row();
                  start_new_row();
                  ++$in_this_row;  // Account for this first post
               } ?>
               <div class="title-cell"><a href="<?php the_permalink() ?>" rel="bookmark" title="Permanent Link to <?php the_title_attribute(); ?>"><?php the_title(); ?></a></div>
            <?php }
            end_prev_letter();
            ?>
            <div class="navigation">
               <div class="alignright"><?php next_posts_link('Next Page &raquo;') ?></div>
               <div class="alignleft"><?php previous_posts_link('&laquo; Previous Page') ?></div>
            </div>
         <?php } else {
            echo "<h2>Sorry, no artists were found!</h2>";
         }
         ?>

      </div><!-- End id='a-z' -->

   </div><!-- End class='margin-top -->

</div><!-- End id='rightcolumn' -->
</div>
</div>

<?php get_footer(); ?>

<?php
function end_prev_letter() {
   end_prev_row();
   echo "</div><!-- End of letter-group -->\n";
   echo "<div class='clear'></div>\n";
}
function start_new_letter($letter) {
   echo "<div class='letter-group'>\n";
   echo "\t<div class='letter-cell'>$letter</div>\n";
   start_new_row($letter);
}
function end_prev_row() {
   echo "\t</div><!-- End row-cells -->\n";
}
function start_new_row() {
   global $in_this_row;
   $in_this_row = 0;
   echo "\t<div class='row-cells'>\n";
}

?>

Now to alter this, I tried using get attribute in place of the array retrieving my posts, as I normally do in other spots of my site using:

global $product;    
$product->get_attribute( ‘pa_attribute’ )

But nothing is working.

Can anyone shed some light on my issue? I get it showing posts just fine, but I can't transition this to properly list the Artists names instead of product (post) names.

Thank you.

If you want to get a list of terms then you need to query the terms with get_terms() and not query the posts. By the way use WP_Query instead of query_posts() for that anyway. — helgatheviking
Thank you for the tip. Excuse my lack of knowledge here, but how would I go about using get_terms() for the attribute in this case? — Steven
See the Codex article I linked to. There's even a pretty good example of how to query the terms and then loop through them. — helgatheviking
Ill do so, thanks. I suppose no one is going to answer, so if you want to formulate your comment into an answer I will accept it. Thanks for your help. — Steven

helgatheviking helgatheviking · Accepted Answer · 2015-05-11T22:18:20

Merging the two examples in the Codex, and assuming your attribute is called "artist" then you'd get a list of terms like so:

$terms = get_terms( 'pa_artist' );
 if ( ! empty( $terms ) && ! is_wp_error( $terms ) ){
     echo '<ul>';
     foreach ( $terms as $term ) {
       echo '<li><a href="' . get_term_link( $term ) . '" title="' . sprintf( __( 'View all post filed under %s', 'my_localization_domain' ), $term->name ) . '">' . $term->name . '</a></li>';

     }
     echo '</ul>';
 }

Listing Product Attributes in Alphabetical Order (Woocommerce)

1 Answers