How can I export my orders?

[jeppe.smith]

Can I export my orders with some sort of sql query from my database? I don't have my shop connected to the database anymore and connecting it again would take a long time, so I really hope there's a kind soul out there who can help me.

[NemoPS]

Well, you can use something *LIKE* this, but it highly depends on what kind of info you need, with this one you'll get everything from orders and order detail

 

SELECT o.*, od.* FROM ps_orders o

LEFT JOIN ps_order_detail od ON (od.id_order = o.id_order)

 

You'll also likely need to join the product_lang table to get product names It's just the simples one up there, but you'll likely need much more info. It's a good one to start with, though