Timestamp download logging does not match

Hi @blackbird69,

Since time travel isn’t possible something else has to be happening here ??

You mentioned having the timezone set to UTC +1. Have you tried setting it to a city in your timezone instead? It wouldn’t affect previous downloads, but it might affect ones going forward. You could create a test order and make a download and see if it makes the time more consistent.

If it doesn’t, let us know. Also, send over a copy of your time settings. You can use https://snag.gy/ to send a screenshot. Just post the URL to it in your reply.

Let us know how it goes,

I change it from UTC+1 to city timezone. Now we travel faster in time. Download timestamps are 2 hours earlier than the purchase time.

Purchase time: Paid on April 1, 2019 @ 16:18.
Download timestamp: 2019-04-01 14:18:24

https://snag.gy/Bmx3CV.jpg

Hi @blackbird69,

Thanks for the screenshots and further testing. I tested this on my site (New York Time (UTC -4) and see that the download log shows the timestamp in UTC. So that means when customer purchased at 1 pm UTC-4, It shows as 17:00 in the download log.

That would explain why when you’re set to UTC +1 it showed an hour behind, and when set to Copenhagen (UTC +2), it changed to two hours behind.

Hope that clarifies things!

So where do I correct that so the download time-stamp matches WordPress’ timezone?

@blackbird69 I just reviewed the code and it appears there is no way to filter this. The timestamp is set in the timezone of the server and as it is retrieved there is no filter to change the date/time.

It is possible to change the timestamp as the data is being stored with the woocommerce_downloadable_product_download_log_insert_data filter. That filter has the data array passed to it.

Due to the age of this thread I am setting it to resolved. If you still need further assistance you can change the status to not resolved.