Download Customer Info and Puchases to csv?

[carpenoctem]

I am setting up a site for people to sign up for a trade show.

 

What I want to find out is if there is a way, that I can download to xls or csv or something like that say there are 5000 attendees.... just a listing of the attendees, and if they signed up for classes at the show... which classes...

 

I am thinking basically of setting up the Show Sign up as one item.... and each class as a different item... so basically I would want the file to show something like.

 

 

Comp Name....|....Cust Name...|....Show Reg..|......Class 1 Signup..|...Class 2.....| etc

company 1......|....Joe Blow......|..........x.........|...............x............|...................

|

company 2......|....Jane Smith...|..........x.........|...............x............|........x.........|

etc

etc

 

 

Is this possible???

[♥geoffreywalton]

Certainly is, guess you would need to write a query joining orders,order products and order product attributs.

 

But this depends on how you set up your products and how you get the customers to register for classes.

[carpenoctem]

Certainly is, guess you would need to write a query joining orders,order products and order product attributs.

 

But this depends on how you set up your products and how you get the customers to register for classes.

 

 

I basically figured that I would set each class up like a product.... and that i would set the registration up as a product.

 

Is that how I should do it? If not.... how should i do it?

 

How do i setup the downloadable thing??