WooCommerce: How to manage Product Order in Next/Prev Product Navigation

Hey Ismael,

thanks for your reply! You directed me to the right searcvh term the filter “get_next_post_sort”.

I found this Blog post solving this general issue which is present in the prev/next post navigation on all custom post types (woocommerce products are custom post types):

The Code is:

function kb_custom_adjacent_post_where($sql) {
 if ( !is_main_query() || !is_singular() ) 
 return $sql; 
 $the_post = get_post( get_the_ID() ); 
 $patterns = array(); 
 $patterns[] = '/post_date/'; 
 $patterns[] = '/\'[0-9]{4}-[0-9]{2}-[0-9]{2} [0-9]{2}:[0-9]{2}:[0-9]{2}\'/'; 
 $replacements = array(); 
 $replacements[] = 'menu_order'; 
 $replacements[] = $the_post->menu_order; 
 return preg_replace( $patterns, 
 $replacements, $sql ); 
} 

add_filter( 'get_next_post_where', 'kb_custom_adjacent_post_where' ); 
add_filter( 'get_previous_post_where', 'kb_custom_adjacent_post_where' ); 

function kb_custom_adjacent_post_sort($sql) { 
 if ( !is_main_query() || !is_singular() ) 
 return $sql; 
 $pattern = '/post_date/'; $replacement = 'menu_order'; 
 return preg_replace( $pattern, $replacement, $sql ); 
} 

add_filter( 'get_next_post_sort', 'kb_custom_adjacent_post_sort' ); 
add_filter( 'get_previous_post_sort', 'kb_custom_adjacent_post_sort' );

It woud be great, if the code snippet could find its way into one of the next releases of Enfold. I think this is of general interest and will make Enfold one step more hassle-free.

Thanks and best regards
Jan

Hi,

you are correct, that the navigation is used also for posts etc. and is working fine there.

But it is also used for products and there the prev/next navigation is broken (the navigation does not use the default WooCommerce order).

So it would be good, if the Enfold prev/next navigation works in one of the next releases in all circumstances, products included.

Kind regards
Jan

Hi Ismael,

I‘m not shure what you mean with

you turn on the Page Attributes > Menu Order field

I set on all products the Menu_Order Field to achieve a nice order of the products. This works fine for the default shop and product grids, because menu_order (+ Name) is the default sorting for products in the Shop and grids.

But I learned, that posts have date order as default and do not support menu_order and that leads to a different behaviour in the shop and prev/next navigation.

My „Problem“ is solved with this code fragment. I just wondered, if it makes sense to use the default product sorting menu_order in general for the prev/next navigation for products.

Kind regards
Jan