Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 12 Next »

Magento and SF Org time zone are the same

Default Time Zone

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

Cases:

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

Salesforce Fiels - Date field = 7/12/2022

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

Query response:
[Date_field__c] => DateTime Object
(
[date] => 2022-07-12 00:00:00.000000
[timezone_type] => 3
[timezone] => UTC

Salesforce Fiels - Date field = 7/12/2022

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

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

4. 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 has changed field: 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

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

5. Magento Attribute = Product: Magento data

Salesforce Attribute = Date field

PC time 15.38

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

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

Salesforce Fiels - Date field = 7/12/2022

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

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

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

Salesforce Fiels - Date field = 7/12/2022

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

Salesforce Fiels - 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)

Cases:

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

Salesforce Fiels - Date field = 12/07/2022

2. Magento Attribute = Product: updated_at

Salesforce Attribute = Date field

PC time 15.48 July 12

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

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

Query response:
[data_field__c] => DateTime Object
(
[date] => 2022-07-12 00:00:00.000000
[timezone_type] => 3
[timezone] => UTC

Salesforce Fiels - Date field = 12/07/2022

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

Salesforce Fiels - Datetime field = 12/07/2022, 07:12 AM

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

Salesforce Fiels - Datetime field = 12/07/2022, 07:16 AM

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

Salesforce Fiels - Date field = 10/07/2022

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

Salesforce Fiels - Datetime field = 10/07/2022, 17:00

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

Salesforce Fiels - Date field = 12/07/2022

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

Salesforce Fiels - Datetime field = 12/07/2022, 01:21

  • No labels