WooCommerce – Find Downloadable Products Missing Files Quickly

Learn how to find downloadable WooCommerce products missing their downloadable files.

If you sell hundreds of e-books, for example, you need to make sure that all products have the e-book file, so the customers can download them after the purchase.

Now, if you try to find all downloadable products without files, it could take you several hours to do it with the normal WP editor.

That’s why we’ll show you how to find all downloadable products missing downloadable files, so you can edit the products and publish them.

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 quickly filter and edit hundreds of products.

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

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

2. Find all downloadable products missing downloadable files

If you want to find all your downloadable products missing downloadable files, you need to use the Search tool. So you need to open it by clicking it on the toolbar above the spreadsheet.

a) Filter all downloadable products without downloadable files

After opening the Search tool, you need to look for the downloadable products missing their downloadable files. For that, you need to take the following steps:

• Check the Enable advanced filters’ checkbox.
• Field: Downloadable (_downloadable)
• Operator: Select the “equal” sign.
• Check the Value checkbox.
• Hit Add new to add another advanced filter.

Then, you need to look for the missing downloadable files.

• Field: Look for the Download files field (_downloadable_files)
• Operator: Choose the “less than” sign.
• Value: Leave the field empty or enter “0”
• Hit the Run search button.

b) Find downloadable products missing downloadable files by keyword

Sometimes you may want to find specific products, for example, you can look for all products containing a specific keyword.

Fortunately, the Search tool makes it really easy for you to look for products by keyword.

Once the tool is open, write the product keyword in the “Contains keyword” field. For example, you may look for all products containing the “Shirt” keyword.

Then, just do this to look for downloadable products containing that keyword:

• Check the Enable advanced filters checkbox
• Select the field Downloadable (_downloadable)
• Select the equal (=) sign as the operator
• Check the Value checkbox
• Hit Add new to add another advanced filter.

Then, you need to look for the missing downloadable files:

• Field key: Download files (_downloadable_files)
• Operator: Choose the = sign
• Value: Write “0” or leave the field empty
• Hit the Run search button.

c) Search for all downloadable products missing downloadable files by category, attribute, or tag

WP Sheet Editor helps you easily and quickly find downloadable products missing files by category, attribute, or tag.

All you need to do is to open the Search tool to look for them.

After you’ve opened the tool, you need to write the category, attribute, or tag in the “Enter Product category…” field. It’s a great advantage that WP Sheet Editor uses the same field to 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 downloadable products:

• Enable the advanced filters‘ checkbox.
• Find the column Downloadable (_downloadable) in the Field key
• Select the equal (=) sign as the operator
• Check the Value checkbox.
• Hit Add new to add another advanced filter.

Then, you need to look for the missing downloadable files:

• As the Field key, select Download files (_downloadable_files)
• Use the operator equal (=)
• Write “0” in the value field or leave it empty
• Hit the Run search button.

d) Look for downloadable products missing files by date range

Sometimes you want to find all downloadable products uploaded during a specific date range that are missing downloadable files.

For example, you may look for products uploaded from August 1 to October 31, 2022.

After opening the Search tool, you need to set these values to look for your downloadable products uploaded during that date range, which are missing files.

• Enable the advanced filters
• Field: Use the Downloadable (_downloadable) column
• Operator: Select the equal (=) sign
• Value: Check the checkbox
• Add a new advanced filter

Then, you need to look for the missing downloadable files:

• Field: Write Download files (_downloadable_files)
• Operator: Choose the equal (=) sign
• Value: Write “0” or leave the field empty
• Hit the Run search button.

Now you can write the date range in the date fields. Write the initial date and the final date of the period of time you want to look for.

3. Edit downloadable files

Now that you can see the products missing their downloadable files, you can edit them in the spreadsheet or in bulk, as you can see in the tutorials below:

a) Bulk Edit Downloadable Files

b) Copy Downloadable Files From One Product to Hundreds

c) Increase or decrease the download limit to product files

4. Import downloadable files to existing products

If you already have the download URLs you need to add to the products, you can import this information from a CSV file.

This file needs to have the product name or ID, and the columns “Download 1 name” and “Download 1 URL”.

Once in the WP Sheet editor plugin, go to the toolbar and open the import tool.

Now enter the source and the document to be imported.

Select to import all the columns.

In this case, we only want to add information to existing products, select the Update existing items, ignore new items option.

Select a column that is in the CSV file and on WordPress to assign the information to the correct products.

Check that the plugin is placing the information in the correct fields and start the import.

When the import is finished, you will see that the “Download 1 name”, “Download 1 URL” and “Download files” fields have been updated.

Now you know that there is an easy and fast way to find your downloadable products missing downloadable files and edit them, either individually or in bulk.

You can do these and other searches and changes with WP Sheet Editor. Get it now!