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?


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


If you know the solution of this issue, please leave us a reply in Comment section, to update the question.

Wordpress related questions and answers: