Woocomerce Back in Stock Product Help

[kolliop]

Hi to all friend,

i need some help about back in stock product in woocommerce.

i want to create one page with product grid, and i wan to display this page the last 350 product when is back to stock ,

or as new product when is again back to stock. When i add stock and some product is 0 and afet is for example 5, then this product is back in stock.

then i want to display in one page as this is my back in stock product

can help anyone for this?

i dont want Waiting List, only to display all back in stock in a page.

Thanks any way for your time

 

[frizzel]

I don't think there's an automatic way of doing that, as it would clash with the way WooCommerce handles stock statuses. The only way this can be done - I think - is to add a custom stock status, select that while you change the inventory, and filter your products based on that status.

 

[kolliop]

Thank a lot frizzel, thats nice idea, can you help me how to do that?

 

[frizzel]

Yup, here's some code you need to put in functions.php of your child theme (or in a custom code plugin):

// Add the extra option 'Back in Stock' to the dropdown on the product edit page
function filter_woocommerce_product_stock_status_options( $status ) {
    $status['back_in_stock'] = __( 'Back in Stock!', 'woocommerce' );
    return $status;
}
add_filter( 'woocommerce_product_stock_status_options', 'filter_woocommerce_product_stock_status_options', 10, 1 );

// The text to display on the front-end (if needed)
function filter_woocommerce_get_availability_text( $availability, $product ) {
    switch( $product->get_stock_status() ) {
        case 'back_in_stock':
            $availability = __( 'Back in Stock!', 'woocommerce' );
        break;
    }
    return $availability;
}
add_filter( 'woocommerce_get_availability_text', 'filter_woocommerce_get_availability_text', 10, 2 );

// Add a class to <li> for use in css styling (if needed)
function filter_woocommerce_get_availability_class( $class, $product ) {
    switch( $product->get_stock_status() ) {
        case 'back_in_stock':
            $class = 'back-in-stock';
        break;
    }
    return $class;
}
add_filter( 'woocommerce_get_availability_class', 'filter_woocommerce_get_availability_class', 10, 2 );

// Display the custom status in the back-end product list
function filter_woocommerce_admin_stock_html( $stock_html, $product ) {
    switch( $product->get_stock_status() ) {
        case 'back_in_stock':
            $stock_html = '<mark class="pre-order" style="background:transparent none;color:#33ccff;font-weight:700;line-height:1;">' . __( 'Back in Stock', 'woocommerce' ) . '</mark>';
        break;
    }   
    return $stock_html;
}
add_filter( 'woocommerce_admin_stock_html', 'filter_woocommerce_admin_stock_html', 10, 2 );

But then of course you need a shortcode to display the Back In Stock products on a page. So, a little more code:

// The code to add a custom attribute to woocommerce products shortcode
function htdat_shortcode_atts_products( $out, $pairs, $atts, $shortcode ){
  if ( isset ($atts[ 'backinstock' ]) && $atts [ 'backinstock' ] ) {
    $out[ 'backinstock' ] = true;
  } else {
    $out[ 'backinstock' ] = false;     
  }
  return $out;
}
add_filter('shortcode_atts_products', 'htdat_shortcode_atts_products', 10, 4);

// And then what the shortcode attribute 'backinstock' actually does
function handle_custom_query_var( $query, $attributes  ) {
    if ( $attributes[ 'backinstock' ] ) {
        $query['meta_query'][] = array(
            'key' => '_stock_status',
            'value' => 'back_in_stock',
            'compare' => 'IN',
        );
    }
    return $query;
}
add_filter( 'woocommerce_shortcode_products_query', 'handle_custom_query_var', 10, 2 );

And the shortcode is : [products backinstock="true"]

Hope this helps.

 

[kolliop]

thanks a lot my bro
but this php code where i add ?
PHP:
// The code to add a custom attribute to woocommerce products shortcode
function htdat_shortcode_atts_products( $out, $pairs, $atts, $shortcode ){
if ( isset ($atts[ 'backinstock' ]) && $atts [ 'backinstock' ] ) {
$out[ 'backinstock' ] = true;
} else {
$out[ 'backinstock' ] = false;
}
return $out;
}
add_filter('shortcode_atts_products', 'htdat_shortcode_atts_products', 10, 4);

