Sync Shopify Orders to D365 Business Central Sales Orders and Invoices

• Automate the transfer of Shopify orders to D365 Business Central.
• Create sales orders for web orders and invoices for Point-of-Sale transactions.
• Prevent duplication of orders by checking for existing records in Business Central.
• Ensure accurate mapping of order details, including customer information and line items.

Triggers on a schedule to fetch new Shopify orders. Filters orders to include only those that are paid. Retrieves fulfillment orders to associate line items with locations. Checks for existing customers in Business Central and creates new ones if necessary. Maps order details and creates sales orders or invoices in Business Central.

1. 1
   Import the workflow template into n8n.
2. 2
   Edit the 'D365 BC Environment Settings' node with your Business Central account details.
3. 3
   Configure the Shopify connection in the 'Shopify' node.
4. 4
   Set required filters in the 'Filter' node for order selection.
5. 5
   Adjust the 'Schedule Trigger' node for desired execution frequency.