Uncategorized Archives - Freelance Web Developer Manchester | SEO Consultant

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...