Missing orders when exporting

  • enexwhy

    (@enexwhy)


    5 years, 11 months ago

    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

    (@algolplus)

    5 years, 11 months ago

    Hello

    please, section “Misc Settings”, mark option “Enable debug output” , click Preview and copy/paste SQLs.

    thanks, Alex

    Thread Starter enexwhy

    (@enexwhy)

    5 years, 11 months ago

    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.
    Plugin Author algol.plus

    (@algolplus)

    5 years, 11 months ago

    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.