How to use MySQL to prepend a string to WooCommerce product names based on the category they are in?

So … I want to add a few characters to a product name in woocommerce so they match with a client’s QB SKU.

The products in question are all part of the same woocommerce 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? thank you very much in advance for any help.

Read more here: How to use MySQL to prepend a string to WooCommerce product names based on the category they are in?

Leave a Reply

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