Test DateTime sync

Owned by Yurii Perevuznyk (Deactivated), created
Last updated: Jul 13, 2022
4 min read

Magento and SF Org time zone are the same

Default Time Zone

(GMT+03:00) Eastern European Standard Time (Europe/Istanbul)

Cases:

Case

PC local Time

request data

mapping result

Salesforce Field

Case

PC local Time

request data

mapping result

Salesforce Field

Magento Attribute = Product: created_at
Salesforce Attribute = Date field

PC time 12.21

Entity Product, SKU date product3, Store ID 0 request data:
[date] => 2022-07-12 12:21:45.000000
[timezone_type] => 3
[timezone] => Europe/Istanbul

Entity Product, SKU date product3, Store ID 0 mapping result:
[Date_field__c] => 2022-07-12 09:21:45

Date field = 7/12/2022

Magento Attribute = Product: updated_at

Salesforce Attribute = Date field

PC time 12.43

Found Product, SKU date product3, Store ID 0 entity and the following data:
[date] => 2022-07-12 00:00:00.000000
[timezone_type] => 3
[timezone] => UTC

Entity Product, SKU date product3, Store ID 0 mapping:
[Date_field__c] => 2022-07-12 09:43:22

Date field = 7/12/2022

Magento Attribute = Product: created_at

Salesforce Attribute = Datetime field

PC time 12.54

