WooCommerce – How to Bulk Edit Downloadable Files

Learn how to edit downloadable files from WooCommerce products in bulk.

Sometimes you sell digital products with music or video files, or you have physical products that contain PDF manuals.

For example, you can sell “hardware tools” and all the wrenches might have the same user manual, or all the recipe books might include the same PDF as a gift.

So you’re editing a lot of downloadable products, and you need to update the file URLs quickly.

How do you do it? Do you go product by product, editing each file? Or do you know another way to do it?

In this article, we’ll show you how to bulk edit downloadable files using a spreadsheet.

1. Install the WP Sheet Editor Products Spreadsheet plugin

WP Sheet Editor provides a Products Spreadsheet where you can see all the product information, and you can edit freely.

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

Open the Sheet Editor Plugin

The plugin looks like this:

2. Add download file URL to products INDIVIDUALLY in the spreadsheet

If you want to update individual download file products:

• Go to the Download files column by right scrolling in the spreadsheet.
• Hit the Edit files button to edit a rows’ download files.

Now do this in order to add download file URLs to your products.

• Name: Select a name for the downloadable file
• File (url or path): Paste the URL in this column
• Repeat this process the times you need to add more than one download files.

3. ADD a file URL to the existing files in hundreds of products

If you have a product with some download file URLs and want to add one more URL, then you need to do this:

• Open the Bulk Edit tool. It’s located on the plugin’s toolbar, so just click on it.
• Select the I want to search rows to update option in the Select the rows that you want to update

Here you can filter the products you’ll edit. You’ll find these fields:

• Contains keyword – Use this field to filter all the products containing a specific keyword
• Enter Tags – Use this field to search for products containing categories, tags, attributes, shipping classes. This same field works for those search methods.
• Run search – Click on it after selecting your search method.

In the Bulk Edit fields, set these values to append/add a download file URL to the existing files in the products filtered.

• What field do you want to edit – Download files
• Select type of edit – Append
• Enter the value to append to the existing value – Paste the new URL into this field.
• Click on Execute now.

4. REPLACE download files in hundreds of products

To replace download file URLs in hundreds of products, you need to follow these simple steps:

• Open the Bulk Edit It’s located on the plugin’s toolbar, so just click on it.
• Select the I want to search rows to update option in the Select the rows that you want to update

Here you can filter the products you’ll edit. You’ll find these fields:

• Contains keyword – Use this field to filter all the products containing a specific keyword
• Enter Tags – Use this field to search for products containing categories, tags, attributes, shipping classes. This same field works for those search methods.
• Run search – Click on it after selecting your search method.

In the Bulk Edit fields, set these values to replace a download file URL in the products filtered.

• What field do you want to edit – Download files
• Select type of edit – Replace
• Replace this – Paste the old URL.
• With this – Paste the new URL.
• Click on Execute now.

5. DELETE download files from hundreds of products

To delete download files from hundreds of products, you need to follow these simple steps:

• Open the Bulk Edit tool. It’s located on the plugin’s toolbar, so just click on it.
• Select the I want to search rows to update option in the Select the rows that you want to update dropdown.

Here you can filter the products you’ll edit. You’ll find these fields:

• Contains keyword – Use this field to filter all the products containing a specific keyword
• Enter Tags – Use this field to search for products containing categories, tags, attributes, shipping classes. This same field works for those search methods.
• Run search – Click on it after selecting your search method.

In the Bulk Edit fields, set these values to delete download file URLs from the products filtered.

• What field do you want to edit – Download files
• Select type of edit – Replace
• Replace this – Paste the URL you’ll delete.
• With this – Leave this field empty.
• Click on Execute now.

You can easily edit downloadable files from WooCommerce products. It’s really simple and fast, and you need no codes at all.