Bulk Edit Advanced Custom Fields in WooCommerce Products

Once you have edited advanced custom fields in the spreadsheet, you need to click on Save to apply the changes.

You can edit multiple fields on multiple products, and you just have to save once. This is great because you can forget about opening and editing products individually. You can manage all product data in one place.

How ACF fields appear in the WooCommerce products spreadsheet

You can edit all types of Advanced Custom Fields (ACF) directly in the spreadsheet using WP Sheet Editor. Below is a list of each ACF field type, showing:

• How the field appears in the spreadsheet (e.g., plain text, checkbox, dropdown)
• Examples in parentheses of how each field type can be used for WooCommerce products.

Basic text fields

• Text: Plain text (e.g. product subtitle, short description, SKU alternative, brand name).
• Text area: Larger text (e.g. long product details, care instructions, product highlights).
• Number: Number field (e.g. weight, dimensions, warranty duration).
• Range: Number field (e.g. customer rating range, price tiers).

Choice fields

• Radio button: Dropdown select (e.g. “Is Featured: Yes or No”, “Condition: New/Used”).
• Checkbox: Checkbox group (e.g. included accessories, product tags).
• True / False: Single checkbox (e.g. is bestseller, requires assembly).
• Select: Dropdown (e.g. material type, age group).

Contact & external links

• Email: Plain text (e.g. support email, manufacturer contact).
• URL: Plain text (e.g. external product page, manuals).
• Password: Plain text (rarely used for WooCommerce).
• Link: Adds three columns to the spreadsheet: Title | URL | Target.

Media fields

• Image: Upload or paste URL (e.g. custom label image, size chart).
• Gallery: Multiple images via upload or comma-separated URLs (e.g. lifestyle images).
• File: Upload file or paste URL (e.g. PDF manual, datasheet).
• oEmbed: Paste embed URL (e.g. YouTube demo, Instagram post).

Rich content

• WYSIWYG Editor: Edit HTML or open rich text editor (e.g. formatted product description).

Date & time

• Date Picker: Calendar input (e.g. launch date, expiry date).
• Date Time Picker: Calendar + time selector (e.g. pre-order release date/time).

Design & visual

• Color Picker: Plain text (e.g. primary color as HEX: #1e73be).

Relational fields

• Post Object: Autocomplete selector (e.g. compatible products, bundles).
• Page Link: Autocomplete selector (e.g. return policy, brand info pages).
• User: User selector (e.g. store manager, creator).
• Relationship: Autocomplete selector (e.g. related products, product kits).
• Taxonomy: Term selector (e.g. product type, style, custom tags).

Maps

• Google Maps: Creates 3 columns: Address | Latitude | Longitude (e.g. origin location, store availability).

Search for products based on Advanced Custom Fields

WP Sheet Editor allows you to use any product field as a search filter; you can easily search for products based on custom fields added with the ACF plugin. In fact, you can use multiple fields as search filters for advanced combined searches.

Of course, normally you can search for products by category, keyword, attribute, tag, price, status, product type, etc. But if you add ACF custom fields, you can use those custom fields as search filters.

Quick search

In this example, we will search for all products whose warranty duration is 12 months. We have added the warranty duration field with ACF.

As you can see below, we have filtered all WooCommerce products with warranty duration = 12 months.

Advanced search

Besides the quick search, WP Sheet Editor allows you to run advanced searches using multiple fields as a search filters.

The Search tool allows you to filter products by:

• Keyword in post title and content
• Taxonomy terms like product brands, visibility, categories, tags, shipping classes, attributes, etc.

Besides, it allows you to use advanced filters to search for products based on other fields (including custom fields added with ACF and other plugins).

To use the advanced search filters, you need to tick the Enable advanced filters checkbox and add filters this way:

• Field: Here you need to select the field/column you want to use as a search filter. This includes both standard and custom fields.
• Operator: You can use any of these operators:
  • =
  • != (not equal to)
  • <
  • <= (fewer than or equal to)
  • >
  • >= (higher than or equal to)
  • Any of these values (enter multiple values separated by ; )
  • Contains
  • Not contains
  • Starts with
  • Ends with
  • Character length <
  • Character length >
• Value: Here you need to add the values you want to find or exclude from the search.

Other advanced filters include:

• Exclude this keyword from the search (separate multiple keywords with ; )
• Find these IDs (enter multiple IDs separated by commas, spaces, new lines or tabs).
• Find these URLs (enter one URL per line).
• Date range

In this example, we will use four advanced filters to search for products using these types of custom fields we have added with ACF:

• Number
• Checkbox
• Select
• Color picker

Once you have selected all the search filters you want to use, click on Run search.

Once you run the search, the spreadsheet will display all the products that match the search terms. You can view the active search filters above the spreadsheet, and if you click on a filter, it will be removed from the search. You can also remove all filters if you want.

Being able to search for products using ACF fields as search filters is great because you can find specific groups of products with a few clicks.

How to bulk edit Advanced Custom Fields in WooCommerce products

WP Sheet Editor allows you to bulk edit any field in hundreds or thousands of products. This means you can bulk edit any of the standard WooCommerce fields, such as regular price, featured image, product description, category, any attribute field, etc. But it also means you can edit any custom fields you have added with the Advanced Custom Fields plugin.

You can edit all products, only the products you have manually selected in the spreadsheet, or all products returned by a specific search.

To bulk edit any ACF field in WooCommerce products, you need to open the Bulk Edit tool once you have selected or found/searched for all the products you want to edit.

Once you’re in the Bulk Edit tool, you need to select these values to bulk update any ACF field on all your selected products:

• Select the rows that you want to update: You have these options:
  • Edit all the rows from my current search: This is useful for editing all the products or all the products from a specific search
  • I want to search rows to update and edit all the search results
  • Edit the rows that I selected manually in the spreadsheet
• What field do you want to edit: Here you need to select the ACF field you want to bulk edit. All Advanced Custom Fields are compatible with the Bulk Edit tool.
• Select type of edit: You have multiple options to edit your ACF fields:
  • Set value – Use this to replace all existing values with a new value.
  • Replace – Use this to replace specific values with a new value.
  • Clear value – Use this to remove the existing value and leave the field empty.
  • Append – Use this to append (add after) a value to the existing values.
  • Prepend – Use this to prepend (add before) a value to the existing values.
  • Copy from other columns – Use this to copy the values of other fields into this field. You can copy both from standard fields and from custom fields added with ACF or other plugins.
  • Custom formula
  • PHP Function
• Values: Depending on the type of edit you have selected in the previous field, you will see the necessary fields to set a new value, replace values, etc.
• You can apply this bulk update to parent products only, or edit only product variations of the selected products.
• Once you have configured your bulk update, click on Execute Now to apply the changes in bulk.

That’s how you can bulk edit custom fields added with the Advanced Custom Fields plugin in WP Sheet Editor. You don’t have to open and update products one by one in the normal WooCommerce editor. Instead, you can view all types of ACF custom fields in the spreadsheet, use them as search filters, edit them in the spreadsheet, and bulk update your products by bulk editing ACF fields with a few clicks.