I am trying to fill the description of around 100 Products in a Woocommerce Wordpress site via SQL, however I am fairly new to the SQL language and facing some troubles. I have already figured out how to fill the description, like so:
UPDATE wp_posts SET post_excerpt = '%description goes here%' WHERE post_type = 'product'
WHERE post_type = 'product'
However, here is where I'm facing problems: I am trying to GET all the Product Names (wp_posts with type product) and want to re-use them in the above mentioned update query.
You don't need re-use any data. If you want update that column massively, you can use CONCAT function to concatenate strings.
UPDATE wp_posts SET post_excerpt = CONCAT('This is the description for ',productTitle) WHERE post_type = 'product'