A scheduled trigger polls Shopify every three minutes for newly created orders. Each incoming order carries the full payload—customer email, billing address, line items with SKUs and quantities, subtotal pricing, and the unique Shopify order ID—ready for downstream processing.

The customer email from the Shopify order is used to query Dynamics 365 Business Central for a matching customer record. This lookup determines whether the buyer is already known to the ERP or is a first-time purchaser who needs to be onboarded before the order can be booked.

A decision node inspects the customer lookup result. If the response contains a valid customer number, the order is routed directly to sales order creation using the existing Business Central customer. If no customer number is returned, the workflow branches to create a new customer record first.

When the customer already exists in Business Central, a sales order is created immediately. The Shopify order ID serves as the order number, the creation date becomes the order date, and the existing Business Central customer number links the order. Each line item maps the Shopify SKU as the item number with its quantity and presentment subtotal price.

For first-time buyers, a new customer record is created in Business Central. The Shopify customer ID is assigned as the Business Central customer number, the billing first and last name form the display name, and the customer's email is stored. The customer type is set to Person to reflect an individual buyer.

Immediately after customer provisioning, a sales order is generated in Business Central for the new customer. The Shopify order ID is used as the order number, the Shopify customer ID links to the freshly created customer, and each line item carries its SKU, quantity, and original unit price from the Shopify order.