tictok

Hi Aslam, thanks fro your reply

I added the debug logging and checked the results. The SQL JOIN is being generated correctly – I can see wp_rwpp_product_order joined with category_id = 21 on lines 2-4 of the log below.

However, WooCommerce is overriding the ORDER BY clause. The final query shows:

ORDER BY 
    CASE istockstatus.meta_value 
        WHEN 'outofstock' THEN 1
        ELSE 0
    END ASC,  
    wc_product_meta_lookup.average_rating DESC, 
    wc_product_meta_lookup.rating_count DESC, 
    wc_product_meta_lookup.product_id DESC

So it’s using WooCommerce’s default sorting (stock status → rating → product ID) instead of rwpp_order.sort_order. The orderby_product_order() filter runs, but WooCommerce replaces the ORDER BY with its own logic.

This suggests the posts_orderby filter approach doesn’t work with WooCommerce’s query handling. The meta_query approach with orderby => ‘meta_value_num’ works because WooCommerce respects native WP_Query parameters.

Here’s the relevant log excerpt showing both queries:

[RWPP INFO] Complete SQL Query: SELECT SQL_CALC_FOUND_ROWS  wp_posts.*
     FROM wp_posts  LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) 
     LEFT JOIN wp_rwpp_product_order AS rwpp_order
       ON wp_posts.ID = rwpp_order.product_id
       AND rwpp_order.category_id = 21 
     ...
     ORDER BY 
        CASE istockstatus.meta_value 
            WHEN 'outofstock' THEN 1
            ELSE 0
        END ASC,  wc_product_meta_lookup.average_rating DESC, 
        wc_product_meta_lookup.rating_count DESC, 
        wc_product_meta_lookup.product_id DESC

Hope that helps narrow it down.

Thanks!

Hey, thanks @spiderwares, thats great new. I’ll give it ago. Feedback/rating given 😉

Hey many thanks for the update @spiderwares
It’s great that you’ve added it to the beta / future woo block editor!
Really sorry to say though, that’s not the block editor I meant.

For years, myself and others have been enabling the block editor on woocommerce product edit pages. Some themes have a built in way to enable or toggle it, or it can be done in child theme with a snippet similar to this:

add_filter('use_block_editor_for_post_type', function ($is_enabled, $post_type) {
    if ($post_type === 'product') {
        return true; // Enable the block editor for WooCommerce products
    }
    return $is_enabled;
  }, 10, 2); 

This enables the block editor in the long description, but also removes your subtitle field (as it appears adding custom fields below the title isn’t an option with this product block editor enabled):

For now, I’ve found work around and have added the subtitle field to the advanced tab within the product data panel:

Using the follow two functions in my child theme:

function add_pswc_subtitle_field_to_product_data_panel() {
    global $post;
    $subtitle = get_post_meta($post->ID, 'pswc_subtitle', true);
    ?>
    <div class="options_group">
        <p class="form-field">
            <label for="pswc_subtitle"><?php esc_html_e('Subtitle', 'my-child-theme'); ?></label>
            <input type="text" class="short" name="pswc_subtitle" id="pswc_subtitle" value="<?php echo esc_attr($subtitle); ?>" />
            <span class="description"><?php esc_html_e('Enter a subtitle for this product.', 'my-child-theme'); ?></span>
        </p>
    </div>
    <?php
}
add_action('woocommerce_product_options_advanced', 'add_pswc_subtitle_field_to_product_data_panel');

function save_pswc_subtitle_field($post_id) {
    if (isset($_POST['pswc_subtitle'])) {
        update_post_meta($post_id, 'pswc_subtitle', sanitize_text_field($_POST['pswc_subtitle']));
    }
}
add_action('woocommerce_process_product_meta', 'save_pswc_subtitle_field(');

Works well for me, but thought I’d share!

Many thanks

Hi, thanks for your reply.

Sorry, you miss-understand what I meant, I probably wasn’t clear enough.
I can add the block (as show in your video), no problem.

The issue I have is that on the product edit screen for each product (posttype product) there is no field available to enter the subtitle value.

If I turn off the block editor (for product edit screen), then the subtitle field is there just below the title when using the classic editor. However, all of our products use the block editor in their long description so the classic editor isn’t an option for us.

I have found a work-around though. I also used AdminColumns Pro plugin, and have managed to add the subtitle post_meta field as an editable column in WooCommerce’s admin product listing.

My product edit screen below, showing no sub-title field.

Best regards

Hey James – many thanks for the info. All makes sense.

This led me to investigate the Object Cache Pro plugin a little further.

It appears to have a strict check (using get_plugin_data()) to see if the metadata at the top of the object-cache.php file matches what it expects (checking against it’s own copy of the file). Therefore, unfortunately, despite the include/require at the bottom of your plugin’s object-cache.php (which I guess would work in the majority of scenarios), the metadata at the top of your object-cache.php doesn’t match, causing Redis object cache Pro to flag the object-cache.php as invalid and disables itself.

Suspect you will consider this as an edge-case, but thought I’d share anyway.

Many thanks.