WooCommerce: Admin Filter To Discover Merchandise With out A Product Picture Set

We’re serving to a consumer that has a WordPress WooCommerce website that was shedding search engine visibility for years as a consequence of a whole lot of code, configuration, and content material points from years of neglect, put in and uninstalled plugins, and dozens of themes.

With the brand new website launched, we’ve been observing the efficiency of the location and not too long ago acquired the next Google Search Console message:

We have been shocked that the corporate had merchandise listed in WooCommerce that didn’t have a product picture set. After we crawled the newly launched website, we didn’t see any issues… this was as a result of the brand new theme had a placeholder picture that appeared each time a picture was not set. In consequence, there have been no errors for photos not discovered.

WooCommerce Merchandise Listing

Our subsequent step was to determine the merchandise inside the website the place there have been no photos set. That’s not a straightforward job when there are a whole lot of merchandise to filter by means of. In consequence, we wrote our personal filter in WooCommerce merchandise to filter the listing to merchandise with no product picture set.

Now we will simply browse the listing and replace the product photos the place crucial with out effort. Right here’s how we did it.

Add Filter To WooCommerce Admin Merchandise Listing

Inside the consumer’s baby theme capabilities.php web page, we added the next two sections of code. First, we construct the filter discipline:

// Add a filter on product for set product picture
add_action('restrict_manage_posts', 'filter_products_by_image_presence');
operate filter_products_by_image_presence() {
    international $typenow;
    $chosen = isset($_GET['product_image_presence']) ? $_GET['product_image_presence'] : '';
    if ('product' === $typenow) {
        ?>
        <choose title="product_image_presence" id="product_image_presence">
            <possibility worth="">Filter by product picture</possibility>
            <possibility worth="set" <?php chosen('set', $chosen); ?>>Picture Set</possibility>
            <possibility worth="notset" <?php chosen('notset', $chosen); ?>>Picture Not Set</possibility>
        </choose>
        <?php
    }
}

Right here’s a step-by-step rationalization of what every a part of the code does:

• add_action('restrict_manage_posts', 'filter_products_by_image_presence');
  • This line hooks into restrict_manage_posts, which is an motion triggered within the WordPress admin space, permitting you so as to add additional filtering choices to the posts listing. Right here, it’s used so as to add a brand new filter to the WooCommerce merchandise listing.
• operate filter_products_by_image_presence() { ... }
  • This block defines the operate filter_products_by_image_presence, which outputs HTML for a brand new dropdown choose filter on the product admin display screen.
• international $typenow;
  • The worldwide variable $typenow is used to test the kind of the present publish listing to make sure that the customized filter is barely added to the ‘Merchandise’ publish sort screens and never others.
• $chosen = isset($_GET['product_image_presence']) ? $_GET['product_image_presence'] : '';
  • This line checks if there may be an energetic filter set by in search of the ‘product_image_presence’ parameter within the URL, which is handed as a GET request when you choose a filter possibility and submit the filter. It shops the present choice to retain the chosen state of the filter after the web page reloads.
• if ('product' === $typenow) { ... }
  • This conditional assertion checks whether or not the present publish sort is ‘product’, making certain the code contained in the if-statement solely runs for WooCommerce merchandise.
  • All the pieces between ?> and <?php is HTML output, together with the choose dropdown with choices for filtering by merchandise with ‘Picture Set’ or ‘Picture Not Set’. PHP is interspersed to deal with dynamic choice through the chosen() operate, which outputs the chosen attribute if the present $chosen worth matches the choice worth.
  • The chosen() operate is a WordPress helper operate that compares the primary argument with the second and in the event that they match, it outputs ‘chosen=”chosen”‘, which is the HTML attribute wanted to indicate an possibility as chosen in a dropdown.

This code successfully provides a dropdown filter to the merchandise listing, enabling the admin to filter the listing by merchandise which have a picture set or not. This extra filter would assist customers handle massive catalogs, making certain merchandise adhere to retailer itemizing necessities, together with having photos assigned as a part of the itemizing high quality management.

