Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Pulling all orders at once


saxman513

Recommended Posts

Hello All,

I am selling tickets to an event with my shop and have hundreds and hundreds of orders. Is there a way to export every order an the info thats attached to it? I tried to copy the databases but it would take forever to do it by hand. Is there a contrib out there that does this. I need the list for the first performance tonight!!!

 

Thanks

:listen: Musik Makin' Makes Me Mappy. . . I mean, Happy! :listen:

****Play that sax-a-ma-phone! - Homer J. Simpson****

Link to comment
Share on other sites

why not use the odbc connecter from mysql to connect to the database and then import into excel or into access? you can pick and choose what you want from there.

Link to comment
Share on other sites

Thanks for your response John. I'm not to familiar with what your solution. If I did do that, would I still have to go through and link the orders to each customer by the customer_id ? If it is already linked, how would i find info on how to do that? Thanks again for your help!

:listen: Musik Makin' Makes Me Mappy. . . I mean, Happy! :listen:

****Play that sax-a-ma-phone! - Homer J. Simpson****

Link to comment
Share on other sites

Sorry, I didnt see the reply, (didnt get an email to this) anyway, you would go pull the info off the database tables and put into one excel file.

 

John

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...