Date column on shop_order is wrong

  • Resolved pteelapat

    (@pteelapat)


    7 years, 1 month ago

    I have had this issue since the beginning. I have set WordPress TimeZone to be matched area but when the new order came through, it seems like Woocommerce set it wrong.
    First, the timing on shop_order page is different from the actually timing (6 hours ahead) but if I clicked to see the order details, under ‘General Details’ section, the dated printed correctly.
    Second, this issue also affect the Report, I can’t see the actually report from period to period since it’s 6 hours ahead. For example, my shop close at 8pm, when the actual time passed 7pm, the new order will be counted as the next day order since it’s 1am (6hrs ahead) on the system.

    Please help me fix this. Thank you soooo much!

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

    (@madeincosmos)

    Automattic Happiness Engineer

    Hi @pteelapat,

    What you describe sounds like a problem with the base server timezone. You can check this in WooCommerce > Status > Server Environment section.

    Screenshot: https://cld.wthms.co/S6elof

    If default timezone is anything different than UTC, the date time calculations will be off. In such case, you can try deactivating all plugins except for WooCommerce to see if some other plugin could be changing the default timezone. If this doesn’t help, please check this with your hosting company, as it will probably require changes in server configuration.

    Cheers!

    Thread Starter pteelapat

    (@pteelapat)

    Hi @madeincosmos,

    Thank you so much for your reply, I have changed the timezone to UTC as suggested and it’s work! You are life saver – Thanks!!!

    madeincosmos

    (@madeincosmos)

    Automattic Happiness Engineer

    Hi @pteelapat,

    Thanks a lot for letting me know, I’m really glad to hear the problem is solved!

    I’ll mark this thread as resolved now. If you have some more questions, feel free to start a new one.

    Have a great weekend!

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Date column on shop_order is wrong’ is closed to new replies.