Import mapping Shopify default address phone number in Customer entity

@mikeho , you can access the default phone number for a customer (assuming, it’s Shopify), using this mapping:

I’m somewhat perplexed by your question, because you can’t really access other phone numbers, only the default one. Am I missing something?

Hi @Yuri Karpenko - in my testing I have found that if a customer has multiple locations under their account in Shopify with different phone numbers associated with each location, when I try sync the phone number associated with the default address (which can be different from the phone number associated with the customer account/record in Shopify) it is syncing one of the other phone numbers associated with a non-default address.

Example:

This customer has 2 different phone numbers associated with their account in Shopify, one ending in “8074” (tied to their account and one of their addresses) and another ending in “4607” (tied to their Default address in Shopify):

I specifically want to sync the phone # associated with the Default address ending in “4607”; I created a test to sync it to the Fax field in Acumatica, however I’m getting the non-Default phone number:

Any thoughts regarding how I can get the “4607” number to sync to a specified field?

@mikeho , you can try this mapping:

Hopefully, it will pull up the first Address, which is a DEFAULT one.

If it doesn’t, then the only way to achieve what you’re trying to do is through a customization to the connector in Acumatica.

LMK what your test shows.

@Yuri Karpenko I tried that mapping and it is sending the phone number ending in “8074”, which again is not the number on the Default Address.

And just to clarify - if I don’t set any import mapping under the Customer entity, the native connector appears to sync the phone number associated with the customer record in Shopify to the Phone 1 field in Acumatica, and the phone number associated with the default address in Shopify to the Phone 2 field in Acumatica.

Ultimately what I’m trying to do is strip the incoming phone number of any “+1” country codes so that it works better with a 3rd party phone system we’re using (Lightspeed Voice). We’ve found that phone numbers that start with “+1” do not get recorded as phone call activities in Acumatica. I can strip out the “+1” from the main phone number associated with the customer record, but I can’t seem to figure out how to do this with the Default Address phone number, as I can’t find the correct method to reference that Default Address phone number in a formula to strip out the “+1”.

Thank you, @Yuri Karpenko. I appreciate you making the effort to test and confirm this!