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 the WooCommerce Products Spreadsheet plugin. Here you’ll learn to filter them by keyword, category, attribute, tag, and how to find all downloadable products missing images.

Install the WooCommerce Products Spreadsheet

This plugin 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.

Important

Each section contains the VIDEO guide and the TEXT instructions. 🙂

Video Guide

Text Guide

The key tool in this tutorial is the Search tool WP Sheet Editor contains. This tool helps you filter your products in many 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.

  • Field key: thumbnail
  • Operator: =
  • Value: 0
  • Hit the Run search button.

Done! After that, your products will be filtered and all products missing images will be displayed in the spreadsheet.

Video Guide

Text Guide

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:

  • Tick the Enable advanced filters checkbox.
  • Field key: thumbnail
  • Operator: =
  • Value: 0
  • Hit the Run search button.

Done! All products containing the “Shirt” keyword that are missing images will be filtered and displayed in the spreadsheet.

Video Guide

Text Guide

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 tags 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:

  • Tick the Enable advanced filters checkbox.
  • Field key: thumbnail
  • Operator: =
  • Value: 0
  • Hit the Run search button.

Video Guide

Text Guide

With WP Sheet Editor, it’s really easy to find your downloadable products missing images. You only need to open the Search 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 tick the Enable advanced filters and apply these two filters.

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

  • Field key: Downloadable
  • Operator: =
  • Value: Tick this checkbox

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 filter, you need to set these values:

  • Field key: thumbnail
  • Operator: =
  • Value: 0
  • 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 filters checkbox, and it’ll open the fields for you to execute the search.

Just select these values:

  • Field key: thumbnail
  • Operator: =
  • Value: 0
  • Select the initial date in “Date range from”
  • Select the final date in “to”
  • 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