WooCommerce – Find Downloadable Products Missing Downloadable Files

posted in: Guides | 0

Sometimes when you create a new WooCommerce store you don´t have all the information since the beginning, maybe your client only gave you the product titles and images but didn´t give you the product files.

So you create a lot of Downloadable Products, set up all the product information, but leave empty the downloadable files options.

Then the client sends you a few files and you start adding them to the products.

But you need to know how many products are missing files, so you can ask the files to your client.

Does this sound familiar to you? 🙂

In this tutorial 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 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:

- or - Read more about it

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

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.

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

  • Check the “Enable advanced filters” checkbox.
  • Write “_downloadable” in “Field key”.
  • 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.

  • Write “_downloadable_files” in “Field key”.
  • Choose the “less than” sign.
  • Write “1” in the “Value” field.
  • Hit the “Run search” button.

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

Fortunately, WP Sheet Editor makes it really easy for you to look for products by keyword.

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

Then 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.
  • Write “_downloadable” in “Field key”.
  • 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:

  • Write “_downloadable_files” in “Field key”.
  • Choose the “less than” sign.
  • Write “1” in the “Value” field.
  • Hit the “Run search” button.

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 “Search” 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:

  • Check the “Enable advanced filters” checkbox.
  • Write “_downloadable” in “Field key”.
  • 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:

  • Write “_downloadable_files” in “Field key”.
  • Choose the “less than” sign.
  • Write “1” in the “Value” field.
  • Hit the “Run search” button.

Sometimes you want to find all downloadable products uploaded during a specific date range which are missing downloadable files. For example, you may look for products uploaded from December 1 to December 31, 2018.

For this, you need to open the “Search” tool by clicking it on the toolbar above the spreadsheet.

Then, you need to 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.

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

  • Check the “Enable advanced filters” checkbox.
  • Write “_downloadable” in “Field key”.
  • 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:

  • Write “_downloadable_files” in “Field key”.
  • Choose the “less than” sign.
  • Write “1” in the “Value” field.
  • Hit the “Run search” button.

Done!

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

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

You can download the plugin here:

- or - Read more about it

Leave a Reply