Entity Product, SKU date product4, Store ID 0 request data:
[Datetime_field__c] => DateTime Object
(
[date] => 2022-07-12 09:54:58.000000
[timezone_type] => 3
[timezone] => UTC

Entity Product, SKU date product4, Store ID 0 mapping:
[Datetime_field__c] => 2022-07-12 09:54:58

Datetime field = 7/12/2022, 2:54 AM

Magento Attribute = Product: updated_at

Salesforce Attribute = Datetime field

PC time 13.06

Entity Product, SKU date product4, Store ID 0 request data:
[Datetime_field__c] => DateTime Object
(
[date] => 2022-07-12 10:06:43.000000
[timezone_type] => 3
[timezone] => UTC

Entity Product, SKU date product4, Store ID 0 mapping:
[Datetime_field__c] => 2022-07-12 10:06:43

Datetime field = 7/12/2022, 3:06 AM

Magento Attribute = Product: Magento data

Salesforce Attribute = Date field

PC time 15.38

Found Product, SKU date product7, Store ID 0 entity and the following data:
[Date_field__c] => DateTime Object
(
[date] => 2022-07-12 00:00:00.000000
[timezone_type] => 3
[timezone] => UTC

Entity Product, SKU date product7, Store ID 0 mapping:
[Date_field__c] => Jul 12, 2022

Date field = 7/12/2022

Magento Attribute = Product: Magento data

Salesforce Attribute = Datetime field

PC time 15.41

Found Product, SKU date product7, Store ID 0 entity and the following data:
[Datetime_field__c] => DateTime Object
(
[date] => 2022-07-12 00:00:00.000000
[timezone_type] => 3
[timezone] => UTC

Entity Product, SKU date product7, Store ID 0 mapping:
[Datetime_field__c] => Jul 12, 2022

Datetime field = 7/11/2022, 5:00 PM

Magento Attribute = Product: Magento datatime

Salesforce Attribute = Date field

PC time 15.43

Entity Product, SKU date product9, Store ID 0 request data:
[Date_field__c] => DateTime Object
(
[date] => 2022-07-12 18:43:00.000000
[timezone_type] => 3
[timezone] => Europe/Istanbul

Entity Product, SKU date product9, Store ID 0 mapping:
[Date_field__c] => Jul 12, 2022, 3:43:00 PM

Date field = 7/12/2022

Magento Attribute = Product: Magento datatime

Salesforce Attribute = Datetime field

PC time 15.47

Entity Product, SKU date product9, Store ID 0 request data:
[Datetime_field__c] => DateTime Object
(
[date] => 2022-07-12 15:47:00.000000
[timezone_type] => 3
[timezone] => UTC

Entity Product, SKU date product9, Store ID 0 mapping:
[Datetime_field__c] => Jul 12, 2022, 3:47:00 PM

Datetime field = 7/12/2022, 8:47 AM

 

Magento and SF Org time zone are not the same

Magtento Time Zone


SalesForce Time Zone

(GMT -07:00) Pacific Standard Time (America/Los_Angeles)

(GMT+01:00) Irish Standard Time (Europe/Dublin)

 

Case

PC local Time

request data

mapping result

Salesforce Field

Case

PC local Time

request data

mapping result

Salesforce Field

Magento Attribute = Product: created_at
Salesforce Attribute = Date field

PC time 15.32 July 12

Entity Product, SKU "Product test1", Store ID "0" request data:
[date] => 2022-07-12 05:32:21.000000
[timezone_type] => 3
[timezone] => America/Los_Angeles

Entity Product, SKU "Product test1", Store ID "0" mapping result:
[data_field__c] => 2022-07-12 12:32:21

Date field = 12/07/2022

Magento Attribute = Product: updated_at

Salesforce Attribute = Date field

PC time 15.48 July 12

Found Product, SKU "Product test1", Store ID "0" entity and the following data:
[date] => 2022-07-12 00:00:00.000000
[timezone_type] => 3
[timezone] => UTC

Entity Product, SKU "Product test1", Store ID "0" mapping result:
[data_field__c] => 2022-07-12 12:48:27

Date field = 12/07/2022

Magento Attribute = Product: created_at

Salesforce Attribute = Datetime field

PC time 17.12 July 12

Entity Product, SKU "Product test1", Store ID "0" request data:
[data_time_field__c] => DateTime Object
(
[date] => 2022-07-12 14:12:18.000000
[timezone_type] => 3
[timezone] => UTC

Entity Product, SKU "Product test1", Store ID "0" mapping result:

[data_time_field__c] => 2022-07-12 14:12:18

Datetime field = 12/07/2022, 07:12 AM

Magento Attribute = Product: updated_at

Salesforce Attribute = Datetime field

PC time 17.16 July 12

Entity Product, SKU "Product test2", Store ID "0" request data:
[data_time_field__c] => DateTime Object
(
[date] => 2022-07-12 14:16:03.000000
[timezone_type] => 3
[timezone] => UTC

Entity Product, SKU "Product test2", Store ID "0" mapping result:
[data_time_field__c] => 2022-07-12 14:16:03

Datetime field = 12/07/2022, 07:16 AM

Magento Attribute = Product: Magento data

Salesforce Attribute = Date field

PC time 17.50 July 12

Entity Product, SKU "Product test5", Store ID "0" request data:
[date] => 2022-07-10 17:00:00.000000
[timezone_type] => 3
[timezone] => America/Los_Angeles

Entity Product, SKU "Product test5", Store ID "0" mapping:
[data_field__c] => Jul 11, 2022

Date field = 10/07/2022

Magento Attribute = Product: Magento data

Salesforce Attribute = Datetime field

PC time 18.01 July 12

Entity Product, SKU "Product test6", Store ID "0" request data:
[data_time_field__c] => DateTime Object
(
[date] => 2022-07-11 00:00:00.000000
[timezone_type] => 3
[timezone] => UTC

Entity Product, SKU "Product test6", Store ID "0" mapping result:
[data_time_field__c] => Jul 11, 2022

Datetime field = 10/07/2022, 17:00

Magento Attribute = Product: Magento datatime

Salesforce Attribute = Date field

PC time 18.15 July 12

Entity Product, SKU "Product test7", Store ID "0" request data:
[data_field__c] => DateTime Object
(
[date] => 2022-07-12 01:15:00.000000
[timezone_type] => 3
[timezone] => America/Los_Angeles

Entity Product, SKU "Product test7", Store ID "0" mapping:
[data_field__c] => Jul 12, 2022, 8:15:00 AM

Date field = 12/07/2022

Magento Attribute = Product: Magento datatime

Salesforce Attribute = Datetime field

PC time 18.22 July 12

Entity Product, SKU "Product test8", Store ID "0" request data:
[data_time_field__c] => DateTime Object
(
[date] => 2022-07-12 08:21:00.000000
[timezone_type] => 3
[timezone] => UTC

Entity Product, SKU "Product test8", Store ID "0" mapping:
[data_time_field__c] => Jul 12, 2022, 8:21:00 AM

Datetime field = 12/07/2022, 01:21