WooCommerce – How to Bulk Edit Downloadable Files

posted in: Guides | 0

Sometimes you’re selling 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 Sheet Editor 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.

You can download the plugin here:

- or - Read more about it

2- Setup the WooCommerce Products Spreadsheet

The setup is easy and it only takes 2 minutes.

Please follow this tutorial for the quick setup.

3- Open the Sheet Editor Plugin

The plugin looks like this:

4- Edit downloadable files URLs

If you want to update individual downloadable files products, do this:

  • Use the “Locate cell” tool.
  • Write “downloadable” in the “Locate cell” field. Hit “Enter” in your keyboard.

After you do that, the tool will take you to the Downloadable files column, so to edit the file URL you need to hit the “Edit files” button in each product.

Once there, you’ll see a new screen that will allow you to make the changes you wish regarding files URLs.

  • Choose a name for the file you’ll add. Write the new name in the “Name” field.
  • Paste the file URL in the “File (URL or path)” field.
  • Hit the “Save changes” button.
  • Repeat the same process with all the products you want to edit.

5- Copy file URL from another product

Sometimes, you may want some products to share the same files because the file has information for both products.

Therefore, to copy a product file URL to another product, you need to first identify the ID of the product you want to copy the URL. To identify it, you need to pay attention to the products’ ID column. This is important because if you have several products with the same words in their names, the ID will help you identify the exact product.

After that, you just need to…

  • Hit the “Edit files” button.
  • Write the Product’s name in the “Copy files from this product” field.
  • Hit the “Copy” button.

Done! Now Women’s T-Shirt has the same URL as the Men’s T-Shirt.

6- How to bulk edit files URLs on thousands of products

What if you want to add downloadable files URLs to hundreds of products? Just follow these simple steps.

a) Open the “Apply changes in bulk” tool.

You open this tool by clicking it in the above part of the spreadsheet.

b) Add downloadable files URLs

  • Check the “I understand it will update the posts from my search” checkbox.
  • Select “Download files” as the field you want to edit.
  • Select “Set value” as the type of edit.
  • Enter the downloadable file URL in the “Enter file URL” field.
  • Hit the “Execute now” button.

7- Done

Did you ever imagine how easy it was to edit thousands of downloadable files URLs with WP Sheet Editor?

You can download the plugin here:

- or - Read more about it

Leave a Reply