Hi Dave,

Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.

-

Our developers will work on native integration with WooCommerce, but at the moment, it is not possible.

I can't say an exact ETA when this integration will be finished,

but you can certainly follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;

and our newsletter, so you're informed about new features, bug fixes, freebies, etc.

- Since we don't have a native integration with WooCommerce yet,  pulling the data from its database can only be done with a custom MySQL query.

If you're able to pull the data you need using this, I believe you'll be able to create a report you need. 

A good way to achieve pulling custom SQL Query data from the database can be,

as you did, to experiment using our WPDB SQL Query Constructor tool.

You can also try the other option “Generate a query to MySQL database” which has a 'wider range' of choosing additional SQL Tables,

it is a more 'generic'  SQL Query Constructor Tool.

You can check more details explained about that second Constructor Helper Tool here.

- Please note:

 this tool is not an ultimate query generator. It simply constructs a suggestion of a query. 

We are constantly working to improve it, but SQL is such a complicated and flexible language that full automation for constructing queries is next to impossible. 

Consequently, the more complicated the query, the higher is the probability that it will not return exactly what you need. 

So, you will often need to play around with the resulting query.

You can check out this official page of WP codex,  for help with writing custom Queries.

Another way you can try is, you can first try to make a Custom SQL Query of selecting the Columns+data you need directly in your Database Management Tool,

such as PHPMyAdmin or any other you choose.

Then if you manage to pull the data you need there,

you can prepare a MySQL view (which will return the data that you need, call it e.g. “ViewName” and then build a wpDataTables based on a simple query like "SELECT * FROM ViewName″.

 If you need help with that, you can see our video, where we show an example of using an SQL View in our plugin.

We don't have any integration with another "products/eCommerce Plugin", and we are only planning to add the WooCommerce native integration for the moment.

I hope that helps.