Address not reliably transmitting in Shopify --> Salesforce integration

  • 249Views
  • Last Post 05 September 2019
0
votes
Jens Leweling posted this 30 August 2019

Often the address (Billing and Shipping Address 1 and Address 2) is not transmitted from Shopify to Salesforce. I do see it correctly in Shopify and even via the Query in Skyvia. Interestingly it is transmitted correctly some of the time. 

Could you have a look at why it is only transmitted sometimes?

Thanks

Jens

Order By: Standard | Newest | Votes
0
votes
Mariia Zaharova posted this 30 August 2019

Hi Jens!

 

Please specify package(s) with which this issue occurs.

Thank you and looking forward to your reply.

 

Best regards,

Mariia

0
votes
Jens Leweling posted this 30 August 2019

Hi Mariia,   I have problems with the following two packages.   Shopify FR - Salesforce Schulung with Order - v2

Shopify DE - Salesforce Schulung with Order

  Thanks Jens

0
votes
Mariia Zaharova posted this 02 September 2019

Hi!

 

Thank you for the details.

We have reproduced the issue with not importing the Billing and Shipping Address1/Address 2 data when Expression mapping is used. We will investigate the issue more clearly and let you the news as soon as any is available.

 

Best regards,

Mariia

0
votes
Mariia Zaharova posted this 05 September 2019

Hi Jens!

 

 

We have investigated the issue. It is related to expressions limitations: expressions do not allow to concat NULL values. Please use this Expression for both  Billing and Shipping Address1/Address2:

 

REPLACENULL(ShippingAddress_Address1, "") + " "+ REPLACENULL(ShippingAddress_Address2, "")

 

Please let us know if this helps.

 

Best regards,

Mariia

Close