Search code examples
mysqlwordpresswoocommerceexport-to-csv

SQL Query to select all products from WooCommerce with SQL Query

How can I select all the products from WooCommerce (WordPress-Plugin) with all products data, product variations, product type and product prices so that it can export data and use it on some other website?.

I'm using MySQL Workbench to run this SQL Query.

Solution

  • It worked this time with woocommerce > Tools > Export and Import.