I am trying to get a custom report to run from my wp e-commerce tables to show the variations and the details of the customer (name, address, contact number etc), and if possible the course that the customer is booked on.
So far I got this far and couldn't work it out for the SQL query as i'm not really that good with SQL:
SELECT ID,value FROM wp_wpsc_submited_form_data
SELECT ID,name FROM wp_wspc_cart_contents
SELECT ID,name FROM wp_wpsc_variation_values
Now the value from submitted_form_data has a few bits of info for each client.. I don't know if this is possible, but the least I want to be able to do is show the customers name, the course from cart contents and the variation value to show the date.
Can anyone help me with the code to make this work?