Unpublished all WordPress eCommerce products

Want to bulk unpublish (change from published to draft) all your WordPress eCommerce products at once? The following SQL statement should do the trick.

UPDATE wp_posts SET post_status = 'draft' WHERE (post_type = 'wpsc-product' and post_status = 'publish');

Make sure you backup your database first, just in case!

This entry was posted in Code. Bookmark the permalink.

Leave a Reply

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