Using MySQL to prepend product names from a specific product category

In WooCommerce I would like to add a few characters to the product name, so they match with a client’s QB SKU.

The products in question are all part of the same product category. I’m hoping there’s a mySql query/command I can tweak to do something like this pathetic pseudocode:

in table wp_posts where category = “a product category” PREPEND “abc_” to product name.

any ideas?

Thanks.

Read more here: Using MySQL to prepend product names from a specific product category

Leave a Reply

Your email address will not be published. Required fields are marked *