URGENT help needed exporting order data (ticket sales for event on Friday night).
I'm doing a web site for a group running a series of inaugural balls this weekend as a volunteer and am desperately seeking a way to pull the data out of Ubercart. They need a way to get a list of all the valid ticket purchases so they can handle the door correctly. The problem is there doesn't seem to be a single working export module for Ubercart right now. I've tried Ubercart Order Export UI (uc_order_export) and EDI Import/Export (uc_edi). The former throws tons of errors looking for non-existant tables and is also not useful for downloading all of our orders at once since it relies on you to select the individual orders to download from a paginated list. The latter module just doesn't seem to do anything and there's no real documentation for it.
At this point, I'll settle for anything, even if it's just a SQL query that I can build into my own custom module, but I need it to be simple enough that I can get them a good pile of data in a hurry. Probably the easiest solution would be a query that would give me all of the orders for a specified product or products listed by name with email and quantity. Then I could run the query separately for each event. The first event is the night after tomorrow so this really is an urgent request.

Ubercart 1 in Drupal 5
Just to clarify.
Sean Robertson
webolutionary@webolutionary.com
Hope this helps
If you need it quick you might try views and this module --> Views: Many Node Export
Solved
I don't think UberCart stores the orders as nodes, only the products. I ended up getting a friend to help me with a SQL query which I was then able to use in PHPMyAdmin to produce an Excel file.
Sean Robertson
webolutionary@webolutionary.com