WooCommerce – Find Downloadable Products Missing Download Files

Let’s take a look at how to search for WooCommerce downloadable products missing download files.

Sometimes we just create the products and don’t add download files, maybe because we forget to do it.

However, downloadable products missing files can be a headache and make us lose many conversions.

Hence, the importance of being able to find all downloadable products that have no download files in order to edit or remove them.

For this, we will use the WP Sheet Editor – WooCommerce Products plugin.

It allows you to manage your WooCommerce products in an intuitive spreadsheet on WordPress.

The plugin contains advanced tools that allow you to run advanced searches with a few clicks, bulk update any field in hundreds of products, export products to CSV files, and import products with a few clicks.

Open the spreadsheet

After installing and activating the plugin, go to WP Sheet Editor > Edit Products, and you’ll see all your WooCommerce products displayed in the spreadsheet.

Open the “Search” tool

The Search tool allows you to filter all the WooCommerce products on your store using any field as a search parameter.

In this case, it will allow you to search for all the products that are 1) downloadable and 2) missing download files.

Example 1: Search for all downloadable products missing download files

Let’s search for all WooCommerce downloadable products missing download files by selecting these values in the Search tool:

• Tick the Enable advanced filters checkbox.
• Advanced filter 1:
  • Field: Downloadable
  • Operator: =
  • Value: Tick the checkbox.
• Advanced filter 2:
  • Field: Download files
  • Operator: =
  • Value: Leave this field empty.
• Click on Run search.

After running the search, you’ll see all downloadable products missing download files displayed in the spreadsheet.

You can see all the active search filters above the spreadsheet.

Example 2: Downloadable products missing files by KEYWORD

Let’s look for all products that contain a keyword in the title (“Wallpaper” for example), are downloadable products, and are missing download files.

You need to select these values in the Search tool:

• Contains keyword: Enter the keyword here.
• Tick the Enable advanced filters checkbox.
• Advanced filter 1:
  • Field: Downloadable
  • Operator: =
  • Value: Tick the checkbox.
• Advanced filter 2:
  • Field: Download files
  • Operator: =
  • Value: Leave this field empty.
• Click on Run search.

After running the search, all products containing a specific keyword and missing files will be displayed in the spreadsheet.

Example 3: Downloadable products missing files by CATEGORY

Let’s search for all products that contain a specific category (“Downloads” for example), are downloadable products, and do not have download files.

We need to select these values in the Search tool:

• Taxonomies: Enter the product category here. This field allows product type, visibility, categories, tags, shipping classes, attributes, etc.
• Tick the Enable advanced filters checkbox.
• Advanced filter 1:
  • Field: Downloadable
  • Operator: =
  • Value: Tick the checkbox.
• Advanced filter 2:
  • Field: Download files
  • Operator: =
  • Value: Leave this field empty.
• Click on Run search.

Here you can see we have filtered all the downloadable products within the “Wallpapers” category. These products don’t have download files.

Example 4: Downloadable products missing files by DATE RANGE

We can also search for products by date range.

For example, we can search for all products created between January 1 and January 31, 2024, that are downloadable products and have no download files.

Just select these values in the Search tool:

• Tick the Enable advanced filters checkbox.
• Advanced filter 1:
  • Field: Downloadable
  • Operator: =
  • Value: Tick the checkbox.
• Advanced filter 2:
  • Field: Download files
  • Operator: =
  • Value: Leave this field empty.
• Date range from: Enter the initial date here.
• To: Enter the final date here.
• Click on Run search.

As you can see below, we have filtered all our downloadable products missing files, which were created between between January 1 and January 31, 2024.

Did you notice how easy it is to find your WooCommerce downloadable products missing files with WP Sheet Editor?

You can quickly and easily do these and other advanced searches and bulk edits.