Problem

When Shopify orders are converted into Sales Orders in Business Central, only one phone number is retained and always mapped to Sell-to Phone No.

If Shopify has different billing and shipping phone numbers, the billing phone is lost.

Current Behavior

• Shopify Connector stores a single Phone No. on the Shopify Order Header using a fallback hierarchy (order → display → customer → shipping → billing).
• During Sales Order creation, only Sell-to Phone No. is populated.
• Bill-to Phone No. and Ship-to Phone No. are never set from Shopify data.
• Result: Shipping phone is typically prioritized and billing phone is discarded if different.

Source code reference: ShpfyImportOrder, line 378–491, ShpfyProcessOrder, line 93

Impact

• Loss of valid billing contact data
• Incorrect phone numbers for invoicing and customer communication
• Shopify orders contain richer data than the resulting Sales Orders

Suggested Improvement

• Preserve billing and shipping phone numbers separately from Shopify. Extend Shopify Order Header with separate Phone No. fields.
• Map from json:
• billingAddress.phone → Bill-to Phone No.
• shippingAddress.phone → Ship-to Phone No.
• Use Sell-to Phone No. only as a fallback
• Apply existing phone sanitization logic consistently