Woocommerce returns Product post_status as published even tho it is in status draft

Question

Heyho,

I've got a problem getting the post_status of a WP_PostObject which is a Woocommerce-Product. I get all products doing this query:

$onlineShopProducts = get_posts([
            'post_type' => ['product', 'product_variation'],
            'orderby' => 'post_title',
            'order' => 'ASC',
            'numberposts' => -1
        ]);

Now I want to filter out all products which are in status draft during a foreach-loop:

foreach ($onlineShopProducts as $onlineShopProduct){
            if($onlineShopProduct->post_status != 'publish'){
                continue;
            }
            doSomething($onlineShopProduct)
        }

but $onlineShopProduct->post_status and get_post_status($onlineShopProduct->ID) both return "publish", even tho they are set "Draft" in the product-edit-view... (it's in german)

is there some sort of post_meta I have to query or is this a know bug of some sort? How can I filter out the drafted products?

Greetings

Answer 1

The solution is simple, delete the if check you're having problems with, and add the post_status parameter to get_posts.

For example:

$args = [
    'post_status' => 'publish',
    'suppress_filters' => false,
];
$only_published_posts = get_posts( $args );

Notice I added suppress_filters and set it to false so that it can be sped up.

Likewise we can pass an array of the statuses we do want, e.g.

$args = [
    'post_status' => [ 'publish', 'pending' ],
    'suppress_filters' => false,
];
$only_published_and_pending_posts = get_posts( $args );

Or everything except published posts:

$args = [
    'post_status' => [ 'future', 'draft', 'pending' ],
    'suppress_filters' => false,
];
$not_published = get_posts( $args );

Or private posts:

$args = [
    'post_status' => [ 'private' ],
    'suppress_filters' => false,
];
$private_posts = get_posts( $args );

Or all post statuses, including revisions and auto drafts:

$args = [
    'post_status' => 'any',
    'suppress_filters' => false,
];
$all_posts = get_posts( $args );

There are a limited number of post statuses that come with core, and they're hard coded, so you can just list the ones you want, and omit the ones you don't.

More information at: https://developer.wordpress.org/reference/classes/wp_query/#status-parameters

Note that while this is the canonical standard WordPress method, plugins may employ custom post statuses, or ignore statuses altogether if they are poorly built. In these situations you will need to contact their dev support routes.

Answer 2

If anyone else comes here looking for this and doesn't get the answer, a Product's Variation can be set to Status Publish even when the Main Product is set to Draft. That's what was happening to me. So the product was set to draft, but the variation was set to Publish.