// And then what the shortcode attribute 'backinstock' actually does
function handle_custom_query_var( $query, $attributes ) {
if ( $attributes[ 'backinstock' ] ) {
$query['meta_query'][] = array(
'key' => '_stock_status',
'value' => 'back_in_stock',
'compare' => 'IN',
);
}
return $query;
}
add_filter( 'woocommerce_shortcode_products_query', 'handle_custom_query_var', 10, 2 );

 

[kolliop]

all code in child theme? in function.php ?

 

[frizzel]

all code in child theme? in function.php ?

Yup, here's some code you need to put in functions.php of your child theme (or in a custom code plugin):

Oh, I see, you mean the last section I shared: yes, everything goes into functions.php

 

[kolliop]

hi my friend many many many thanks. it work perfect. one more think.

its possible to order and short by date?

when one product is back in stock to show fist in the list, for example when is back to stock for 0 to 10 items to short first as new produt for example

and if it is possible to show only 500 first product back in stock or if i have choice to show 100, 200, 300, 500

is about shortcode ? for that?

 

[frizzel]

You can expand the query array with many more arguments, e.g.:

'orderby' => 'date', //that's the date it was first published, woocommerce products shortcode does not by default include ordering by date modified, unfortunately
'order' => 'DESC',
'limit' => 300, // (the number of products you want to show in total, but if you also use the next 'pagination' argument, then it is the number of products per page)
'pagination' => true

Etc., etc. read more about the products shortcode here: https://docs.woocommerce.com/document/woocommerce-shortcodes/

 

[kolliop]

your help is amazing, thanks a lot

 

[kolliop]

your help is amazing, thanks a lot,
its possibole to show only the back in stock product with orderby = the date to change the stock from 0 to ...10 for example, and not the date to puplish the product

or

if when is back to stock to for example from 0 to 20.... to change auto the date as new product ?

 

[frizzel]

No, you cannot change the published date. As said in the code above WooCommerce doesn't include order by modified date in its 'products' shortcode, unfortunately. However there are tricks to order products by modified date, e.g. as a choice in the sorting dropdown and making that the default choice. The code for that you can find on stackoverflow: Set custom product sorting as default in WooCommerce.

But then we're having a problem on the custom page which does not have that sorting dropdown (or do you? Because then your problem is solved already).

Even without the dropdown you can make it work by adding '?orderby=modified_date' to the url, but I'm quite sure you don't want that. However, that made me thinking: well, if it works with a simple url add-on there must be a way to get that sorting by default, but how?

Do you know that feeling that something's on the tip of your tongue but you just cannot get to it? Well, I have that feeling with this one. I know I'm close, but just not exactly there, yet.

 

[frizzel]

I knew it was something simple. Found a solution using 'pre_get_posts' function in WordPress. The code beneath is for a page with the slug 'products-back-in-stock', of course you should change that to your own page slug.

// Sort Products by modified date when using WooCommerce's products shortcode
function backinstock_pre_get_posts( $query ) {
    // do not modify queries in the admin
    if ( is_admin() ) {
        return $query;
    }
    // only modify queries on the page where you have your shortcode [products backinstock=true]
    if( is_page('products-back-in-stock')) {
        $query->set('orderby', 'modified');
        $query->set('order', 'DESC');
    }
    return $query;
}
add_action('pre_get_posts', 'backinstock_pre_get_posts');

For the above code to work, you need to have empty values for orderby and order in your shortcode query, like so:

            'key' => '_stock_status',
            'value' => 'back_in_stock',
            'compare' => 'IN',
            'orderby'  => '',
            'order'    => '',

I think that's needed, because of the products shortcode set-up.

If you don't want to alter the default sorting on other pages, you can just forget the code in the link in my previous post above.

 

[kolliop]

thanks a lot myfriend, i dont find any word to thank you, your help is amazing... and sory for my bad english....

Many many thanks, ill try and i tell you.