Mass update WooCommerce product status using phpMyAdmin


After importing your products you might find they’re all set to ‘Private’ so you may want to set them to Published.

NB. Always backup your files and database first!

Simply log onto phpMyAdmin and select your Word Press database.

Click on SQL in the top menu and paste the following code in.

UPDATE wp_posts
SET post_status=’publish’
WHERE post_type=’product’

Click ‘Go’ to run the script.

It took about a second or two to complete on a database with over 1700 products for me.

Much quuicker than 20 at a time with the standard WP bulk edit tool!!

you can also set the post_type to ‘draft’ if you wish…

UPDATE wp_posts
SET post_status=’draft’
WHERE post_type=’product’

How useful was this post?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate this post.

As you found this post useful...

Follow us on social media!

About Author

David Cropley

Dave has been programming computers for over 30 years. It's more of an obsession than a hobby! As well as having his own moderately successful Crystals retail business, Dave used to work as a Web Developer for a company called Radikls, a web design company in the South of the UK. Dave is also a member of the presitgious Havik eSports Team.

Leave a Reply

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