Title: Doesn’t export every order
Last modified: July 29, 2019

---

# Doesn’t export every order

 *  Resolved [Jim_Panse](https://wordpress.org/support/users/jim_panse/)
 * (@jim_panse)
 * [6 years, 10 months ago](https://wordpress.org/support/topic/doesnt-export-every-order/)
 * Hey,
 * since the last update round (WooCommerce als got an update) some Orders aren’t
   exporting anymore. I can’t find the culprit. Working Orders and non working orders
   don’t have differences in them. Even if i don’t filter by anything, some orders
   aren’t grabbed. I am a bit lost, why this happens. Already tried to debug the
   plugin and where it grabs the orders. But i am not sure, where to look first.
   Should i search for the order in the database and find differences there?
 * Best!

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

 *  Plugin Author [algol.plus](https://wordpress.org/support/users/algolplus/)
 * (@algolplus)
 * [6 years, 10 months ago](https://wordpress.org/support/topic/doesnt-export-every-order/#post-11776927)
 * hi Jim
 * please, open “Misc Settings”, mark “Enable debug output”, click Preview and paste
   
   SQLs here.
 * thanks, Alex
 *  Thread Starter [Jim_Panse](https://wordpress.org/support/users/jim_panse/)
 * (@jim_panse)
 * [6 years, 10 months ago](https://wordpress.org/support/topic/doesnt-export-every-order/#post-11776955)
 * SELECT ID AS order_id FROM wp_posts AS orders WHERE orders.post_type in ( ‘shop_order’)
   AND 1 AND orders.id IN ( SELECT post_id FROM wp_postmeta AS order_date_completed
   WHERE order_date_completed.meta_key =’_date_completed’ AND (order_date_completed.
   meta_value>0 AND order_date_completed.meta_value >=’1559340000′ ) AND (order_date_completed.
   meta_value>0 AND order_date_completed.meta_value <=’1561931999′ )) AND orders.
   post_status NOT in (‘auto-draft’,’trash’)
    -  This reply was modified 6 years, 10 months ago by [Jim_Panse](https://wordpress.org/support/users/jim_panse/).
 *  Thread Starter [Jim_Panse](https://wordpress.org/support/users/jim_panse/)
 * (@jim_panse)
 * [6 years, 10 months ago](https://wordpress.org/support/topic/doesnt-export-every-order/#post-11776989)
 * Okay, i had a look at the specific postmeta entry for one of the missing orders:
   It seems, like paid_date and completed_date is empty. WooCommerce instead is 
   showing the order as completed. Okay, so it can’t grab those orders. So seems
   to be a Problem with Woo itself or the host crashed down while processing the
   order. Weird! Thank you for the debug tip!
 *  Plugin Author [algol.plus](https://wordpress.org/support/users/algolplus/)
 * (@algolplus)
 * [6 years, 10 months ago](https://wordpress.org/support/topic/doesnt-export-every-order/#post-11777141)
 * hi Jim
 * You can switch to “Order Date” and try >Filter By Order>Status
    thanks, Alex

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

The topic ‘Doesn’t export every order’ 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/)

 * 4 replies
 * 2 participants
 * Last reply from: [algol.plus](https://wordpress.org/support/users/algolplus/)
 * Last activity: [6 years, 10 months ago](https://wordpress.org/support/topic/doesnt-export-every-order/#post-11777141)
 * Status: resolved