Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

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

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

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

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

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

...