cancel
Showing results for 
Search instead for 
Did you mean: 

Custom CSV export for last 1000 orders

   Did you know you can see the translated content as per your choice?

Translation is in progress. Please check again after few minutes.

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 1

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