Timezone In Multistore

[adeep]

Hi,

I'm using PS Vers. 1.6.1.4 with multishop on. I have three shops with different timezones, but it's impossible to change the timezone for shop 2 and 3.

 

Any idea or solution?

 

Thanks for help.

[prestaRalph]

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.

[douglasbslim]

 

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.