Skip to content
  • There are no suggestions because the search field is empty.

WooCommerce Time Zone Handling

The CSM app periodically retrieves orders from the CSM sales channel by running the Order Automation. CSM sends a date parameter in the request which Business Central uses to find orders created after the date sent.

In cases where the time zone setting on the demo site is different from the time zone in Business Central, there could be a discrepancy between the times. To account for this, a field has been added to the CSM Sales Channel where the user can enter the time difference between the demo store time zone and UTC (Coordinated Universal Time).

CSM uses the last execution timestamp for the LIST_ORDERS_AFTER API Function to instruct the platform which orders to retrieve. This date is set in CSM using the Business Central/local time. What the WooCommerce needs is the date/time in its own time zone. It will not accept a date in UTC, which standard CSM can do.

CSM for WooCommerce has been customized to determine the date to send by converting the last execution timestamp first to UTC and then into the store time zone, using the store’s defined shop time zone UTC offset value.

For example, a WooCommerce store uses Central Daylight Time (CDT). A customer places an order at 10:30 AM store time.

A Business Central user is accessing the ERP environment in Eastern Standard Time (EST) – (UTC-4), which is one hour ahead of store time. The order placed at 10:30 AM store time would be recorded at 11:30 AM local/Business Central time.

The UTC time that corresponds to 10:30 CDT / 11:30 EST is 3:30 pm UTC. To define a sales channel’s UTC offset:

  • Open the CSM sales channel record for which you want to define a UTC time zone
  • On the Order Management FastTab, enter the appropriate time zone offset in the CSM Shop Time zone UTC Offset field

Keep in mind that the characters allowed in this CSM Shop Time zone UTC Offset field are whole numeric digits. The time entered must not contain special characters. The time is automatically converted into hours. For example, if you enter 1, the time will populate and display 1 hour.