Title: Missing orders when exporting
Last modified: July 10, 2020

---

# Missing orders when exporting

 *  [enexwhy](https://wordpress.org/support/users/enexwhy/)
 * (@enexwhy)
 * [5 years, 11 months ago](https://wordpress.org/support/topic/missing-orders-when-exporting/)
 * Hello,
 * I am using an older version of the plugin, v1.5.6; I will not try to update it
   unless absolutely necessary.
 * I have an order dated 02-07-2020.
    When trying to export orders, I define a date
   range of 01-04-2020 to 10-07-2020 (today). However, I do not see this order (
   which is within the date range). I noticed that if I reduced the date range, 
   such as from 01-05-2020 to 10-07-2020, I will see this order.
 * Please help, thank you very much.

Viewing 3 replies - 1 through 3 (of 3 total)

 *  Plugin Author [algol.plus](https://wordpress.org/support/users/algolplus/)
 * (@algolplus)
 * [5 years, 11 months ago](https://wordpress.org/support/topic/missing-orders-when-exporting/#post-13103603)
 * Hello
 * please, section “Misc Settings”, mark option “Enable debug output” , click Preview
   and copy/paste SQLs.
 * thanks, Alex
 *  Thread Starter [enexwhy](https://wordpress.org/support/users/enexwhy/)
 * (@enexwhy)
 * [5 years, 11 months ago](https://wordpress.org/support/topic/missing-orders-when-exporting/#post-13108295)
 * Hi Alex,
 * Thank you for your prompt reply.
 * **Main SQL queries are listed below
    SELECT ID AS order_id FROM wp_471_posts 
   AS orders WHERE orders.post_type in ( ‘shop_order’) AND 1 AND orders.post_date
   >=’2020-04-01 00:00:00′ AND orders.post_date<=’2020-07-10 23:59:59′ AND orders.
   post_status NOT in (‘auto-draft’,’trash’)
    -  This reply was modified 5 years, 11 months ago by [enexwhy](https://wordpress.org/support/users/enexwhy/).
 *  Plugin Author [algol.plus](https://wordpress.org/support/users/algolplus/)
 * (@algolplus)
 * [5 years, 11 months ago](https://wordpress.org/support/topic/missing-orders-when-exporting/#post-13110347)
 * Hello
 * Do you use AWS load balancer ?
    Can you try button “Export w/o progress” ?
 * thanks, Alex

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Missing orders when exporting’ is closed to new replies.

 * ![](https://ps.w.org/woo-order-export-lite/assets/icon-256x256.png?rev=1365554)
 * [Advanced Order Export For WooCommerce](https://wordpress.org/plugins/woo-order-export-lite/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/woo-order-export-lite/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/woo-order-export-lite/)
 * [Active Topics](https://wordpress.org/support/plugin/woo-order-export-lite/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/woo-order-export-lite/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/woo-order-export-lite/reviews/)

 * 3 replies
 * 2 participants
 * Last reply from: [algol.plus](https://wordpress.org/support/users/algolplus/)
 * Last activity: [5 years, 11 months ago](https://wordpress.org/support/topic/missing-orders-when-exporting/#post-13110347)
 * Status: not resolved