Dealing with variable products can be somewhat problematic. For example, you can have some troubles editing your variable attributes or your variation descriptions. Also, sometimes your variations have a different price from your parent products, and that change can take you hours if you don’t have any help while editing your variable prices.
That’s why in this short article, we’ll show you how easy it is to edit your variable prices from Easy Digital Downloads using the WP Easy Digital Downloads Spreadsheet plugin.
This is really important because sometimes you want to make changes to hundreds of EDD downloads but have little time and cannot open and edit them one by one because that would take you lots of hours.
In this example, we have a download with variable prices, and we have duplicated it several times, so that we have more than one.
Now imagine you have to edit a hundred downloads. You would need to open and edit them one by one with the EDD plugin.
That’s why you need the WP Easy Digital Downloads Spreadsheet. This plugin helps you apply changes to thousands of downloads with just a few clicks because it displays them in a beautiful spreadsheet and contains a powerful Bulk Edit tool.
1. Install the WP Easy Digital Downloads plugin
*You can skip this step if you have the plugin installed and activated.
You can download the plugin here:
Once you install the plugin, you’ll see the downloads’ spreadsheet containing all your downloads and their complete information for you to edit freely.
You’ll find a toolbar with the following tools:
- Add new – This button helps you create new rows in the spreadsheet.
- Search – With this tool, you can search specific rows using different search terms.
- Bulk Edit – This is a powerful tool that helps you apply changes to thousands of rows at once.
- Duplicate – This button helps you create hundreds of copies out of a row.
- Locate cell – Here you can enter a specific cell content and it will take you right to that cell.
If you scroll right in the spreadsheet, you’ll see your downloads’ current variable prices:
Here you could easily change the values just as you would do in a normal spreadsheet, and that way you would be already editing your variable prices. However, if you have hundreds of products, you can use the plugins Bulk Edit tool.
IMPORTANT: How many variable prices can I edit in the spreadsheet?
By default, the spreadsheet will show you three variable price columns, but you may want to add more variable prices, and WP Sheet Editor allows you to do it quickly.
Go to Settings > Advanced Settings.
Once there, go to EDD Sheet and select the number of variable prices to add to the products. For that, use the How many variable prices do you add to the products? field and then click on Save.
2. Edit hundreds of your downloads’ variable prices
These are some simple steps you need to follow in order to edit hundreds of your downloads’ variable prices:
a) Open the Bulk Edit tool
To open the Bulk Edit tool, just click it on the toolbar. This is a powerful tool because with it you can apply thousands of different changes to thousands of products with just a few clicks. It’s designed to make your store management easy and help you save lots of hours.
b) Search the downloads you want to edit
For this you need to select the I want to search rows to update option in the Select the rows that you want to update.
This will open a search tool in order for you to search the downloads you want to edit. It’s important because most of the time you’ll not want to edit all of your downloads but only some of them. That’s what this search tool is for.
Once you open the search tool, you’ll find several search fields:
- Contains keyword – Use this field if you want to look for all downloads containing a specific keyword.
- Status – Here you can select between published and draft downloads.
- Author – Search for all products created by a specific author.
- Enter Download Categories or Download Tags – Enter any of these search parameters.
IMPORTANT: For this example we’ve filtered the downloads by keyword. We’ve chosen the keyword edit as it appears in the titles of the downloads we want to edit.
After choosing the search fields, just hit the Run search button. This button will filter your downloads and take you back to the Bulk Edit tool.
3. Edit your downloads’ variable prices
In the Bulk Edit tool, you need to set these values to change your variable prices:
- Select the rows that you want to edit: I want to select the rows that you want to update
- What field do you want to edit: Variable Price: Amount: 1 (for example)
- Select type of edit: Set value
- Replace existing value with this value: 5.99 (for example)
- Click on Execute now
As you can see, editing your downloads’ variable prices is really simple with the WP Easy Digital Downloads Spreadsheet plugin.
You can download the plugin here: