BEAR - WooCommerce Bulk Editor and Products Manager Professional

Botoscope is currently in early access

How to bulk edit ACF Select or Multiselect fields

If you have a product field created with ACF (Advanced Custom Fields) as a Select or Multiselect, you can connect it to BEAR and bulk edit it. Here is how.

Step 1 — Add the field to BEAR

  1. Open BEAR → go to the Meta Fields tab
  2. Find your ACF field key — you can see it in ACF under the field group settings (e.g. tk_product_formats_)
  3. Add it as a custom meta column, type string
  4. Click Save meta fields
  5. Go to the Settings tab, enable the new column, click Save

The field now appears as a column in the Products Editor.

Step 2 — Edit values

Click any cell in that column and enter the option key (or keys) you want to set. Keys are the values you defined in ACF when setting up the field choices.

To set a single value:

pdf

To set multiple values, separate them with a comma:

drm, pdf, printed, mobi

Step 3 — Add the save handler

For the comma-separated values to be saved correctly in the database (so ACF reads them back as a proper selection), add the following code to your active theme’s functions.php file:

add_filter('update_post_metadata', function ($check, $object_id, $meta_key, $meta_value) {
    if ($meta_key === 'your_field_key') {
        if (is_string($meta_value) AND strpos($meta_value, ',') !== false) {
            $meta_value = array_map('trim', explode(',', $meta_value));
            $meta_value = array_map('strval', $meta_value);
            update_post_meta($object_id, $meta_key, $meta_value);
            return true;
        }
    }
    return $check;
}, 10, 4);

Replace your_field_key with your actual field key.

Notes

  • Use the option keys, not labels — exactly as defined in ACF field choices
  • A single value without a comma is saved as-is, no special handling needed
  • This works for both Select and Multiselect ACF field types
  • Make sure your child theme loads without errors after adding the code — a PHP mistake in functions.php can break the admin

 

Ref: https://pluginus.net/support/topic/field-added-using-acf-plugin-does-not-appear-as-a-bear-column/