Jump to content

Timezone In Multistore


Recommended Posts

  • 1 year later...

Hi Enthusiast,

Well somehow the concept of setting a different time zone for each store got missed when the multi-store concept was added.
It requires some work but it is possible to change the datetime an order was placed or updated or a customer added.
In theory this is how it would need to be done.

You must work with a stored procedure in mysql database which would be called by a trigger to return the offset in hours from default time set by the default store.
The trigger would be easy to write and would modify the date_add or date_upd fields in each table you need this for such as customer and orders.

 

This is not a perfect solution but it certainly beats trying to modify the code directly.  Trust me, I've looked and that is NOT a solution.

If anyone else has anything to add, I'm sure it will be welcomed.

Link to comment
Share on other sites

  • 1 year later...

 

Any one has any idea to work around these failures?
Is there a solution, other than direct edit thru sql?
Which tables were involved?

Trying to configure multiple stores in 3 countries within 2 time zones.
These fields cannot be changed:

1. Time zone

2. Language identifier

3. Country identifier.

Thanks.

2018-09-11_9-29-06.png.4d1633715213de72c097739c2a1491bd.png

2018-09-11_9-58-00.thumb.png.79205761d6236995256125d6fee2db6c.png

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...