Reports date and hour

  • Resolved cristianciuberea

    (@cristianciuberea)


    4 years, 10 months ago

    Hi,

    I try to get the right numbers

    Right now, i exclude all orders from report except completed orders.

    But when i manually export orders using wwpalexport the numbers dont fit

    In one month the difference from what i see in woocommerce admin and what i see in excel is about 2-300 orders and that is alot

    So i was thinking it has something to to with the hour.

    If is a difference for some ours between my report and woo’s that number might have sense.

    But i want beter precision.

    Thank you

Viewing 5 replies - 1 through 5 (of 5 total)
  • Thread Starter cristianciuberea

    (@cristianciuberea)

    I think i found how it works, i only need a confirmation.

    So from my tests and observation, Woocommerce Admin consider the order date the date the status has changed.

    So if i have a order created in 1 january 1.am and the status is changed to completed in 2 january 2.am, he consider the order as from 2 january not 1 when it was created.

    Hello @cristianciuberea,

    I’m sorry you’re having trouble with WooCommerce Admin.

    Unfortunately, I was unable to reproduce the order date changing when the status changes to “completed”.

    When WooCommerce Admin syncs order data for reports, it uses the WC_Order::get_date_created() method.

    How are you changing the order status? Through the Edit Order screen, or some other way?

    What plugins do you have active? Do any of them modify order data?

    Thanks!

    Thread Starter cristianciuberea

    (@cristianciuberea)

    Hi Jeff,

    So maybe i needs to add a little more clarification.

    The question is related to the orders with status Completed

    So i have here an export and you can see that the date of created and completed are different https://prntscr.com/qm5tfm

    So client makes an order, it gets the status processed or on hold(if bank transfer) and then, when the payment is comfirmed gets to status Completed.

    In this case, when filter about the status is completed i see that woo admin gets the date for the report not the created date but the completed date.

    Can you confirm this scenario?

    Thank you

    Hi @cristianciuberea,

    In this case, when filter about the status is completed i see that woo admin gets the date for the report not the created date but the completed date.

    It only uses the WC_Order::get_date_created() option, so if you have something pulling the Completed method then it may be another plugin. What plugins do you have active? Do any of them modify order data?

    Hi there!

    We have not heard back from you in a bit, so I am going to close this thread for now. If you are still experiencing this issue please reply back and let us know, and if there is something new please open a new thread.

    Have a great day!

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Reports date and hour’ is closed to new replies.