Hello,
I would like to export the last 1000 orders with following fields: order id, customer email, firstname, lastname.
Is there an easy way to export a CSV like this ? I do have access to PHPmyadmin.
Ok I found the solution. I used following SQL query:
SELECT DISTINCT `customer_email`,`increment_id`,`customer_firstname`,`customer_lastname` FROM `sales_flat_order` WHERE status='complete' ORDER BY increment_id DESC LIMIT 1000
