ECommerce Bridge not updating contact

Hello,

I am sending sync messages to update contact, however the contact is not being updated.
Note the below:
- No sync error messages areshowing when invoking the SYNC error services (https://api.hubapi.com/extensions/ecomm/v1/sync-status/contact/[integratorObjectId])
- I am sure that the ‘changeOccurredTimestamp’ is updated from the previous sync message call
- I notice that when I change the ‘integratorObjectId’ the sync message is updating the contact correctly but we cannot do this since we are refering this contact in deals as well.
(in the case of the contact It will not create a new contact as the email is actually the primary key)

Thanks in advance

Hi, @CharbelAM.

I’m happy to help, but I’ll need more information to troubleshoot further. Could you please clarify or provide:

  1. Whether you are only seeing this behavior with one contact record, or many.
  2. The Hub ID of the account in which you are attempting to update the contact.
  3. The integratorObjectId of the contact you are attempting to update.
  4. The HubSpot vid value(s) of the contact you are attempting to update.
  5. A sample sync message which failed to update the contact.
  6. Per your “the sync message is updating the contact correctly” statement, whether you mean that a sync message updates the same contact record when you change the integratorObjectId in the sync message, or a different record.

Hello,

Below is my feedback to your questions:

1. Tested on multiple records in multiple HubSpot accounts.

2. Below are two accounts I am working on: 2163007 and 2376643

3. ‘new1_stores/57wnrpsn6i_21375’ of account: 2163007

4. What do you mean by vid Value

5. Here is a sample message

[{
	"integratorObjectId": "new1_stores/57wnrpsn6i_21375",
	"action": "UPSERT",
	"changeOccurredTimestamp": 1552588124,
	"propertyNameToValues": {
		"app_id": "185233",
		"email": "xxx@xxx.com",
		"store": "xxxxxx",
		"first_name": "FIrst",
		"last_name": "Name",
		"id": "21375",
		"company": "",
		"phone": "000000",
		"date_created": "08-Mar-2019 05:23",
		"date_modified": "08-Mar-2019 05:23",
		"store_credit": "0",
		"customer_group": "Default",
		"accepts_marketing": "True",
		"notes": "",
		"street_1": "88 Litchfield Crescent",
		"street_2": "",
		"city": "Long Beach",
		"state": "New South Wales",
		"zip": "2536",
		"country": "Australia",
		"country_iso2": "Australia",
		"address_type": "",
		"ShippingStreet_1": "88 Litchfield Crescent",
		"ShippingStreet_2": "",
		"ShippingCity": "Long Beach",
		"ShippingState": "New South Wales",
		"ShippingZip": "1111",
		"ShippingCountry": "Australia",
		"ShippingCountry_iso2": "Australia",
		"BillingStreet_1": "88 Litchfield Crescent",
		"BillingStreet_2": "",
		"BillingCity": "Long Beach",
		"BillingState": "New South Wales",
		"BillingZip": "1111",
		"BillingCountry": "Australia",
		"BillingCountry_iso2": "Australia"
	}
}]

6. The same message created a new contact successfully while it does not update the contact

Thanks,

Hi, @CharbelAM.

Apologies for the delayed response. To be transparent, I missed your reply. This is partially because I was not tagged in the post. It’s easy for these kinds of replies to fall through the cracks, so please tag me in future messages with @IsaacTakushi.

Thank you for providing that information!

Taking a quick glance at your same sync message, I see that your changeOccurredTimestamp is formatted in seconds. The HubSpot APIs accept UNIX-formatted timestamps in milliseconds, however.

I just ran some tests and replicated the behavior you are seeing: The Ecommerce Bridge allows you to create a contact record with a changeOccurredTimestamp formatted in seconds. If you try to update the same record with another second-formatted timestamp, it will return a 204, but the record will not be updated.

To resolve this issue, pass millisecond timestamps with each sync message.