Doesn’t export every order

  • Resolved Jim_Panse

    (@jim_panse)


    5 years, 7 months ago

    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

    (@algolplus)

    hi Jim

    please, open “Misc Settings”, mark “Enable debug output”, click Preview and paste
    SQLs here.

    thanks, Alex

    Thread Starter Jim_Panse

    (@jim_panse)

    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 5 years, 7 months ago by Jim_Panse.
    Thread Starter Jim_Panse

    (@jim_panse)

    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

    (@algolplus)

    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.