cancel
Showing results for 
Search instead for 
Did you mean: 

Custom CSV export for last 1000 orders

Custom CSV export for last 1000 orders

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.

1 REPLY

Re: Custom CSV export for last 1000 orders

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