In this guide, we will see how to copy download files between WooCommerce downloadable products. You will be able to copy download files using a spreadsheet, or copy them from one product to 100 products at a time.
As you may know, WooCommerce does not allow copying download files between downloadable products.
If you want to set the same download files to several downloadable products, you would have to edit the products one by one. But that would take too much time.
Fortunately, we will show you how to copy downloadable files between products using the WP Sheet Editor plugin.
WP Sheet Editor provides a products spreadsheet where you can see all the products’ data and edit freely.
You can skip this step if you already have the plugin.
You can download the plugin here:
Download WooCommerce Products Spreadsheet Plugin - or - Check the features
Once you install the plugin and activate your license, you need to follow the steps below in order to bulk copy download files between WooCommerce downloadable products.
Open the spreadsheet
To open the products’ spreadsheet, go to Sheet Editor > Edit products.
You’ll see a spreadsheet containing all your products, with their complete data displayed in columns and cells.
Search for the downloadable products
If your store only has downloadable products, you do not have to filter downloadable products.
But if your store has a mix of physical and downloadable products, you can easily filter the downloadable products using the Search tool.
Once you’re in the Search tool, you need to select these values in order to filter the downloadable products only:
- Tick the Enable advanced filters checkbox and select these values:
- Field: Downloadable
- Operator: =
- Value: Yes
- Click on Run search.
Once you run the search, you will view all the downloadable products displayed on the spreadsheet. You’ll also see the active search filters right above the products’ data.
Copy download files between products using the spreadsheet
The WP Sheet Editor plugin creates columns for your product fields.
In the case of downloadable products, the data of the download files are stored in these columns:
- Download files : names
- Download files : URLs
- Download files
The Download files: names and Download files: URLs columns contain the data in text format.
However, the Download files column contains a download file manager for each product.
When you click the Edit files button on any product (row), you will open a popup with a small spreadsheet inside, where you can manage the download files for each product.
If you want to copy the data, both the names and the URLs of the download files, you can right-click on the cell and then click Copy.
You can now paste the data from the download files into any other product using CTRL + V.
If you prefer, you can also autofill the data in the products below, just as you would in Excel or Google Sheets or any other spreadsheet editor.
Once you’re done copying download files data between downloadable products, you need to click on Save to apply the changes.
After saving the changes and reloading the page, you will see that the data in the Download files: names and Download files: URLs columns will be updated automatically.
Copy download files between products in bulk
If you do not want to copy download files between products individually, and you want to copy data from one product to hundreds of products, you can do it using the bulk editor.
Just go to the Download files column and click on the cell of the product from which you want to copy the data.
Above, we have already shown you how to search for downloadable products. If you would like, you can edit all search results.
Optionally, you can use the selector checkbox in the first column of the spreadsheet.
Once you have selected all the products to which you want to paste the data, open the Bulk Edit tool.
Now you must select the following values to set the same download files from one file to hundreds of products:
- Select the rows that you want to update: You can select any of these values:
- Edit all the rows from my current search (including non-visible rows)
- Edit all the rows that I selected manually in the spreadsheet
- What field do you want to edit: Download files
- Select type of edit: Set value
- We will save these files: Paste the values you copied from the cell.
- Select the Edit only parent products option.
- Click on Execute Now.
Once you select these values and run the bulk edit, you will paste the data from the download files of one product to multiple products.
As you can see, with WP Sheet Editor, you can copy download files between WooCommerce downloadable products.
You can download the plugin here:
Download WooCommerce Products Spreadsheet Plugin - or - Check the features