Member database (super orders)

[lukefreeman]

Hi,
I was wondering if it is possible to configure super orders (or something else) to display all the information of all the customers that purchased a certain item (membership)?

I am setting up a site for a rowing club and we need to have a database of our paying members, I have set up membership as a shopping item and I noticed you can select all customers who purchased * from super orders. I would like to be able to copy the details (first name, last name, dob, address, suburb, post code, gender, email, phone, fax etc) from a table displayed.

Any ideas?

Cheers,
Luke

[lukefreeman]

Anybody? Help?

[Nungster]

Interesting post. I want to use Zen Cart as a means for my Triathlon club members to purchase products, and renew their membership.

I would like to add fields to the customer order form, and create a membership form too.

[Nungster]

I had a thought about your post.

You could create an EZ page and on that page, display the results from a MySQL select statement.

Be careful about displaying too much information on the web. Definitely password protect the page somehow.

[lukefreeman]

I had a thought about your post.

You could create an EZ page and on that page, display the results from a MySQL select statement.

Be careful about displaying too much information on the web. Definitely password protect the page somehow.

Thank you very much for that, but I am not fluent in MySQL, how would I do that? What MySQL fields am I looking for and how do I get them displayed?

Cheers,
Luke

[Nungster]

There is a table called "Customers"

Browse that table and see if all the information you want displayed is contained in that table.

You would need to build an SQL statement like Select customers_firstname,customers_lastname from customers;

And then display it.


If you want me to do it, PM me and we can arrange something.