Database time zone OpenCart

The module changes and synchronizes PHP and the database time zone using the established time zone of the database connection.

If the time zone of MySQL and PHP does not match, the owner of the site on OpenCart can easily confuse the time of receipt of the order, adding the product. Not understanding when it was actually added, today or yesterday, because the time of the OpenCart site is different from the local time of the administrator.

For example, there are 11 time zones in Russia, if the administrator adds a product in Irkutsk (UTC+8:00 time zone), and a site in Moscow with a time zone (UTC+3:00), then the product will be added to the database with the SQL query now() by writing down the Irkutsk date and time. Therefore, this product will be displayed on the site only after 5 hours. The same goes for adding reviews, promotions, discounts, coupons, vouchers, and so on.

If you change the PHP timezone, make sure it matches the database.