Execute Question on WooCommerce Admin Merchandise Listing

Subsequent, we now have so as to add a question that may execute and discover the merchandise that don’t have any picture set.

add_filter('parse_query', 'filter_products_query_by_image_presence');
operate filter_products_query_by_image_presence($question) {
    international $pagenow, $typenow;

    if ('edit.php' === $pagenow && 'product' === $typenow && isset($_GET['product_image_presence']) && $_GET['product_image_presence'] != '') {
        $presence = $_GET['product_image_presence'];
        $meta_query = array(
            'relation' => 'OR',
            array(
                'key' => '_thumbnail_id',
                'examine' => 'NOT EXISTS'
            ),
            array(
                'key' => '_thumbnail_id',
                'worth' => '0'
            )
        );

        if ('set' === $presence) {
            $meta_query = array(
                array(
                    'key' => '_thumbnail_id',
                    'examine' => 'EXISTS'
                ),
                array(
                    'key' => '_thumbnail_id',
                    'worth' => array('', '0'), // Assuming '0' or '' could possibly be placeholders for no picture.
                    'examine' => 'NOT IN'
                ),
            );
        } elseif ('notset' === $presence) {
            $meta_query = array(
                'relation' => 'OR',
                array(
                    'key' => '_thumbnail_id',
                    'examine' => 'NOT EXISTS'
                ),
                array(
                    'key' => '_thumbnail_id',
                    'worth' => '0'
                )
            );
        }

        $query->set('meta_query', $meta_query);
    }
}

This code snippet is for modifying the principle WordPress question for product listings within the admin space to permit filtering merchandise primarily based on whether or not they have an related picture. Right here’s a proof of its parts:

• add_filter('parse_query', 'filter_products_query_by_image_presence');
  • This line attaches the filter_products_query_by_image_presence operate to the parse_query filter hook, which is used to regulate the principle question that WordPress makes use of to retrieve posts (or customized publish sorts like merchandise) within the admin listing desk.
• operate filter_products_query_by_image_presence($question) { ... }
  • This operate is outlined to switch the product listing question primarily based on the presence of product photos. The $question variable is an occasion of the WP_Query class, handed by reference, which implies any adjustments to this object will have an effect on the precise question WordPress runs.
• international $pagenow, $typenow;
  • These international variables are WordPress atmosphere variables. $pagenow is used to test the present admin web page, and $typenow to test the present publish sort.
  • The conditional assertion checks if the present web page is ‘edit.php’ (the default web page for itemizing posts and customized publish sorts), the publish sort is ‘product’ (which implies we’re on the WooCommerce merchandise listing), and if a filter has been set by means of a GET parameter named ‘product_image_presence’.
• A brand new meta question array is created primarily based on the worth of ‘product_image_presence’. This array is designed to create the situations for filtering merchandise with or with out photos.
  • The relation key set to ‘OR’ signifies that any of the situations inside will be true for the meta question to retrieve the merchandise.
  • If the filter is about to ‘set’, a brand new $meta_query is created to search out merchandise with photos. Merchandise which have a ‘_thumbnail_id’ (which implies a picture is about) and never an empty string or ‘0’ are included.
  • If the filter is about to ‘notset’, the meta question appears to be like for merchandise the place the ‘_thumbnail_id’ meta key both doesn’t exist or is about to ‘0’, which might imply there isn’t any picture related to the product.
• $query->set('meta_query', $meta_query);
  • This line modifies the principle question by setting the ‘meta_query’ with the situations outlined in $meta_query.

This customization helps a WooCommerce retailer admin to shortly discover merchandise missing photos, which is essential for stock administration, advertising, and gross sales methods, as merchandise with photos usually tend to promote and supply prospects with the required visible data. By making certain product listings are full with photos, gross sales and advertising efforts will be more practical.