Handy Woocommerce SQL queries

By October 5, 2016 PHP, SQL, Woocommerce

This post is just a place to store handy SQL queries for Woocommerce.

Get Order and all its information

 

Get Users and billing and shipping addresses in Woocommerce

this bit of sql is based on this post at http://codecharismatic.com/

Get Order Objects (not strictly sql, but seems a good place to drop it)

 

2 Comments

  • Dana says:

    Hey,

    Thanks for the info. After using the 1st query to get an order and all of its information, how would you be able to export it into a sql file to import it to a new database? When I try to export it, sql is not an option. I’m assuming it’s because the query comes back with “current selection does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available.”

    Thanks,
    Dana

    • louie171 says:

      hi Dana,

      not sure I understand properly, you should be able to export the results from most mysql guis ( you can from phpmyadmin).

Leave a Reply