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!