find & replace within SKU values?
The support doesn work on Saturdays and Sundays, so some Friday requests can be answered on Monday. If you have problems with registration ask help on contact us page pleaseIf you not got email within 24~36 business hours, firstly check your spam box, and if no any email from the support there - back to the forum and read answer here. DO NOT ANSWER ON EMAILS [noreply@pluginus.net] FROM THE FORUM!! Emails are just for your info, all answers should be published only here.
The support doesn work on Saturdays and Sundays, so some Friday requests can be answered on Monday.
Hey there,
I recently purchased BEAR Pro and I'm looking for a way to do a find & replace within SKU values — not replacing the entire SKU, but only a specific part of it.
Example: I have SKUs like BSO-AC-PP40, BSO-LON-PP40, BSO-HAM-PP40 etc. I need to replace only the"PP40" part with"DD40" across all variations, resulting in BSO-AC-DD40, BSO-LON-DD40 etc.
I've found the SKU field in Bulk Edit with options append / prepend / new / replace, but"replace" overwrites the entire SKU value. I also see a {SKU} variable which looks promising, but I couldn't figure out how to use it for partial replacement.
Is there a way to do this in BEAR? If so, could you point me to the right workflow?
Thank you!
Alexander
buchstabenorte.de
Hello Alexander
Thank you for the detailed example — that makes it very clear what you need.
BEAR does not have a native partial find & replace for SKU values. The available SKU operations are: append, prepend, new value, and replace — and as you discovered,"replace" overwrites the entire SKU. The {SKU} variable lets you reference the current value when building a new one (for example, setting the new value to {SKU}-v2), but there is no built-in"find substring and replace it" logic. This kind of targeted string substitution is quite specific and is not part of the current bulk edit feature set.
The good news is there is a very simple workaround using a single SQL query via phpMyAdmin:
- In your WordPress hosting panel, open phpMyAdmin and select your WordPress database OR do it trought https://wordpress.org/plugins/wp-phpmyadmin-extension/
- Go to the SQL tab and run the following query: UPDATE wp_postmeta SET meta_value = REPLACE(meta_value, 'PP40', 'DD40') WHERE meta_key = '_sku';
- Click Go. That's it — all SKUs containing PP40 will have that part replaced with DD40 instantly. (make backup of database there before any actions)
Note: if your WordPress table prefix is not wp_ (some installations use a custom prefix), adjust the table name accordingly. You can check your prefix in wp-config.php.
Welcome!