/
Test DateTime sync

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

 

 

 Related articles

 

Related content

Interval Based Synchronization
Interval Based Synchronization
Integration with Salesforce
More like this
Product2 Lookup
Product2 Lookup
Integration with Salesforce
More like this
Sync type configuring
Sync type configuring
Integration with Salesforce
More like this
Product does not sync to SF after Scheduled update
Product does not sync to SF after Scheduled update
Integration with Salesforce
More like this
MSI Reverse Synchronization Payload
MSI Reverse Synchronization Payload
Integration with Salesforce
More like this
Frozen queue re-sync delay
Frozen queue re-sync delay
Integration with Salesforce
More like this