Page Comparison

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
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

...

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

...

: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

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

Magento and SF Org time zone are not the same

...

Default Time Zone

...

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

...

(
[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

\uD83D\uDCCB Related articles

Filter by label (Content by label)

showLabels	false
max	5
spaces	com.atlassian.confluence.content.render.xhtml.model.resource.identifiers.SpaceResourceIdentifier@11ce5
sort	modified
showSpace	false
reverse	true
type	page
cql	label = "kb-how-to-article" and type = "page" and space = "IWS"
labels	kb-how-to-article

Versions Compared

Old Version 4

New Version Current

Key

Magento and SF Org time zone are the same

Magento and SF Org time zone are not the same

Magento and SF Org time zone are not the same

\uD83D\uDCCB Related articles