OpenCart Community

All:

Using Opencart 1.4.4 on a clean install.

I'm selling tickets to an event, using multiple ticket types. I need to be able to tell which customers (by name) purchased ticket X and which purchased ticket Y. How can I pull this data? I REALLY don't want to have to go order-by-order for every single ticket puchased, manually copying them to a spreadsheet. Any ideas?

I'm running on a hosted web servive, so I don't have open access to the sql database to do data mining. Is there a good application to mine the backup.sql file from the store? I guess I could install a local copy of mysql on my PC, and then import the backup and data mine from there. Hmmm. Any insight out there folks?

Thanks for the heads-up!

So...do I need to install a separate instance of MySQL locally to use to import the Opencart backup.sql file? I don't really see anywhere to do this from within Zend itself. I have Zend/Apache running successfully.

Yes, I'm retarded.