Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

help retrieving old orders
 
ericscott
Member
 
Total Posts:  57
Joined:  2008-05-14
 

I have a store that is now defunct. There were three orders from the time I last logged in until the time I took it down that I wasn’t aware of. However, I still have the mySQL database and I’d like to get the last 3 orders out because they’re already paid for. Does anyone know of a SQL script with the inner joins and all that I can run to see this data or what tables to even match up (like orders to customers to products? I explored around a little, and it’s not straightforward. Mainly, I’m confused with the “entity” business.

 
Magento Community Magento Community
Magento Community
Magento Community
 
mike222
Member
 
Total Posts:  41
Joined:  2008-04-07
Austria
 

Hello ericscott,

What version of the shop are you using? Please contact me via private mail. I could eventually provide you a script to export your orders.

Another question is why the shop went down. Is there the possibility to look at what is wrong?

regards,

Michael

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top