Error in Shopify Sync History Screen

@mralyea , based on the error info, the Inventory Item in the Sales Order details is empty.

If the order is imported from our Shopify connector, we have the code to verify the Inventory Item first before we save the order, if inventory item doesn’t find, we will throw an error message in connector level, but now there is an error message when the system tried to save the order, I think maybe there is a customization code in your instance and changes the item, please check.

This is the same error if you add a new item without the Inventory ID in the Sales Order screen
 

@mralyea , the error above must be related to the customer record, not the order. And it seems that your Shopify store is set up to allow customers to create accounts with their phone number, without an email. Even though it’s convenient for your customers, it’s not a good practice for integration with Acumatica, because in Acumatica, EMAIL is the unique field for a Shopify customer, not the phone number.

P.S. When asking questions, it would be very helpful, if you could provide screenshots with more context (screen, entity, etc.), together with the description of how you get this error (export orders, import orders, export customers, using SYNC HISTORY or PROCESS DATA screens, etc.).

Thank you!

@simonliang91 , have you seen this error before? I can see how it could be related to a customer record, but am really confused after the @mralyea latest comment above.

Thanks!

@mralyea , out of curiosity, after you cleared the phone number on the customer in Acumatica, then imported the order, is the phone number populated again or does it stay blank?

@Yuri Karpenko and @mralyea , this error is from Shopify side, if we push a new customer record to Shopify, Shopify will do the validation for the key info(Email, phone, zip code, etc.), if any of them cannot pass the validation, Shopify will return the error back the our connector. 

For your case, the phone number is existing in another Customer in Shopify store. Usually I will check whether has the same customer in Shopify before we push a new record, we will search the customer by Email first, if Email is empty, we will use the phone number instead. 

@Yuri Karpenko yes I built a generic inquiry earlier to find out if 2 customers possibly shared 1 phone number and in these scenarios that is not the case. Yes I agree, I have seen that on the emails and understand why, the phone number field trying to validate is very odd to me. Would you happen to know if Acumatica is trying to validate this phone number field in any way?

@simonliang91 Okay, in this case I am not trying to sync new customer record. This customer is ordering a second order through the same account. When you say Shopify is kicking back this error, do you know if it is looking at the default address on the Shopify customer account or any address on Shopify (default or not)?

The customer had both and Email and a Phone entered in this case.