SQL Query to select all products from WooCommerce with SQL Query

Question

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.

wordpress.org/plugins/product-import-export-for-woo reduce your effort. Use this free plugin — mujuonly
– mujuonly, Commented May 30, 2017 at 12:40
it's and old version of woocommerce(2.6) so it;s not working. — Rubin Gajera
– Rubin Gajera, Commented May 30, 2017 at 12:45
@azmat I can not use wordpress itself to export. It's not working. — Rubin Gajera
– Rubin Gajera, Commented May 30, 2017 at 12:56

JJS · Accepted Answer · 2020-03-27 21:20:13Z

1

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

edited Mar 27, 2020 at 21:20

JJS

6,8283 gold badges63 silver badges77 bronze badges

answered May 30, 2017 at 14:08

Rubin Gajera

872 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQL Query to select all products from WooCommerce with SQL Query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related