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
- Open BEAR → go to the Meta Fields tab
- Find your ACF field key — you can see it in ACF under the field group settings (e.g.
tk_product_formats_) - Add it as a custom meta column, type string
- Click Save meta fields
- 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.phpcan break the admin
Ref: https://pluginus.net/support/topic/field-added-using-acf-plugin-does-not-appear-as-a-bear-column/
