Okay
  Public Ticket #3652956
Changing Wordpress Timezone
Closed

Comments

  •  6
    João started the conversation

    Hi,

    My website is configured (incorrectly) to UTC timezone and I want to change it to another timezone (UTC+1).  However, when I change it, all existing amelia bookings change to one hour later.  Is there a way to tackle this?


    Thanks,

    João

  •  702
    Stefan replied

    Hello Joao,

    Thanks for reaching out to us. You should have the timezone configured to the nearest city in your timezone, not to UTC or similar. We recommend checking out this article regarding time zones - Time Zones with Amelia

    I hope it helps, but of course, if you have additional questions, feel free to ask.

    Kind Regards, 

    Stefan Petrov
    [email protected]

    Rate my support

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables

  •  6
    João replied

    Hi Stefan.


    Thanks for the reply.

    I should have the timezone configured to the nearest city but, as mentioned in my previous post, i don't.

    I want to correct this but when i change to the nearest city, all the booked appointments are also changed (as per the article you mentioned):

    Please note: If you hard-coded the time zone, and you have booked appointments, once you switch the time zone in WordPress to your city, it will adjust the times in Amelia's appointments to fit the time zone your city is currently in. This happens because (as mentioned above) the times are saved in UTC in the database, and it's adjusted in the plugin programmatically. So, if you have a hard-coded time zone set to UTC+1, and someone booked an appointment for 09:00, that time is saved as 08:00 in the database. When you change the time zone to your city (which is now in UTC+2), the appointment time will be adjusted to the time saved in the database 08:00 + 2:00, so the appointment time will switch to 10:00. The only solution, in this case, is to manually modify the appointment times, but it's the only way to make sure your time zone is properly configured, and that the future appointments will be saved and displayed correctly both for you and your customers on the front-end.


    I need to wait for the next day light savings change (october) so that the site timezone matches my timezone to make this change!


    Thanks for the help.



  •  702
    Stefan replied

    Hello Joao,

    Apologies for the delayed answer. You can try and execute this query on a 'wp_amelia_customer_bookings' table:

    UPDATE wp_amelia_customer_bookings
    SET utcOffset = utcOffset + 60
    WHERE utcOffset IS NOT NULL;

    Please note that this is not a workaround that we recommend, and it's advisable to make a backup before this changes.

    Kind Regards, 

    Stefan Petrov
    [email protected]

    Rate my support

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables