WooCommerce Products – Bulk Edit Advanced Custom Fields

In this tutorial, we’ll show you how to quickly mass edit advanced custom fields using a powerful bulk editor.

Related tutorials:

The Advanced Custom Fields (ACF) plugin eliminates the limits when it comes to managing and customizing any post type on WordPress. It’s just great to be able to configure our WooCommerce products as we want.

Here’s the list of custom fields you can edit with WP Sheet Editor:

  • Range
  • Text
  • Text Area
  • Button Group
  • Checkbox
  • Radio Buttons
  • Select
  • True / False
  • File
  • Gallery
  • Image
  • oEmbed
  • Wysiwyg Editor
  • Color Picker
  • Date Picker
  • Date Time Picker
  • Google Map
  • Time Picker
  • Accordion
  • Flexible Content
  • Group
  • Tab
  • Clone
  • Repeater
  • Link
  • Page Link
  • Taxonomy
  • User
  • Post Object
  • Relationship
  • Repeater fields
  • Etc.

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:

Advanced Custom Fields plugin to add extra information to WooCommerce products

  • 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.

Edit Advanced Custom Fields individually in WooCommerce

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 advanced 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.

WP Sheet Editor Products Spreadsheet view

How to see the advanced 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.

advanced custom fields on the WP Sheet Editor spreadsheet

How will the advanced 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 change 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 update 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.

woocommerce-products-bulk-edit-advanced-custom-fields

ACF edit text fieldb) Text fields

The Original Price field will appear as a cell where you can enter the prices.

ACF edit selection field

c) Select fields

The Supplier field will appear as a dropdown cell, you can select the values in the dropdown, copy and paste, and drag down to autofill many cells.

ACF edit checkbox fieldd) 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 and paste to other cells, and drag down to autofill.

ACF edit text editor fielde) Text editors

Text editor columns have 2 options: a button to open a TinyMCE/visual editor in a popup to update visually, or double-click in the cell to edit as plain text/html. You can copy and 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 change the address, our spreadsheet will automatically update the latitude and longitude.

ACF edit Google maps field

How to edit advanced custom fields using the spreadsheet

Editing values in the spreadsheet is as simple as modifying an Excel or Google Sheets spreadsheet. You can enter all the info and then click on Save to apply the changes.

Edit Advanced Custom Fields using the WP Sheet Editor Spreadsheet

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 advanced custom fields

With the Bulk Edit tool, you can save thousands of hours and clicks because you can update any field in thousands of products, as in this case, that we’ll edit advanced custom fields.

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.

use bulk edit tool to edit advanced custom fields

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.

search for WooCommerce products to edit through bulk edit tool

Enter the Shirt keyword in Contains keyword and click on Run search to filter the products.

filter WooCommerce products by keyword with search tool

Finally, select these values to mark the Available in Warehouse checkbox for all the selected products:

bulk edit advanced custom fields

  • 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.

advanced custom field "available in warehouse" edited

How simple!

You can perfectly integrate the Advanced Custom Fields plugin with the WooCommerce Products Spreadsheet plugin to customize your products.

The best thing is that now you can edit advanced custom fields in bulk as if you were editing any other field.

Both plugins give you limitless options for customization and management.

Do you need help?

You can receive instant help in the live chat during business hours, or you can contact us and we will help you via email.