In this tutorial, we’ll show you how to quickly bulk edit advanced custom fields using a spreadsheet bulk editor.
The Advanced Custom Fields (ACF) plugin eliminates the limits when it comes to managing and customizing any post type in WordPress. It’s just great to be able to configure our WooCommerce products as we want.
We’ve created a field group using the Advanced Custom Fields plugin to add extra information to our products. We’ve added these custom fields:
- Logo: Image field
- Original Price: Text field
- Supplier: Select field
- Available in Warehouse: Checkbox field
The problem: A time-consuming task
If you had to edit these fields in WooCommerce for all your products, you’d have to open the products and edit them one by one.
These are some disadvantages of doing it manually in WooCommerce:
- It’s time-consuming
- It’s a repetitive process
- You can’t do anything else because you need to be focused on that
- You need to open a lot of tabs
The solution: Bulk edit custom fields using a spreadsheet
The WooCommerce Products Spreadsheet plugin displays all your products and their complete information on a spreadsheet, where you can edit values as you do in Excel or Google Sheets.
Besides, it contains an advanced search tool to filter your products and a bulk edit tool to apply massive changes in seconds. Something great is that you’ll be able to bulk edit any of the fields created with ACF.
Once you install and activate the plugin, go to WP Sheet Editor > Edit Products to open the spreadsheet. You’ll see all the products displayed as rows and their fields as columns.
How to see the custom fields on the spreadsheet
You just need to right scroll to find the custom field columns.
If you don’t find them, use the Locate Column field, which is on the toolbar, to find the columns.
IMPORTANT. If the columns don’t appear on the spreadsheet, go to Settings > Scan DB to find fields.
How will the custom fields appear on the spreadsheet?
Something really important is that you don’t have to worry about HTML anymore because the spreadsheet will show the custom fields according to their types.
a) Image fields
The Image fields let you edit in multiple ways:
You can use the button to open the media library to upload images from your computer or select existing images, or you can edit the cell as plain text by entering URLs. You can use external URLs and the external images will be downloaded to your media library automatically or use internal URLs and we just assign the image from the media library.
b) Text fields
The Original Price field will appear as a cell where you can enter the prices.
c) Select fields
The Supplier field will appear as a dropdown cell, you can select the values in the dropdown, copy paste to many cells, and drag down to auto fill many cells.
d) Checkbox fields
The Available in Warehouse field will show as a checkbox so you can easily edit the values by marking the checkbox. You can copy paste to other cells, and drag down to auto fill.
e) Text editors
Text editor columns have 2 options: a button to open a tinymce/visual editor in a popup to edit visually, or double click in the cell to edit as plain text/html. You can copy paste in the cells and drag down to autofill many cells
f) Google Map fields
Google Map fields will provide three columns: one column where you can add any address, one for latitude, one for longitude. When you edit the address, our spreadsheet will automatically update the latitude and longitude.
How to edit custom fields using the spreadsheet
Editing values in the spreadsheet is as simple as editing an Excel or Google Sheets spreadsheet. You can enter all the info and then click on Save to apply the changes.
It’s a great advantage to edit hundreds of cells and save changes just once, without having to open a lot of tabs.
How to bulk edit custom fields
With the Bulk Edit tool, you can save thousands of hours and clicks because you can edit any field in thousands of products. Something great is that you’ll not have server errors because the plugin uses your server resources wisely. It applies massive changes in batches to give your server some rest during the process.
For example, we’ll mark the Available in Warehouse checkbox for all products containing the Shirt keyword on their titles.
For that, just open the Bulk Edit tool with one click on it; it’s on the toolbar.
Now filter all the products with the Shirt keyword.
Just select the I want to search rows to update option to open the search tool.
Enter the Shirt keyword in Contains keyword and click on Run search to filter the products.
Finally, select these values to mark the Available in Warehouse checkbox for all the selected products:
- Select the rows that you want to update: I want to search rows to update
- What field do you want to update: Available in Warehouse
- Select the type of edit: Set value
- Replace existing value with this value: Mark the checkbox
- Click on Execute now
After these simple steps, the Available in Warehouse checkbox will be marked for all the selected products. It’s really simple and fast.
You can perfectly integrate the Advanced Custom Fields plugin with the WooCommerce Products Spreadsheet plugin to customize your products and bulk edit them in minutes.
Both plugins give you limitless options for customization and management.