APIs & Integrations

rcain
Mitglied

Custom Deal Properties not updating over Ecommerce Bridge Sync API

Hi,

 

I wonder if you can help me?

 

I'm integrating our development website running WP/WoooCommerce to a Hubspot free account using the recommended MakeWebBetter plugin for HubSpot-WooCommerce (latest version). It uses the HS Ecommerce Bridge (EB) Sync API, which appears to be what Hubspot recommends for such applications.

 

Also, using the WP filters provided by that plugin, I've extended the Order properties it sends up to Hubspot, with some extra custom order properties that we require.

I've also set up those same custom Deal properties in Hubspot, and ensured that those property fields are displayed in my list of Deals.

 

However, although basic Contact, Product and Order/Deal & Line Item data is synced and appears OK up on Hubspot, the extra custom fields/properties that I have defined, and sent with the sync request, do not appear to populate. I've read through the technical documentation on Hubspot & it seems is if this method should work fine - I can't find any notices to the contrary.

 

As an example of the sync request that is being sent, is (json encoded debug output):

 

################

 

 

 

Request: {
"body":"{
    \"storeId\":\"MTDfVAT-1\",
    \"objectType\":\"DEAL\",
    \"messages\":[{
        \"action\":\"UPSERT\",
        \"changedAt\":\"1606427634000\",
        \"externalObjectId\":1959,
        \"properties\":{
            \"dealstage\":\"shipped\",
            \"dealname\":\"#1959 robaa cainaa\",
            \"closedate\":1606427071000,
            \"order_date\":1606427071000,
            \"order_amount\":\"60.00\",
            \"order_abandoned_cart_url\":\"https://mytestsubdomain.mytestsite.net////checkout////order-pay////1959////?pay_for_order=true&key=wc_order_46TEkC0OOzSzo\",
            \"order_id\":\"1959\",
            \"order_tax_amount\":\"10\",
            \"scl_btcs_mtdfvat_customer_how_find_out_about_us\":\"AutoPro\",
            \"scl_btcs_mtdfvat_hub_account_user_email\":\"test_261120_1aa@mytestemailacct.co.uk\",
            \"scl_btcs_mtdfvat_hub_account_type\":\"Company\",
            \"scl_btcs_mtdfvat_hub_account_id\":\"a0d02c2d-db3f-49f1-8ca7-122a04254907\",
            \"scl_btcs_mtdfvat_hub_code\":\"Created\"
        },
        \"associations\":{
            \"CONTACT\":[\"test_261120_1aa@mytestemailacct.co.uk\"]
        }
    }]
}",
"headers":{
    "Content-Type":"application\/json",
    "Authorization":"Bearer CLKUpL7gLhIDQ4cCGJGzkwQg7enxBSi6yAMyGQA43A7xVALDTBMUWr1a0bRxrK4I8TMbpmM6IAAKJkeaAQyEAri7AAAABUAgAAAAAAAYxADzHwAAAABAQhkAONwO8S1M-TlOwRK68FMjE0zx5OtQQBJJ"
    },
    "method":"PUT"
}

 

 

 

################

 

- you can see from the above, that values are set for the custom properties OK - ie: property names prefixed with '
'scl_btcs_mtdfvat_...' - eg: scl_btcs_mtdfvat_customer_how_find_out_about_us, etc.
- the request itself gets processed OK, and everything else syncs apart from my extra custom properties.
- also, I'm pretty sure that the field-property mapping array is setup properly: - vis:

 

################

 

 

 

...
[DEAL] => Array
        (
        [0] => Array
                (
                    [externalPropertyName] => dealstage
                    [dataType] => STRING
                    [hubspotPropertyName] => dealstage
                )
        ...
        [10] => Array
                (
                    [externalPropertyName] => customer_note
                    [dataType] => NUMBER
                    [hubspotPropertyName] => description
                )
        [11] => Array
                (
                    [externalPropertyName] => scl_btcs_mtdfvat_hub_account_user_email
                    [dataType] => STRING
                    [hubspotPropertyName] => scl_btcs_mtdfvat_hub_account_user_email
                )

            [12] => Array
                (
                    [externalPropertyName] => scl_btcs_mtdfvat_hub_account_type
                    [dataType] => STRING
                    [hubspotPropertyName] => scl_btcs_mtdfvat_hub_account_type
                )

            [13] => Array
                (
                    [externalPropertyName] => scl_btcs_mtdfvat_hub_account_id
                    [dataType] => STRING
                    [hubspotPropertyName] => scl_btcs_mtdfvat_hub_account_id
                )

            [14] => Array
                (
                    [externalPropertyName] => scl_btcs_mtdfvat_hub_account_expiry_date
                    [dataType] => STRING
                    [hubspotPropertyName] => scl_btcs_mtdfvat_hub_account_expiry_date
                )

            [15] => Array
                (
                    [externalPropertyName] => scl_btcs_mtdfvat_hub_code
                    [dataType] => STRING
                    [hubspotPropertyName] => scl_btcs_mtdfvat_hub_code
                )

        )
...

 

 

 

 

################

 

I have tried setting my custom Deal properties to be part of 'Ecommerce' group, and also alternatively, as part of 'Sync Extensions' group - but it makes no difference.

 

Is there something I am missing (eg: some property naming convention I am unaware of), or some other hubspot setting I need to configure to get these custom properties working over the EB Sync API?

 

Many thanks for any help you can provide.

 

 

0 Upvotes
4 Antworten
JasonGGG
Mitglied

Custom Deal Properties not updating over Ecommerce Bridge Sync API

I'm struggling with the same issue, was anyone able to resovle it?

0 Upvotes
Barak
Mitglied

Custom Deal Properties not updating over Ecommerce Bridge Sync API

Hi rcain. 

 

I'm having the same problem. did you find any solution for that? 

 

Thank you

 

0 Upvotes
dennisedson
HubSpot-Produktteam
HubSpot-Produktteam

Custom Deal Properties not updating over Ecommerce Bridge Sync API

Hello @rcain !

Going to tag in a couple of people who know the MakeWebBetter plugin rather intimately 😸

@himanshurauthan , @umakantmwb , would you guys be able to assist here?

 

0 Upvotes
rcain
Mitglied

Custom Deal Properties not updating over Ecommerce Bridge Sync API

Hi there,

 

Thanks for this. However, its somewhat unlikely an issue with the plugin itself, since I've traced the actual calll made to the Hubspot API  - ie. the plugin, & my extensions to it, appear to be working as expected - BUT, hubspot itself isn't updating the custom properties with the values sent to it.

 

Is there any additionall tracing I can perform on hubspot to find out whats happenning to the values sent? Or could someone possibly take a look at how I've set it up - perhaps I've made a mistake there somewhere?

 

Thanks again.

0 Upvotes