Ask your WordPress questions! Pay money and get answers fast! (more info)

How i can edit bulk short description for woocommerce products? WordPress


I have more then 300 products and i whant to edit the short description from DB i have Phpmyadmin but if i make one by one i will finish next week :D

Then my question is how i can bulk edit this short description from MySql Phpmyadmin or other sugestion?

Answers (2)


John Cotton answers:

By "short description" do you mean post excerpt?

If so UPDATE wp_posts SET post_excerpt = 'My bulk change' WHERE post_type = 'product' will do that.

Balanean Corneliu comments:

Yes i think are the wp-excerpt-wrap but are showed down of the price in the product page: Here is the exemple:
The text <blockquote>ALIEN SURFACEâ„¢ este creata dintr-un material ultra-rezistent care acopera intregul device.Transparenta si surprinzator de subtire, este proiectata sa se potriveasca cu prec....</blockquote>

Can be more explicit how i can do that John thank you.

John Cotton comments:

<blockquote>Can be more explicit how i can do that John thank you.</blockquote>

Well, I think the SQL speaks for itself doesn't it? I'm not sure what else I can say about it!

Balanean Corneliu comments:

Sorry im not an SQL expert :D i was waiting for some indication:D to put the code in :D and pres GO :)

But its ok im free to go ahead to learn this thinks to :D

You answer is corect and i have made the modification for all products. You are free to get your prize:D Thank you.


Eric P. answers:

What kind of edit? Are you adding the same text to every entry? appending it to the end of the description? Or putting some fixed text at the beginning? The exact SQL incantation will vary depending on what you're trying to do.

Balanean Corneliu comments:

On we sell just one product but for diferent models, then the description and shortdescription on the product page are the same.

I whant to add "new short description......" to all products because all are the same.

Eric P. comments:

@John Cotton's SQL works for me.

UPDATE wp_posts SET post_excerpt = 'New short description text.' WHERE post_type = 'product'

That sets the "short description" of every product to "New short description text."