WooCommerce – How to Find Products Missing Images

WooCommerce – How to Find Products Missing Images

Sometimes when you create a WooCommerce store, you don’t set up some products completely. For example, those products may be missing images because your client didn’t give you the pictures for whatever reason; maybe the pics were not ready.

One way or another, there’s some point in which your client asks you to find all products missing images in order to give you the necessary photos to upload them to the products.

However, that can be really difficult because you may have hundreds or even thousands of products missing images and the normal WP editor doesn’t give you any search tool that can help you filter the products to find the ones missing images.

That’s why in this tutorial we’ll teach you how to find all your products missing images with WP Sheet Editor. Here you’ll learn to filter them by keyword, category, attribute, tag, and how to find all downloadable products missing images.

1- Install WP Sheet Editor

WP Sheet Editor makes it easier for you to manage your WooCommerce store because it has a powerful bulk updates tool that helps you filter and edit hundreds of products quickly.

You can skip this step if you have the plugin installed and activated.

You can download the plugin here:

Download WooCommerce Products Spreadsheet Plugin - or - Read more

Once you open the plugin, you’ll see a spreadsheet containing all your products and their complete information.

The key tool in this tutorial is the “Search” tool WP Sheet Editor contains. This tool helps you filter your products in many different ways and do combined searches. So you need to open it by clicking it on the toolbar above the spreadsheet.

After opening the tool, you’ll see different fields to help you look for products by keyword, category, etc. However, to look for all the products missing images you need to use the advanced filters tool.

So you need to check the “Enable the advanced filters” checkbox, which will open fields you need to look for your products missing images.

After enabling the advanced filters you need to set these values to find your products missing images.

  • Write “_thumbnail_id” in “Field key”.
  • Select the “equal” sign.
  • Write “0” in the “Value” field.
  • Hit the “Run search” button.
  • Done! After that, your products will be filtered and all products missing images will be displayed in the spreadsheet.

Another way to look for your products missing images is to filter them by keyword. For example, you may look for all the products containing the “Shirt” keyword.

All you have to do is to open the search tool.

Then just write the product keyword in the “Contains keyword” field.

After that, you need to take these easy steps to look for your products missing images:

  • Check the “Enable advanced filters” checkbox.
  • Write “_thumbnail_id” in “Field key”.
  • Select the “equal” sign.
  • Write “0” in the “Value” field.
  • Hit the “Run search” button.
  • Done! All products containing the “Shirt” keyword that are missing images will be filtered and displayed in the spreadsheet.

With WP Sheet Editor it’s really easy to find your products missing images by category, attribute, or tag. All you need to do is to open the “Search” tool and then set the necessary values.

After opening the tool, you need to write the product category, attribute, or tag in the “Enter product category…” field. It’s great that WP Sheet Editor uses that same field to help you look for your products in those three ways.

After writing the product category, attribute, or tag, you need to set the values to look for the products missing images:

  • Check the “Enable advanced filters” checkbox.
  • Write “_thumbnail_id” in “Field key”.
  • Select the “equal” sign.
  • Write “0” in the “Value” field.
  • Hit the “Run search” button.
  • Done!

With WP Sheet Editor, it’s really easy to find your downloadable products missing images. You only need to open the “Search tool” and set the necessary values. Open the tool by clicking it on the toolbar above the spreadsheet.

After opening the tool, you need to enable advanced filters.

It’s really easy, just check the “Enable advanced filters” checkbox.

After that, you need to set these values to look for the downloadable files:

  • Write “_downloadable” in “Field key”.
  • Choose the equal sign.
  • Check the “Value” checkbox. It means your products are downloadable.

Then, you need to hit the “Add new” button to add a new advanced filter, which will help you find the products missing images.

In this new advanced filer, you need to set these values:

  • Write “_thumbnail_id” in “Fild key”.
  • Select the “Equal” sign in “Operator”.
  • Write “0” in the “Value” field.
  • Hit the “Run search” button.

For example, if you want to find all products uploaded in December 2018 that are missing images, you need to use the “Search” tool and set the necessary values.

After opening the “Search” tool, you need to enter the date range in the date fields. Write the initial and the final date of the period of time you’re looking for.

Then, you need to enable the advanced filters to look for the products missing images, so check the “Enable advanced filers” checkbox, and it’ll open the fields for you to execute the search.

Once there, set these values:

  • Write “_thumbnail_id” in “Fild key”.
  • Select the “Equal” sign in “Operator”.
  • Write “0” in the “Value” field.
  • Hit the “Run search” button.

Done!

As you can see, finding your products missing images is really a piece of cake with WP Sheet Editor.

You should get it now and experience how this plugin makes it considerably easier for you to manage your WooCommerce store.

You can download the plugin here:

Download WooCommerce Products Spreadsheet Plugin - or - Read more

Do you need help?

You can receive instant help in the live chat during business hours, or you can contact us and we will help you via email.

Close Menu