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.