In this tutorial, we’ll show you how to quickly copy download files from one product to hundreds. This is really useful because sometimes you have different products that share the same downloadable files. In that case, you might want to upload them once and then copy the files to all the other products. But how do you copy the downloadable files from one product to two hundred products?
In this article, we’ll show you how you can copy downloadable files between products using the WP Sheet Editor plugin.
You’ll be able to copy files from one product and paste them on many other products individually or paste it on hundreds at once.
1- Install the WooCommerce Products Spreadsheet plugin
WP Sheet Editor provides a Products Spreadsheet where you can see all the product information and you can edit freely.
2- Open the spreadsheet
To open the spreadsheet, go to Sheet Editor > Edit products. You’ll see a spreadsheet containing all your products with their complete information.
3- Copy the file URL from one product
Go to the Download files column and copy the content of the cell you wish. For this, you can RIGHT CLICK + Copy, or you can copy the content using CTRL + C.
4- Paste the file URL to hundreds of products
You’ll have two options to paste the file URL on hundreds of products.
You need to open the Bulk Edit tool to paste the copied URL to all the products you want. You’ll be able to filter and edit thousands of products.
Now you need to filter the products you’ll edit. It’s possible you may not want to edit all downloadable products, so we want to show you how to filter them.
For this, select the I want to search rows to update option in the Select the rows that you want to update dropdown.
You can quickly filter all your downloadable products containing a specific keyword, for example. For this, you just need to enter the keyword in the Contains keyword field.
Then, tick the Enable advanced filters checkbox and select the following values:
- Field key: Downloadable
- Operator: =
- Value: Tick this checkbox
- Click on Run search to filter the products.
Now you need to select these values to paste the copied URL to all the filtered products.
- Select the rows that you want to update: I want to search rows to update
- What field do you want to edit: Download files
- Select type of edit: Set value
- Replace existing value with this value: Paste the file URL
- Click on Execute now to apply the changes.