SQL Archives - Freelance Web Developer Manchester | SEO Consultant
0752 - 340 - 6145 info@mattzajac.com

SQL query to export all WooCommerce products

If you want to get all the WooCommerce products ready to be saved into a CSV / Excel file run the following query:   SELECT ID, post_status, post_title, post_content, post_excerpt, guid FROM `wp_posts` WHERE (`post_status` = 'publish' OR `post_status` = 'draft') AND...